← Back to jobsJob ID col-cmwp73oy8074ld8ha15xryg57

Ampcus IncPosted 1 day ago

Senior Data EngineerNew

Full-time
Hybrid
8–10 years
Competitive
Posted 1 day ago

Ampcus Inc. is a global provider of technology and business consulting services. The Senior Data Engineer will design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines, integrating diverse data sources and supporting data warehouses, data lakes, and Lakehouse platforms. The role also involves optimizing data movement, enabling analytics and reporting, and collaborating with business and technology stakeholders.

Posted
1 day ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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
  • 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
  • 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
  • Experience with performance tuning, root cause analysis, production support, and incident management
  • Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices
  • After training, the candidate will be working independently and communicate/collaborate with stakeholders to understand business needs

Qualifications

  • 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
  • A Bachelor's degree in computer engineering, computer science or other related discipline is required
  • The position is hybrid in Cincinnati, OH preferred, but open to remote candidates who will work eastern time
  • #1 requirement - IBM DataStage experience
  • #2 requirement - Snowflake skills
  • #3 requirement - Scripting experience (Unix)
  • #4 requirement - Advanced SQL skills

Preferred

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

Required skills

Advanced SQLDB2Data WarehousingDimensional ModelingETL/ELT DevelopmentGit and CI/CDIBM DataStageOraclePL/SQLSnowflakeUnix/Linux Shell Scripting

Full job description

Ampcus Inc. is a global provider of technology and business consulting services. The Senior Data Engineer will design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines, integrating diverse data sources and supporting data warehouses, data lakes, and Lakehouse platforms. The role also involves optimizing data movement, enabling analytics and reporting, and collaborating with business and technology stakeholders.

Responsibilities

  • 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
  • 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
  • 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
  • Experience with performance tuning, root cause analysis, production support, and incident management
  • Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices
  • After training, the candidate will be working independently and communicate/collaborate with stakeholders to understand business needs

Preferred

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

Benefits

  • Hybrid work arrangement in Cincinnati, OH, with remote work available for candidates working Eastern Time

Company

  • Business and technology consulting and staff augmentation firm
  • Chantilly, Virginia, USA
  • http://www.ampcus.com/
  • Founded in 2004
  • 1001-5000 employees

Qualifications

  • 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
  • A Bachelor's degree in computer engineering, computer science or other related discipline is required
  • The position is hybrid in Cincinnati, OH preferred, but open to remote candidates who will work eastern time
  • #1 requirement - IBM DataStage experience
  • #2 requirement - Snowflake skills
  • #3 requirement - Scripting experience (Unix)
  • #4 requirement - Advanced SQL skills
  • CI/CD experience
  • Performance optimization in Snowflake
  • Previous payments experience
  • 8-10 years engineering experience.

Required skills

  • Advanced SQL, DB2, Data Lakes and Data Lakehouse Architectures, Data Warehousing, Dimensional Modeling, ETL/ELT Development, Git and CI/CD, IBM DataStage, Oracle, PL/SQL, Snowflake, Unix/Linux Shell Scripting

Preferred skills

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

Experience

  • 8-10 years

Job details

Employment type

Full-time

Seniority level

8–10 years

Date posted

Nov 20, 2026

Work mode

Hybrid

Job source

www1.jobdiva.com

Company

Ampcus Inc

Information Technology & AI

Business and technology consulting and staff augmentation firm

See all 12 jobs from Ampcus Inc →
  • Chantilly, Virginia, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 2004
  • ampcus.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Cincinnati

just now

1d ago

New

Lead Data Engineer

TemporaryHybridColumbus, OHCompetitive

Dice is advertising a Lead Data Engineer role focused on enterprise data engineering, distributed processing, and cloud-based data platforms.

Why similarSame roleETL/ELT DevelopmentColumbus

Dice

1d ago

New

Lead Data Engineer

TemporaryOn-siteColumbus, OHCompetitive

The hiring client is not identified. The Lead Data Engineer will design and develop scalable data engineering solutions, pipelines, and cloud-based data platforms, and support production data environments.

Why similarSame roleETL/ELT DevelopmentColumbus

EXL

1d ago

New

Senior Data Engineer

Full-timeRemoteUnited StatesCompetitive

EXL is seeking a seasoned Data Engineer to join their Sports Analytics & Engineering Practice. This role is pivotal in shaping and implementing a cloud-native data ecosystem, where you will architect and build scalable data infrastructure that transforms raw…

Why similarSame roleData warehousingRemote

Get new Data Engineer jobs in Cincinnati by email

Create job alert

Senior Data Engineer

Ampcus Inc · Competitive

Apply on company site