Overview
Skills
Job Details
Informatica Developer/Administrator
Location: Pittsburgh, PA (Hybrid 4 days per week onsite)(Open to relocation candidates, virtual interviews)
Duration: 9 months (likely extensions)
Interview: 2 Virtual Interviews; Offer
Notes:
***Open to H1B transfer candidates
***Open to Relocation candidates***
***Open to Virtual Interviews***
*** MUST HAVE experience with PowerExchange connector to read the VSAM files. 90% of the data will be coming from that source.***
Technical Skills:
- Informatica
- PowerExchange/PowerCenter
- Mainframe/VSAM
- Oracle
- SQL
- Migration experience from on-prem to Cloud
Job Description:
SELLING THE ROLE | |
Job Description | Informatica ETL Developer/Administrator/Production Specialist
The ideal candidate will possess the below: 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 Experience with AWS Glue is a plus 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 Computer science educational background, degree preferred |
TALENT PROFILE | |
Required Skills/ Experience | Must have 5+ years of experience with Informatica ETL Administration activities like installation/configuration and support as well as ETL workflow development Web Services 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 |
Preferred Skills/ Experience | Experience with AWS Glue is a plus 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 |
Required Software/ Technology | Informatica ETL Web Services Hub (WSH) PowerCenter/PowerExchange Virtual Storage Access Method (VSAM) Db2 Oracle SQL |
Preferred Software/ Technology | AWS Glue Informatica Cloud Salesforce integration |
Required Education/ Certifications | Computer science educational background |
Preferred Education/ Certifications | Bachelor s degree in computer science |
PROCESS & EXPERIENCE | |