Senior Informatica ETL Developer & Administrator

Robotic Technologies Automation; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC is seeking a senior Informatica specialist to lead ETL administration and workflow development in a fast-paced enterprise environment. You will install, configure, and support Informatica, design robust data integration, and partner with cross-functional teams to deliver reliable data pipelines.

The role requires deep mainframe integration experience (VSAM, Db2), strong SQL skills, and the ability to translate business requirements into technical solutions.

Qualifications

• 5+ years hands-on Informatica ETL administration and workflow development.
• 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 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.

Skills

Informatica ETL

PowerCenter

PowerExchange

WSH

Mainframe (VSAM)

Db2

SQL

Oracle

Salesforce

Debugging

Requirements translation

Teamwork

Communication

Education

Bachelor's degree in Computer Science

CS-related degree

Tools

AWS Glue

Informatica upgrades

Informatica Cloud (IICS) migration

Job description

ROBOTIC PROCESS AUTOMATION LLC is seeking a senior Informatica specialist to lead ETL administration and workflow development in a fast-paced enterprise environment. You will install, configure, and support Informatica, design robust data integration, and partner with cross-functional teams to deliver reliable data pipelines.

The role requires deep mainframe integration experience (VSAM, Db2), strong SQL skills, and the ability to translate business requirements into technical solutions.