Urgent Informatica Developer Need in OH, In-Person Interview ONLY, Long-term Contract, Rate: $45/hr

Dear Friends,

Please send ONLY Locals or who can attend Initial In-person Interview, No Phone interview

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 The Ohio Department of Education desires to procure a Staff Augmentation Programmer 3 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.   PR3 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 Required / Desired Years Req/Desired Years Used Last Used Meets all role descriptions for the job tile of Programmer 3 (PR3) 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 Bottom of Form

Regards

Ram

sram@smart-itstaffing.com