Senior Data Engineer

Ampcus Inc. • Cincinnati, OH

10h • Hybrid

About The Position

Ampcus Inc. is seeking a highly motivated Senior Data Engineer to design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications. This role involves collaborating 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 with multiple source and target systems including Oracle, DB2, Snowflake, flat files, cloud storage, and various data formats (structured, semi-structured, and unstructured). The position requires deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, and PL/SQL, focusing on building scalable data pipelines, optimizing data movement, supporting data warehouse, data lake, and Lakehouse platforms, and enabling enterprise analytics and reporting solutions.

Requirements

• 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.
• Strong experience with Snowflake including Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing, and Query Performance Optimization.
• Strong Unix/Linux Shell Scripting skills.
• 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 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.
• 8-10 years engineering experience.
• A Bachelor’s degree in computer engineering, computer science or other related discipline is required.

Nice To Haves

• CI/CD experience.
• Performance optimization in Snowflake.
• Previous payments experience.
• Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices.

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.
• Build scalable data pipelines, optimize data movement processes, and support data warehouse, data lake, and Lakehouse platforms.
• Enable enterprise analytics and reporting solutions.
• 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.
• Integrate data from various sources including Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
• Design and develop cloud-native data pipelines and migrate data from on-premises systems to Snowflake.
• Develop Unix/Linux Shell Scripts for process automation, file handling, batch scheduling, operational support, and production troubleshooting.
• Create high-performance batch, incremental, and CDC-based data pipelines for large-volume data processing.
• Perform performance tuning, root cause analysis, production support, and incident management.
• Work independently and communicate/collaborate with stakeholders to understand business needs after training.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior