Informatica Developer/Admin

ROLE LOCATION(S) - Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS.

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 the 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.

· Has a working knowledge of Kimball design methodology. Escalate issues to the right party when required.

TECHNICAL QUALIFICATIONS

· 10+ years of hands-on experience in ETL development for a data warehouse.

· 2+ years of Informatica admin experience.

· 10+ years of hands-on experience in the development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.

· 3+ years of leadership experience, including the management and coordination of an Informatica team.

· Has experience working with complex SQL.

· Expertise with integration technologies and processes.

· Has Query Surge experience. Mandatory

· Candidate has window environment experience.

· Possess knowledge of testing tools and techniques.

· Has a working knowledge of Kimball design methodology.