Senior Data Engineer

Ampcus, Inc; Cincinnati (OH); Hybrid; USD 110,000 - 150,000; Full time

Job summary

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,

Qualifications

• 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.

Responsibilities

• 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.

Skills

DataStage

SQL/PLSQL

Unix Shell Scripting

ETL/ELT design

Data Warehousing

Snowflake

Data pipelines

DevOps / CI-CD

Git

Agile methodologies

Education

Bachelor's degree in CS/CE or related

Tools

IBM DataStage

Snowflake

Oracle

DB2

SQL Server

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

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, and 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.
• 8-10 years engineering experience.

Education Requirements

A Bachelor's degree in computer engineering, computer science or other related discipline is required.

Additional Information

After training, the candidate will be working independently and communicate/collaborate with stakeholders to understand business needs. The position is hybrid in Cincinnati, OH preferred, but open to remote candidates who will work eastern time.

Must Haves

• #1 requirement - IBM DataStage experience.
• #2 requirement - Snowflake skills.
• #3 requirement - Scripting experience (Unix).
• #4 requirement - Advanced SQL skills.

Nice to Haves

• CI/CD experience.
• Performance optimization in Snowflake.
• Previous payments experience.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.