Blog

ROLE TITLE

ETL/Informatica Developer (Need local profiles only)

ROLE LOCATION

Need local profiles only

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 development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.

·  Candidate should have hands on experience working on Informatica power center application upgrade 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.