ETL Developer/Administrator

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