Description

You will own the enterprise ETL development lifecycle, focusing on Informatica PowerCenter, IBM Sterling Connect: Direct, and CA ESP Workload Automation.

This role is on-site.

Responsibilities

• Design, develop, and maintain complex mappings, workflows, and sessions using Informatica PowerCenter or IICS.
• Write, optimize, and tune advanced SQL queries and stored procedures to support data pipelines.
• Configure and manage secure data file transfers using IBM Sterling Connect: Direct across internal and external systems.
• Build and monitor automated batch schedules using CA ESP Workload Automation, integrating Informatica jobs and file transfers.
• Perform root-cause analysis for production scheduling abends, pipeline failures, and transmission errors.

Required Skills

• 5+ years of enterprise ETL development and production support experience.
• Expert proficiency in Informatica PowerCenter and/or Informatica Cloud (IICS).
• Strong relational database skills with advanced SQL and PL/SQL.
• Subject matter expertise in IBM Sterling Connect: Direct for managed file transfers.
• Proven experience with CA ESP Workload Automation for job scheduling and dependency management.
• Familiarity with Unix/Linux scripting for automation tasks.

Preferred Skills

• Bachelor's degree in Computer Science or related field.
• Experience with 10+ years in data engineering or ETL roles.

Key Skills

Education

Bachelor's degree