Description

You will develop and maintain data integration workflows using ETL tools, focusing on Informatica and mainframe systems.

This role is on-site.

Responsibilities

• Develop and manage ETL workflows using Informatica PowerCenter and PowerExchange.
• Integrate systems by connecting ETL processes with Mainframe sources (VSAM, Db2).
• Write and optimize complex SQL queries for data extraction and transformation.
• Translate business and functional requirements into technical ETL solutions.
• Debug and resolve data integration issues across connected platforms.

Required Skills

• 5+ years of hands-on experience with Informatica ETL Administration (installation, configuration, support).
• Expertise in Informatica PowerCenter and PowerExchange.
• Experience integrating with Mainframe systems (VSAM, Db2).
• Hands-on integration experience with Oracle and Salesforce.
• Advanced proficiency in writing and optimizing complex SQL queries.
• Experience with Web Service Hub (WSH) for workflow exposure.
• Educational background in Computer Science or a related field.

Preferred Skills

• Experience with AWS Glue.
• Experience with Informatica version upgrades and migration from on-prem to Informatica Cloud (IICS).

Key Skills

Education

Any Graduate