Country/Region:  US
Requisition ID:  22957
Work Model:  Hybrid
Position Type:  Permanent
Salary Range: 
Location:  US - NEW JERSEY CLIENT SITE

Title:  Technical Lead-Data Engg

Description: 

Area(s) of responsibility

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

 

HYBRID ROLE

 

 

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.

Essential job tasks

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.

•            8+ years of leadership experience, includes the management and coordination of an Informatica team.

•            Has experience working with complex SQL.

•            Expertise with integration technologies and processes.

•            Has Query Surge experience.

•            Candidate has window environment experience.

•            Possess knowledge of testing tools and techniques.

•            Has a working knowledge of Kimball design methodology.