Informatica ETL Lead

Job
Title:
Informatica
ETL Lead

Location:
NY

Position
Type:  FTE/Permanent

 

Roles
& Responsibilities:

Perform
detailed data analysis to understand the source system data.

Participate
in reviewing the data warehouse data model.

Design high
level ETL process and data flow from source system to EDW.

Review
source to target data mapping document for ETL processes.

Review
physical Database objects including fact tables, dimensions, staging,
materialized views, indexes provided by Data Modeler.

There are
scenarios where the ETL process might not involve Informatica at all and can be
built using only shell scripting – if the source and the target DBs are in the
same database environment.

Shell
scripting with Teradata and solid understand of Teradata utilities like BTEQ,
MLOAD, FASTLOAD etc. is a must. Work with QA Lead and test engineer and review
high level ETL design, source to target data mapping document and be the point
of contact for any ETL related questions.

Coordinate
ETL and database development work with offshore ETL developers and conduct code
reviews.

Work closely
with database administration team and ensure the database is architected and
designed to handle concurrent ETL and reporting query jobs.

Provide
level-4 production support for data warehouse jobs.

 

Role
Specific Skills:

Develop
& unit test Informatica ETL processes for optimal performance.

Develop
& unit test Unix scripts for pre and post loading processes.

Performance
tune Informatica ETL mappings and report queries.

 

Experience
& Exposure Required:

6 to 8 years
of INFORMATICA ETL Strong UNIX and Shell scripting Database Teradata
/DB2/GreenPlum Strong data warehousing ETL jobs experience required Basic
Technical Requirements

Strong
experience implementing Data Warehousing and Business Intelligence solutions.

Strong
experience in Informatica ETL Developer role with strong hands on experience in
developing complex ETL processes using Informatica Power Center.

Strong
experience with Teradata  

 

Desirable
Skills:

Bachelor’s
degree.

 

Capgemini America, Inc and its U.S. affiliates are EEO/AA employers. Capgemini conducts all
employment-related activities without regard to race, religion, color, national
origin, age, sex, marital status, sexual orientation, gender
identity/expression, disability, citizenship status, genetics, or status as a
Vietnam-era, special disabled and other covered veteran status.

Click the following
link for more information on your rights as an Applicant:
http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law