ETL Developer & Administrator

Job Title: Informatica ETL Developer & Administrator Work Location: Pittsburgh, PA / New York, NY (Hybrid - 4 days per week onsite expectations) Duration: 9 Months (Possible extension or conversion to FTE) Interview: 1st Video & 2nd In-person interview This role is focusing 70% Development and 30% Administrator Role Summary: • Seeking an experienced Informatica ETL Developer/Administrator/Production Specialist to support installation, configuration, workflow development, and integration efforts across enterprise systems. • Candidate will work closely with cross-functional teams, understand business requirements, and translate them into effective technical solutions. Key Responsibilities: • Perform Informatica ETL administration including installation, configuration, and support • Develop and maintain ETL workflows • Expose workflows as web services using Web Service Hub (WSH) • Support PowerCenter/PowerExchange environments • Integrate mainframe VSAM & Db2 with Informatica workflows • Write and optimize complex SQL queries • Collaborate with large teams and lead database efforts • Translate business requirements into technical deliverables • Document solutions and communicate with technical and non-technical stakeholders • Troubleshoot and optimize ETL systems • Manage multiple priorities in a fast-paced environment Required Skills & Experience: • 5+ years Informatica ETL administration and workflow development • Experience with: Informatica, WSH, PowerCenter / PowerExchange, Mainframe VSAM & Db2 integration, Oracle, Oracle & Salesforce integration • Strong SQL, debugging, and analytical skills • Ability to work in large teams • Excellent communication and problem-solving abilities Preferred Skills: • AWS Glue • Experience with version upgrades & migration to Informatica Cloud • Financial services / banking / mortgage-backed securities domain experience Education: • Required: Computer Science background • Preferred: Bachelor's degree in computer science