Sign upLog in
See more jobs

ETL Development Lead

TechDigital

  • Morristown, NJ
  • 30+ days ago

    Highlights

    The ETL Development Lead will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for our enterprise data warehouse. Yes/No Informatica Power Center Development Oracle/Sql server Guidewire Policy Center Guidewire Claims Center ETL Insurance Domain .

    Numbers & Facts

    LocationMorristown, NJ
    IndustryOther/Not Classified
    Company Size100 to 499 employees

    Description

    Skill Last UsedExperience in Years/monthHands on Exp.
    Yes/No
    Informatica Power Center Development   
    Oracle/Sql server   
    Guidewire Policy Center   
    Guidewire Claims Center   
    ETL   
    Insurance Domain   

    Mandatory:: Informatica Certification is mandatory.
    Note: This role is specifically for Informatica PowerCenter (On-Premise). It does not involve Informatica Cloud (IICS) or cloud-based data integration tools.

    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.
    • Experience in Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.
    • 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
    • Knowledge of testing tools and techniques
    • Responsible for installing, configuring, and managing Informatica PowerCenter on-premise platform.
    • Performs user management, monitors server performance, and handles Repository backups and recovery.
    • Troubleshoots integration issues, applies patches, and ensures high availability and environment stability.
    • Collaborates with developers, DBAs, and infrastructure teams to support ETL processes and optimize performance.
    • Take care of ETL migrations across various environments.

    Similar Jobs