Senior Informatica ETL Engineer | PowerCenter & WSH

Cloud Analytics Technologies, LLC; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Informatica ETL Administrator to join our data integration team in the United States. You will install, configure, support Informatica runtimes, develop workflows, and integrate with PowerCenter, PowerExchange, and mainframe systems (VSAM, Db2).

Strong SQL and debugging skills are required. 5+ years hands-on experience, excellent communication, and ability to work within a large team are highly valued.

Qualifications

• 5+ years 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 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.

Skills

Informatica ETL Admin

Informatica PowerCenter

PowerExchange

Web Service Hub

Mainframe VSAM

Db2

Oracle

Salesforce

SQL queries

Debugging

Collaboration

Communication

Education

Computer Science degree

Bachelor's in Computer Science

Tools

AWS Glue

Job description

Cloud Analytics Technologies, LLC is seeking an experienced Informatica ETL Administrator to join our data integration team in the United States. You will install, configure, support Informatica runtimes, develop workflows, and integrate with PowerCenter, PowerExchange, and mainframe systems (VSAM, Db2).

Strong SQL and debugging skills are required. 5+ years hands-on experience, excellent communication, and ability to work within a large team are highly valued.