Description

You will act as an ETL development subject matter expert integrating on-premise and cloud-based systems.

Responsibilities

• Design ETL solutions based on translated business requirements.
• Develop, document, and test data environments using Informatica ETL toolsets.
• Analyze system components to identify error causes and revise programs.
• Follow the software development lifecycle to design, code, configure, test, debug, and document programs.
• Assist in preparing technical design specifications from functional requirements.

Required Skills

• Minimum 5+ years working in a medium or large operating environment supporting Informatica.
• Minimum 4 years of SQL experience, including developing, modifying, troubleshooting, and optimizing complex queries and stored procedures.
• Deep understanding of relational/dimensional data modeling and data mapping design.
• Design and implementation of ETL solutions with optimized performance.
• ETL Development experience including jobs recovery, failover, logging, and alerting mechanisms.
• Experience utilizing Informatica IDMC (CDI and CAI) and Power Center.
• Proficiency with Java, J2EE, Database, DB2, SQL, PL/SQL, and JDBC.

Preferred Skills

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

Key Skills

Education

Any Gradute