Description

Design, develop, and maintain enterprise-scale IBM DataStage ETL workflows. Modernize legacy ETL into Snowflake, AWS, or metadata platforms like Collibra.

This role is on-site.

Responsibilities

• Build end-to-end ETL workflows using IBM DataStage for extraction, transformation, and load processes.
• Analyze DataStage job metadata and XML transition logic to translate legacy logic into modern data platforms.
• Optimize ETL performance using advanced SQL, parallel processing, and UNIX/Linux shell scripting automation.
• Partner with architects and cloud engineers to deliver scalable, secure, and auditable data migration solutions.
• Produce technical documentation, participate in code reviews, testing, and deployment while promoting ETL best practices.

Required Skills

• 6+ years of hands-on experience with IBM DataStage development.
• Strong expertise in SQL, including complex joins, subqueries, window functions, and performance tuning.
• Solid knowledge of UNIX/Linux fundamentals, including file systems, permissions, and process management.
• Hands-on experience with shell scripting (bash/ksh) for job automation and operational support.
• Experience working with DataStage job metadata and XML transition logic.
• Ability to analyze and translate legacy ETL logic into modern platforms like Snowflake or AWS.
• Strong understanding of data warehousing concepts, ETL best practices, and data quality frameworks.

Preferred Skills

• Experience with Collibra or other enterprise metadata and data governance platforms.
• Familiarity with AI-assisted development tools for code analysis or ETL modernization.
• Experience with CI/CD pipelines and DevOps practices for data engineering.

Key Skills

Education

Bachelor's degree