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)