Job ID :
5538
Company :
Commonwealth of Pennsylvania
Location :
HARRISBURG, PA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
22 Jul 2014
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