ETL Informatica Developer/Admin

Required Skills & Experience (Must-Have)

• 5+ years of hands-on experience with Informatica ETL Administration (installation, configuration, support) and ETL workflow development.
• Proven expertise with Informatica PowerCenter and PowerExchange.
• Experience with Web Service Hub (WSH) for workflow exposure.
• Strong experience integrating with Mainframe systems (VSAM, Db2).
• Solid understanding of database concepts and hands-on integration experience with Oracle and Salesforce.
• Advanced proficiency in writing and optimizing complex SQL queries.
• Excellent debugging and problem-solving skills.
• Demonstrated ability to understand and translate business/functional requirements.
• Proven experience as a collaborative team player within a large team structure.
• Outstanding interpersonal, written, and oral communication skills.
• Ability to adjust to changing priorities and manage multiple tasks.

Preferred Skills & Experience (Nice-to-Have)

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

Education & Certifications

• Required: Educational background in Computer Science or a related field.
• Preferred: Bachelor’s degree in Computer Science.

Interview Process

1. Round 1: 60-minute interview conducted via Microsoft Teams video.
2. Round 2: 60-minute in-person interview at our Pittsburgh office.

Required Software/Technology: Informatica ETL, Web Services Hub (WSH), PowerCenter/PowerExchange, VSAM, Db2, Oracle, SQL.

Preferred Software/Technology: AWS Glue, Informatica Cloud, Salesforce integration.