Senior Data Engineer - IBM DataStage & Snowflake (Remote)

Ampcus Incorporated

Cincinnati (OH)

Hybrid

USD 110,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Ampcus Inc. is seeking an experienced ETL/Data Scientist to design, develop, and support scalable DataStage-based data pipelines for mission-critical applications.

The role requires strong SQL/PLSQL skills and deep Snowflake experience, including Streams and Tasks, alongside robust Unix shell scripting for automation. Hybrid work in Cincinnati, OH is preferred, with openness to remote candidates in the Eastern Time zone.

Qualifications

  • 5+ years of experience delivering ETL/ELT solutions with DataStage.
  • Strong SQL/PLSQL experience in Oracle/DB2 environments.
  • Experience designing scalable data pipelines and data integration solutions.
  • Proficiency with DataStage, parameterized jobs, and metadata-driven workflows.
  • Experience with Snowflake features like Streams, Tasks, external stages, and data sharing.
  • Unix/Linux shell scripting experience for automation and batch processing.
  • Knowledge of Data Warehousing, Dimensional Modeling, and Lakehouse architectures.
  • 8-10 years of engineering experience.

Responsibilities

  • Design, develop, and support scalable IBM DataStage ETL solutions and pipelines.
  • Collaborate with business and tech teams to deliver high-quality data integration.
  • Build reusable ETL frameworks and automated data processing workflows.
  • Implement data extraction, transformation, validation, cleansing, and loading processes.
  • Migrate and optimize data movement between on-prem and Snowflake cloud environments.

Skills

ETL/ELT design
SQL/PLSQL development
Unix/Linux scripting
Data integration
Performance tuning

Education

Bachelor's degree in Computer Science or related field

Tools

IBM DataStage
Snowflake
Git / CI/CD

Job description

Ampcus Inc. is seeking an experienced ETL/Data Scientist to design, develop, and support scalable DataStage-based data pipelines for mission-critical applications.

The role requires strong SQL/PLSQL skills and deep Snowflake experience, including Streams and Tasks, alongside robust Unix shell scripting for automation. Hybrid work in Cincinnati, OH is preferred, with openness to remote candidates in the Eastern Time zone.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - IBM DataStage & Snowflake (Remote)
Senior Data Engineer - IBM DataStage & Snowflake (Remote)

Ampcus Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 140,000
Senior Data Engineer - IBM DataStage + Snowflake ETL
Senior Data Engineer - IBM DataStage + Snowflake ETL

Ampcus, Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Ampcus, Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Ampcus Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 140,000
Data Engineer - DataStage ETL I | Grow with BI & Data
Data Engineer - DataStage ETL I | Grow with BI & Data

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 80,000 - 110,000
Competitive base salary
Medical, dental, and vision insurance
Optional life and disability insurance
+5
Senior Data Engineer — Build Scalable Snowflake Pipelines
Senior Data Engineer — Build Scalable Snowflake Pipelines

TechDigital Group • Detroit (MI)

On-site
USD 120,000 - 180,000
Senior DataStage & Cloud Data Engineer (Onsite Omaha)
Senior DataStage & Cloud Data Engineer (Onsite Omaha)

CSS Staffing • Omaha (NE)

On-site
USD 96,000 - 152,000
Data Integration Lead
Data Integration Lead

Valce Talent Solutions • United States

Remote
USD 110,000 - 165,000
Senior DataStage Engineer - ETL & Data Warehouse
Senior DataStage Engineer - ETL & Data Warehouse

Capgemini • Cincinnati (OH)

On-site
USD 58,000 - 91,000
Data Engineer
Data Engineer

Kaleidoscope Innovation, Inc. • Detroit (MI)

On-site
USD 120,000 - 180,000