Informatica ETL Developer/Admin

Job Title: Informatica ETL Developer/Admin

Duration: 9+ Months (Possible temp to hire)

Location: Pittsburgh, PA 15258

Onsite Role (4 days a week)

Responsibilities:

Must have 5+ years of experience with Informatica ETL Administration activities like installation/configuration and support as well as ETL workflow development

Web Service Hub (WSH) exposing the workflows as web services

PowerCenter/PowerExchange

Mainframe VSAM and Db2 integration with Informatica workflows

Database concepts and integration with Oracle, mainframe, and Salesforce

Understanding and writing complex SQL queries by using advanced SQL functions

Good debugging skills

Good experience in understanding the business/functional requirements

Must be a team player and must have experience working with a large team

Ability to work within a team and lead database efforts and to document customer requirements, translate into technical designs, and explain technical issues clearly and accurately to both technical and non-technical audiences

Strong problem-solving and interpersonal skills, as well as strong written and oral communication skills

Demonstrated ability to adjust to changing priorities and handle multiple tasks simultaneously Education/Experience:

Bachelor's degree in computer science

Informatica ETL

Web Services Hub (WSH)

PowerCenter/PowerExchange

Virtual Storage Access Method (VSAM)

Db2, Oracle, SQL Preferred Skills:

Experience with AWS Glue is a plus

Informatica Cloud

Salesforce integration

Experience with version upgrades and migration from on-prem to Informatica Cloud is a plus

Experience with financial services, banking applications, and/or mortgage-backed securities is a plus