Informatica ETL Developer / Administrator / Production Specialist
Job Description
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
- bility 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
Required Skills / Experience
Must have 5+ years of experience with Informatica ETL Administration activities like installation / configuration and support as well as ETL workflow developmentWeb Services Hub (WSH) exposing the workflows as web servicesPowerCenter / PowerExchangeMainframe VSAM and Db2 integration with Informatica workflowsDatabase concepts and integration with Oracle, mainframe, and SalesforceUnderstanding and writing complex SQL queries by using advanced SQL functionsGood debugging skillsGood experience in understanding the business / functional requirementsMust be a team player and must have experience working with a large teambility 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 audiencesStrong problem-solving and interpersonal skills, as well as strong written and oral communication skillsDemonstrated ability to adjust to changing priorities and handle multiple tasks simultaneouslyPreferred Skills / Experience
Experience with AWS Glue is a plusExperience with version upgrades and migration from on-prem to Informatica Cloud is a plusExperience with financial services, banking applications, and / or mortgage-backed securities is a plusRequired Software / Technology
Informatica ETLWeb Services Hub (WSH)PowerCenter / PowerExchangeVirtual Storage Access Method (VSAM)Db2OracleSQLPreferred Software / Technology
WS GlueInformatica CloudSalesforce integrationRequired Education / Certifications
Computer science educational backgroundPreferred Education / Certifications
Bachelor's degree in computer sciencedditional Information :
Duration : 9+ month contract to hire opportunityHybrid Work Model : 4 days onsite required weekly in Downtown Pittsburgh officeRate Range : $57-62 / hr. W2 (based on experience)