Description

You will own the development, administration, and optimization of enterprise ETL pipelines using Informatica.

This role is on-site.

Responsibilities

• Install, configure, and administer Informatica ETL environments, ensuring stability and performance.
• Design and build ETL workflows to integrate data from Mainframe VSAM, Db2, Oracle, and Salesforce.
• Develop and maintain Web Service Hub (WSH) components to expose workflows as web services.
• Write, optimize, and validate complex SQL queries for data processing and quality assurance.
• Debug, troubleshoot, and resolve production issues within data workflows and integrations.

Required Skills

• 5+ years of experience with Informatica ETL Administration and Development.
• Deep expertise with Informatica PowerCenter and Web Service Hub (WSH).
• Proven experience integrating Mainframe VSAM and Db2 data sources.
• Strong proficiency in Oracle and Salesforce data integration.
• Advanced SQL skills with a focus on query optimization and performance tuning.
• Experience with production support and debugging complex data issues.
• Bachelor's degree in Computer Science or a related technical field.

Key Skills

Education

Bachelor's degree