Talent.com
ETL Development Lead

ETL Development Lead

Inherent TechnologiesAlpharetta, Georgia, USA
1 day ago
Job type
  • Full-time
Job description

Position : ETL Development Lead

  • Location : Morristown; NJ; New York; NY; Purchase; NY; Charlotte; NC; Conshohocken; PA; Dallas; TX; Houston; TX; Alpharetta; GA; Chicago; IL; Colorado Springs; CO; Denver; CO; Fargo; ND; Garden City; NY; Jacksonville; IL;
  • Day 1 Onsite

Duration : 1 Years

Note : Insurance domain is mandatory

Preferred : Informatica Certification

Job Description :

The ETL Development Lead will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for our enterprise data warehouse.

  • 7 years of experience in a Lead development role for a data warehouse.
  • 10 years of experience in development maintenance and enhancements of Informatica Mappings Workflows and processes.
  • Experience working with complex SQL for ETL development.
  • Proven hands on experience with development maintenance and enhancements of Informatica Mappings Workflows and processes.
  • Develop new ETL complex 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.
  • Coordinate development work of all Informatica ETL developers which are located offshore and onshore. Allocate work as needed to ensure high quality for their deliverables and support their development.
  • Provide technical support for the administration and production support of Informatica.
  • Provide level three troubleshooting baseline and operational support.
  • Create and maintain best practices and methodologies for ETL development team.
  • Prepare runbooks that describe and support code that is developed as well as production support.
  • Identify improvements to the data warehouse environment. Work with the offshore team to implement these solutions.
  • Know when to escalate issues to the right party as required.
  • Working knowledge of Kimball Inmon Millbrook design methodology.
  • Knowledge of testing tools and techniques

    • Key Skills

    SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

    Employment Type : Full Time

    Experience : years

    Vacancy : 1

    Create a job alert for this search

    Etl Development Lead • Alpharetta, Georgia, USA