DataStage Data Engineer

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

Design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications.

Collaborate with business and technology teams to deliver high-quality, performant, and reliable data integration solutions aligned with enterprise architecture standards. The ideal candidate will have extensive experience working with multiple source and target systems including Oracle, DB2, Snowflake, flat files, cloud storage, structured, semi-structured, and unstructured data sources.

The candidate should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, PL/SQL. This role involves building scalable data pipelines, optimizing data movement processes, supporting data warehouse, data lake, and Lakehouse platforms, and enabling enterprise analytics and reporting solutions.

Required Skills & Experience

• Strong hands-on experience with IBM DataStage 11.7 or above including Parallel Jobs, Sequencers, Parameter Sets, Job
• Monitoring, Administration, and Performance Tuning.
• Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
• Design, develop, test, deploy, and support complex ETL/ELT solutions using DataStage and enterprise data pipelines.
• Develop reusable ETL frameworks using IBM DataStage, parameterized jobs, metadata-driven solutions, and automated data processing workflows.
• Analyze business and technical requirements and translate them into scalable ETL designs and data integration solutions.
• Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes using DataStage.
• Experience integrating data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
• Strong experience with Snowflake including, Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing and Query Performance Optimization
• Experience designing, developing cloud-native data pipelines, and migrating data from on-premises systems to Snowflake.
• Strong Unix/Linux Shell Scripting skills for process automation, file handling, batch scheduling, operational support, and production troubleshooting.
• Experience creating high-performance batch, incremental, and CDC-based data pipelines for large-volume data processing.
• Strong understanding of ETL/ELT architecture, Data Warehousing, Dimensional Modeling, Data Lakes, and Data Lakehouse architectures.
• Experience with performance tuning, root cause analysis, production support, and incident management.
• Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices.
• 7-10+ years engineering experience

EDUCATION REQUIREMENTS

A Bachelor’s degree in computer engineering, computer science or other related discipline