Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:
Primary support will be to provide development and maintenance activities for the national environmental data exchange initiatives. Oracle database, PL/SQL development, and SQL Server Analytical Services (SSAS) skills required in this role.
Complete Description:
The contractor is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team. Contractor will provide support in various business areas for BIT to support the Environmental Data Exchange Node.
Primary support will be to provide development and maintenance activities for the national environmental data exchange initiatives. Tasks performed will include, but are not to limited: creating tables and constraints in Oracle; assisting with mapping of attributes to OpenNode2 staging tables; creating and testing extract, transform and load (ETL) process to Oracle staging tables (backend processing using SSAS and PL/SQL), developing and populating log tables, procedures, data services and test plans; testing flow implementations; assisting with the implementation and deployment of the flows; and contributing to technical documentation. Additional development will include a process to feed a SQL Server Analytical Services cube from an Oracle Database for the Radon program, and routine maintenance for existing flows as needed.
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
Oracle PL/SQL development |
Required |
5 |
Years |
Oracle 11g DB Platform |
Required |
5 |
Years |
SQL Server Analytical Services |
Required |
2 |
Years |
Experience creating tables and constraints in Oracle database |
Required |
2 |
Years |
.Net Web Services development |
Required |
2 |
Years |
Altoova’s Mapforce and XML |
Highly desired |
|
|
Oracle 11g/12c migration testing |
Highly desired |
|
|
Windows Server 2003/2008R2 migration testing |
Highly desired |
|
|
Knowledge of National Environmental Information Network (NEIEN) |
Highly desired |
|
|
Knowledge of Windsor’s OpenNode2 Application |
Highly desired |
|
|
Knowledge of Business Objects |
Highly desired |
|
|
Strong Communication skills, written and verbal |
Required |
|
|
Experience w/ a structured Sys Dev Methodology |
Highly desired |
|
|
Experience writing requirements documents and design documents |
Required |
2 |
Years |