Description

You will own the administration, configuration, and development of enterprise ETL workflows using Informatica tools.

This role is on-site.

Responsibilities

• Install, configure, and support Informatica PowerCenter and PowerExchange environments.
• Develop and optimize complex ETL workflows, including Web Service Hub (WSH) exposure.
• Integrate data pipelines with mainframe systems (VSAM, Db2), Oracle, and Salesforce.
• Write and tune advanced SQL queries for performance and accuracy.
• Translate business requirements into technical ETL solutions and debug production issues.

Required Skills

• 5+ years of hands-on experience with Informatica ETL administration and workflow development.
• Deep expertise in Informatica PowerCenter and PowerExchange.
• Experience with Web Service Hub (WSH) for workflow exposure.
• Strong integration experience with Mainframe systems (VSAM, Db2).
• Proficiency in Oracle and Salesforce data integration.
• Advanced proficiency in writing and optimizing complex SQL queries.
• Strong debugging, problem-solving, and communication skills.

Preferred Skills

• Experience with AWS Glue.
• Experience with Informatica version upgrades and migration to Informatica Cloud (IICS).
• Background in financial services, banking, or mortgage-backed securities.

Key Skills

Education

Any Graduate