Senior DataStage Data Engineer — Enterprise ETL & Snowflake

Kavaliro; Cincinnati (OH); On-site; USD 120,000 - 160,000; Full time

Job summary

Kavaliro is seeking a senior DataStage Engineer to design, develop, and support scalable ETL pipelines across Oracle, DB2, Snowflake, and cloud sources. You will work with business and technology teams to ensure high-performance, reliable data integration aligned with enterprise standards.

The ideal candidate has 10+ years of experience, strong PL/SQL, Snowflake knowledge (Streams/Tasks, stages, data sharing), and automation via Unix shell scripting.

Qualifications

• Hands-on DataStage 11.7+ with parallel jobs and sequencing.
• Advanced SQL/PLSQL work in Oracle/DB2 environments.
• Experience integrating Oracle, DB2, SQL Server, Snowflake, and cloud storage.
• Design, develop and support scalable ETL/ELT pipelines.
• Develop reusable ETL frameworks and parameterized jobs.
• Strong Unix/Linux shell scripting for automation.
• 10+ years of engineering experience.

Responsibilities

• Design, develop, and support scalable DataStage ETL solutions.
• Collaborate with business and technology teams on data pipelines.
• Optimize data movement and enterprise analytics readiness.
• Support data warehouse, lakehouse, and data lake platforms.
• Implement data extraction, transformation, validation, and loading processes.

Skills

DataStage 11.7+

Performance tuning

SQL/PLSQL

ETL/ELT design

ETL frameworks

Requirements analysis

DataStage ETL

Multi-source data integration

Snowflake platform

Snowflake migration

Unix shell scripting

Batch/CDC pipelines

DW/Data Lake/Lakehouse

Production support

DevOps (Git/CI-CD)

10+ years experience

Education

Bachelor’s degree in computer engineering or computer science

Tools

Git

CI/CD

Unix/Linux

Job description

Kavaliro is seeking a senior DataStage Engineer to design, develop, and support scalable ETL pipelines across Oracle, DB2, Snowflake, and cloud sources. You will work with business and technology teams to ensure high-performance, reliable data integration aligned with enterprise standards.

The ideal candidate has 10+ years of experience, strong PL/SQL, Snowflake knowledge (Streams/Tasks, stages, data sharing), and automation via Unix shell scripting.