Senior ETL Developer - DataStage Modernization (Remote)

Ellenco Estágios e Treinamentos; Town of Florida (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

Ellenco Estágios e Treinamentos is seeking a Senior ETL Developer with deep IBM DataStage expertise to design, build, and modernize enterprise ETL pipelines. This role focuses on end-to-end DataStage workflows and translating legacy XML transition logic into modern platforms such as Snowflake or AWS.

The ideal candidate combines strong SQL, UNIX/Linux proficiency, shell scripting, DataStage metadata knowledge, and an ability to apply AI-assisted tooling to accelerate modernization across data

Qualifications

• 6+ years of hands-on IBM DataStage development.
• Proven experience building end-to-end ETL workflows, including extraction, transformation, and load processes.
• 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.
• Strong understanding of data warehousing concepts, ETL best practices, and data quality frameworks.
• Excellent analytical, problem-solving, and communication skills.

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, AWS-based data pipelines, or data governance tooling.

Skills

IBM DataStage

SQL (advanced)

UNIX/Linux

Shell scripting

DataStage metadata/XML

AI-assisted development

Tools

DataStage

Snowflake

AWS

Collibra

Job description

Ellenco Estágios e Treinamentos is seeking a Senior ETL Developer with deep IBM DataStage expertise to design, build, and modernize enterprise ETL pipelines. This role focuses on end-to-end DataStage workflows and translating legacy XML transition logic into modern platforms such as Snowflake or AWS.

The ideal candidate combines strong SQL, UNIX/Linux proficiency, shell scripting, DataStage metadata knowledge, and an ability to apply AI-assisted tooling to accelerate modernization across data