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

Required Skills & Experience (Must-Have)

5+ yearsof hands-on experience withInformatica ETL Administration(installation, configuration, support) andETL workflow development.

Proven expertise withInformatica PowerCenterandPowerExchange.

Experience withWeb Service Hub (WSH)for workflow exposure.

Strong experience integrating withMainframe systems (VSAM, Db2).

Solid understanding of database concepts and hands-on integration experience withOracleandSalesforce.

Advanced proficiency in writing and optimizingcomplex SQL queries.

Excellentdebuggingandproblem-solvingskills.

Demonstrated ability to understand and translate business/functional requirements.

Proven experience as a collaborativeteam playerwithin a large team structure.

Outstandinginterpersonal, written, and oral communication skills.

Ability to adjust to changing priorities and manage multiple tasks.

Preferred Skills & Experience (Nice-to-Have)

Experience withAWS Glue.

Experience withInformatica version upgradesandmigration from on-prem to Informatica Cloud (IICS).

Background infinancial 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.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).

Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status.

ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.