Description

You will design and build ETL solutions to integrate on-premise and cloud-based systems using Informatica toolsets.

This role is on-site.

Responsibilities

• Translate business requirements into technical specifications and data mapping designs.
• Develop, document, and test data environments using Informatica IDMC (CDI, CAI) and PowerCenter.
• Analyze system components to identify errors, revise programs, and debug applications.
• Design ETL solutions with optimized performance, including recovery, failover, logging, and alerting mechanisms.
• Participate in architecture, design, and code reviews following the software development lifecycle.

Required Skills

• 5+ years of experience in medium or large operating environments supporting Informatica.
• 4+ years of SQL experience, including developing, modifying, and optimizing complex queries and stored procedures.
• Deep understanding of relational/dimensional data modeling, data integration, migration, and warehousing.
• Experience utilizing Informatica IDMC (CDI and CAI) and PowerCenter workflows.
• Proficiency in Db2, SQL, PL/SQL, JDBC, Mapping, and PowerCenter.
• Experience with Java and J2EE.

Preferred Skills

• Experience developing with Azure Data Factory.
• Previous experience in the banking or insurance industry.

Key Skills

Education

Any Gradute