Description

You will own the design, development, and modernization of enterprise ETL pipelines, translating legacy IBM DataStage logic into modern platforms like Snowflake and AWS.

This role is remote.

Responsibilities

• Design, develop, and maintain IBM DataStage ETL jobs supporting enterprise data platforms.
• Build and support end-to-end ETL pipelines, ensuring data accuracy, performance, and scalability.
• Analyze DataStage job designs and XML metadata to understand transformation logic and data lineage.
• Leverage AI tools and automation techniques to assist in interpreting legacy ETL logic and accelerating modernization.
• Translate DataStage transformation logic into Snowflake SQL and AWS-based data pipelines.

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 data platforms such as Snowflake, AWS-native services, or data governance tools like Collibra.
• Familiarity with AI-assisted development or automation tools used to understand, parse, or accelerate ETL modernization efforts.

Preferred Skills

• Strong understanding of data warehousing concepts, ETL best practices, and data quality frameworks.
• Excellent analytical, problem-solving, and communication skills.

Key Skills

Education

Bachelor's degree