Job Requirement Detail
Company : Optghar
Req/job Title : Informatica ETL Lead
Job Ref No : 5644
Post Date : 08/29/2018
Country : USA
Job State/Province : New York
Job City : New York, 06+ Months
PrimarySkill : IT
Experience : 5 - 7
OtherSkill :
Subject : Informatica ETL Lead
Description :

Job Description:

·       Analysis of Business Requirements Document

·       Expectation would be to architect and developTeradata DW ETLs  from different source system/ Error handling / SCD /Develop/Architect junk dimensions to handle ETL performance data. Act as a lead/ Documenting etc.

·       Build & Review Design & UAT Test Cases Documents

·       Informatica ETL Coding and Unit Testing

·       Writing Teradata load scripts and unit testing

·      Reviewing code and setting up the standard

·       Support for SIT & UAT activities for bug fix

·       Support for Production Deployment

·       Proficiency in Informatica Power Center9.6/10.1.x or higher (Designer, Workflow Manager, Workflow Monitor).

·       Complete understanding of code promotionactivities and best practices.

        Experience with Windows Scripting includingtroubleshooting

·       Experience with multiple database platformsincluding Teradata, Oracle, SQL Server, and DB2 iSeries

 

Responsibility:

·       Architect ETLs for Teradata DW usingInformatica.

·       Review legacy ETL and work on developing a planto migrate it to Informatica.

·       Slight Informatica Admin knowledge to help NYCOwith Informatica Admin issues.

·       Dimensional modelling.

        Architect/Develop data pipelines from Omnitureto Teradata (with or without Informatica

·       Onsite-Offshore co-ordination.

·       Rotating on call production support whichinvolves handling NYCO DW production issues during critical batch window (12 AM– 9 AM. Two weeks out of 4 weeks)