Onsite Senior DataStage ETL Architect - Cloud Modernization

Omm IT Solutions; North Dakota; On-site; USD 110,000 - 150,000; Full time

Job summary

Omm IT Solutions in McLean, VA is seeking a Sr DataStage Developer to modernize enterprise data platforms by designing, developing, and optimizing IBM DataStage ETL solutions, including Snowflake and AWS, with AI-assisted tooling to accelerate modernization.

This 100% onsite role requires strong SQL, UNIX/Linux, and shell scripting skills, collaboration with cloud engineers and governance teams, and delivering scalable, auditable data migration solutions with thorough documentation.

Qualifications

• 6+ years hands-on IBM DataStage development experience.
• Proven end-to-end ETL design and implementation capabilities.
• Strong SQL proficiency with complex joins and performance tuning.
• Experience with UNIX/Linux and shell scripting.
• Familiarity with Snowflake, AWS, and data governance tools like Collibra.

Responsibilities

• Design, develop, and maintain enterprise DataStage ETL workflows.
• Modernize legacy ETL to Snowflake/AWS and metadata platforms.
• Optimize ETL performance via SQL and parallel processing.
• Collaborate with architects, cloud engineers, and governance teams.
• Create technical documentation and participate in code reviews and deployments.

Skills

IBM DataStage

SQL

UNIX/Linux

Shell scripting

XML

ETL

Snowflake

AWS

Collibra

AI-assisted tools

Education

6+ years DataStage experience

Tools

Snowflake

AWS

Collibra

Unix/Linux shell

Job description

Omm IT Solutions in McLean, VA is seeking a Sr DataStage Developer to modernize enterprise data platforms by designing, developing, and optimizing IBM DataStage ETL solutions, including Snowflake and AWS, with AI-assisted tooling to accelerate modernization.

This 100% onsite role requires strong SQL, UNIX/Linux, and shell scripting skills, collaboration with cloud engineers and governance teams, and delivering scalable, auditable data migration solutions with thorough documentation.