The selected candidate will perform the following duties:                    

- Complete Informatica Extract, Transform, and Load (ETL) work for the office

- Design, develop, test, and execute Informatica objects (mappings, sessions, Mapplets, worklets, and workflows) in development, QA and Production environments

- Utilize Informatica to create deliverables

- SQL data extraction and analysis

- Data analysis and quality assurance

- Requirements gathering

- Design and business rule documentation

- Change control

- Perform quality assurance reviews of ETL processes

- Follow instructions

- Complete assigned tasks efficiently and timely

- Additional scope may be defined during the engagement

Required Skills and Experience:

- Five years’ experience using Informatica PowerCenter Designer, Workflow Manager, and Workflow Monitor (including at least 3.5 years w Version 8.0 or higher)

- Five years’ experience designing and developing Informatica processes

- Five years’ experience testing Informatica processes

- Five years’ experience using Oracle (including at least 2 years with Version 11g)

- Three years’ experience using Microsoft Office

Preferred Skills and Experience:

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

- Two years’ experience writing complex SQL queries and performing data analysis

- One year experience using Microsoft SharePoint

- Excellent verbal communication skills

- Experience with Microsoft Team Foundation Server