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