Description

You will design, build, and maintain ETL workflows and administration tasks using Informatica PowerCenter and PowerExchange.

This role is on-site.

Responsibilities

• Manage Informatica ETL administration, including installation, configuration, and support.
• Develop and optimize complex ETL workflows, leveraging Web Service Hub for workflow exposure.
• Integrate data with Mainframe systems (VSAM, Db2), Oracle databases, and Salesforce.
• Write and tune advanced SQL queries to ensure high performance and data integrity.
• Translate business requirements into technical solutions and debug complex integration issues.

Required Skills

• 5+ years of hands-on experience with Informatica PowerCenter and PowerExchange.
• Strong expertise in Informatica ETL Administration and workflow development.
• Experience with Web Service Hub (WSH).
• Proven ability to integrate with Mainframe systems (VSAM, Db2).
• Advanced proficiency in SQL query writing and optimization.
• Hands-on integration experience with Oracle and Salesforce.
• Bachelor’s degree in Computer Science or a related field.

Preferred Skills

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

Key Skills

Education

Bachelor's degree