Previous Job
Senior Tech Lead
Ref No.: 18-53011
Location: New York, New York
Start Date: 09/24/2018
Title: ETL Teradata  Tech Lead
Location: New York. NY
4   Analysis of Business Requirements Document
4   Expectation would be to architect and develop Teradata DW ETLs  from different source system/ Error handling / SCD / Develop/Architect junk dimensions to handle ETL performance data. Act as a lead / Documenting etc.
4   Build & Review Design & UAT Test Cases Documents
4   Informatica ETL Coding and Unit Testing
4   Writing Teradata  load scripts and unit testing
4   Reviewing code and setting up the standard
4   Support for SIT & UAT activities for bug fix
4   Support for Production Deployment
    Proficiency in Informatica Power Center 9.6/10.1.x or higher (Designer, Workflow Manager, Workflow Monitor).
      Complete understanding of code promotion activities and best practices.
        Experience with Windows Scripting including troubleshooting.
4    Experience with multiple database platforms including Teradata, Oracle, SQL Server, and DB2 iSeries
  1. Architect ETLs for Teradata DW using Informatica.
  2. Review legacy ETL and work on developing a plan to migrate it to Informatica.
  3. Slight Informatica Admin knowledge to help NYCO with Informatica Admin issues.
  4. Dimensional modelling.
  5. Architect/Develop data pipelines from Omniture to Teradata (with or without Informatica)
  6. Onsite-Offshore co-ordination.
  7. Rotating on call production support which involves handling NYCO DW production issues during critical batch window (12 AM – 9 AM. Two weeks out of 4 weeks)