Job ID :
877
Company :
State of Ohio
Location :
columbus, OH
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team.  ETL Developer for Expansion of the Statewide Longitudinal Data Warehouse to include additional data

Complete Description:

The Ohio Department of Education desires to procure a Staff Augmentation Programmer  candidate that has extensive experience in the following areas:

Informatica PowerCenter 8 (Designer, Workflow Manager, and Workflow Monitor)

Oracle 10 - SQL, Query tuning, Schema (table, view, synonym definition and troubleshooting)

Microsoft Office Tools (Outlook, Excel, Word, Access)

Design skills - Read specifications and design and code software to create described functionality.

Testing skills - Create and run test scenarios that fully test created software components.

 

ODE is looking for an individual with proven problem solving skills and the ability to research and resolve issues with limited guidance.

The primary role of the Informatica Developer is to design, develop, test, and utilize Informatica to generate the defined deliverables, to perform quality assurance reviews of ETL (Extract, Transform, Load) processes, to perform data analysis and other tasks as assigned.  The contractor will be expected to follow agreed guidelines, and to complete assigned tasks efficiently and timely.

 

The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team. Programmers typically are involved in maintenance (including production support), enhancement and development work. Programmers have a range of skills and knowledge of the technologies used and applications supported by the Application Team. The Programmer works with the Functional Architect and Technical Architecture Specialist on an as needed basis to ensure that design and code meets customer requirements.

 

Years of Relevant Experience:

6 to 7 years

Preferred Education:

4 year college degree or equivalent technical study.

Role Description:

All roles specified in PR2 plus the following:

•Plan all required process steps.

•Review and understand the Application Team’s workplan.

•Provide status of work to Team Lead.

•Anticipate, identify, track and resolve issues and risks affecting own work and work of the Application Team. Develop contingency plans as necessary.

•Engage in ongoing process improvement.

•Detailed functional and process knowledge.

•Utilize deep modeling, design and coding skills.

•Provide expertise in one or more database environments.

 

Skills:

Meets all role descriptions for the job tile of Programmer  as defined by the MSP

Required

 

Minimum 5 years’ experience using Informatica PowerCenter Designer, Workflow Manager, and Workflow Monitor

Required 5 Years

 

6 months to i year experience using Informatica PowerCenter Designer, Workflow Manager, and Workflow Monitor with Version 9.0 or higher

Required 1 Years

 

Minimum 5 years’ experience designing and developing Informatica processes.

Required 5 Years

 

Minimum 5 years’ experience testing Informatica processes

Required 5 Years

 

Minimum 4 years’ experience working with Data Warehousing (loading data from disparate sources to a data warehouse)

Required 4 Years

 

Minimum 5 years’ experience using Oracle.

Required 5 Years

 

Minimum 3 years’ experience using Microsoft Office.

Required 3 Years

 

2 years’ experience writing complex SQL queries and performing data analysis

Highly desired 2 Years

 

At least 2 years experience with Oracle Version 11g

Highly desired 2 Years

 

1 year experience using Microsoft SharePoint.

Highly desired 1 Years

 

Bachelor’s degree or higher in Computer Science or related field.

Highly desired

 

Excellent verbal communication skills (to be rated at the onsite interview)

Required