Senior Data Engineer - IBM DataStage + Snowflake ETL

Ampcus, Inc; Cincinnati (OH); Hybrid; USD 110.000 - 150.000; Vollzeit

Zusammenfassung

Ampcus Inc is seeking a highly motivated Senior DataStage ETL Engineer to design, develop, and support scalable data pipelines for mission-critical applications. You will collaborate with business and technology teams to deliver high-quality, performant data integration solutions aligned with enterprise standards.

The ideal candidate has extensive IBM DataStage experience (11.7+), strong SQL/PLSQL, Snowflake, and Unix shell scripting, and a proven track record building data warehouses, lakes,

Qualifikationen

• 10+ years of engineering experience (8-10 yrs minimum).
• Strong hands-on IBM DataStage 11.7+ including parallel jobs, sequencers, parameter sets and monitoring.
• Advanced SQL/PLSQL in Oracle and DB2 environments.
• Design, develop, test, deploy and support complex ETL/ELT solutions using DataStage.

Aufgaben

• Design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines.
• Collaborate with business and tech teams to deliver high-quality data integration solutions.
• Build reusable ETL frameworks and automated data processing workflows.
• Optimize data movement, support data warehouse, data lake, and lakehouse platforms.

Kenntnisse

DataStage

SQL/PLSQL

Unix Shell Scripting

ETL/ELT design

Data Warehousing

Snowflake

Data pipelines

DevOps / CI-CD

Git

Agile methodologies

Ausbildung

Bachelor's degree in CS/CE or related

Tools

IBM DataStage

Snowflake

Oracle

DB2

SQL Server

Jobbeschreibung

Ampcus Inc is seeking a highly motivated Senior DataStage ETL Engineer to design, develop, and support scalable data pipelines for mission-critical applications. You will collaborate with business and technology teams to deliver high-quality, performant data integration solutions aligned with enterprise standards.

The ideal candidate has extensive IBM DataStage experience (11.7+), strong SQL/PLSQL, Snowflake, and Unix shell scripting, and a proven track record building data warehouses, lakes,