Informatica Developer - Multiple Location

Role: Informatica Developer

HYBRID - 3 days onsite

Long Term Contract

Insurance Domain

Location - Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, 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.

TECHNICAL QUALIFICATIONS:
•    10+ years of hands-on experience in ETL development for a data warehouse.
•    5+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
•    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.