Job Title: ETL Developer/AdminDuration: 9+ Months (Possible temp to hire)Location: Pittsburgh, PA 15258Onsite 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