Senior/Lead Informatica Developer - AA2IT

Working time from 9 am to 5 pm EST
Office 3 times per week
Preferred Locations: Purchase, NY; Morristown, NJ; Charlotte, NC; Chicago, IL;
Colorado Springs, CO; Dallas, TX; Fargo, ND; Garden City, NY; Houston, TX;
Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Topeka, KS

ROLE SUMMARY
The Informatica Developer will be primarily responsible for developing and supporting ETL
code in Informatica PowerCenter for an enterprise data warehouse.

ROLE RESPONSIBILITIES
· Develop new ETL and enhancements and modify existing code using Informatica
PowerCenter.
· Work independently to develop, configure, and unit test programs from specs (source to
target mappings).
· Work closely with data architects, reporting team and application team on ETL
development efforts.
· Design and document ETL solutions for projects, estimate work effort and provide status
of tasks.
· Provide technical support for the administration and production support of Informatica.
· Provide first and second level troubleshooting, and baseline and operational support.
· Adhere to best practices and methodologies for ETL development team.
· Present all work in design and code review sessions to senior team members.
· Prepare documents that describe, and support code developed.
· Identify improvements to the data warehouse environment. Work with the team to
implement these solutions.
· Escalate issues to the right party when required.
· Work closely with the Informatica development team for code migrations on a daily
basis, perform other admin activities.

TECHNICAL QUALIFICATIONS
· 10+ years of hands-on experience in ETL development for a data warehouse.
· 10+ years of hands-on experience in the development, maintenance, and
enhancements of Informatica Mappings, Workflows, and processes.
· Candidate should have hands-on experience working on Informatica power center
application upgrades or new installation of the application servers.

· Experience working with complex SQL.
· Expertise with integration technologies and processes.
· Experience working with Query Surge.
· Experience with window environment.
· Possess knowledge of testing tools and techniques.
· Working knowledge of Kimball design methodology.

#ZR