Senior Ab Initio Data Engineer & ETL Architect

Veriipro; Berkeley Heights (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

Veriipro is seeking an experienced ETL Architect to design and maintain complex Ab Initio workflows. You will develop end-to-end data integration across RDBMS, mainframe, flat files, and streaming platforms, and optimize performance through partitioning and parallelism.

In this role you will implement CDC, manage metadata in EME, and mentor junior developers, collaborating with DBAs and business teams to translate requirements into scalable data solutions.

Qualifications

• Bachelor's degree required in CS/Engineering or related field.
• 7+ years of ETL development experience including 5+ years with Ab Initio.
• Strong experience with Ab Initio GDE, Co>Op, EME, Conduct>It, Data Profiler and Continuous Flows.
• Strong SQL skills and advanced Unix/Linux shell scripting.
• Solid understanding of data warehousing concepts: dimensional modeling, SCD, star and snowflake schemas.
• Experience designing and implementing Kafka-based data pipelines.
• Strong debugging, troubleshooting and performance tuning skills for large-volume data processing.

Responsibilities

• Design, develop, and maintain complex ETL workflows and graphs using Ab Initio GDE.
• Architect end-to-end data integration solutions across multiple source and target systems including RDBMS, mainframe, flat files, message queues, and streaming platforms.
• Optimize Ab Initio graph performance through parallelism, partitioning techniques, layout optimization, and checkpointing strategies.
• Develop and manage solutions using Ab Initio components including Co>Op, EME, Conduct>It, Data Profiler, and Continuous Flows.
• Implement CDC and near-real-time data processing pipelines.
• Manage metadata, lineage, and data governance activities within EME.
• Troubleshoot production issues, perform root-cause analysis, and implement permanent fixes.
• Define development standards, review ETL code, and enforce Ab Initio best practices.
• Mentor junior and mid-level Ab Initio developers.
• Collaborate with data architects, DBAs, and business teams to translate requirements into technical solutions.

Skills

ETL development

SQL

Unix/Linux shell scripting

Data warehousing concepts

Debugging and performance tuning

Parallel processing concepts

Kafka data pipelines

Dimensional modeling

Education

Bachelor’s degree in Computer Science, Engineering, or related technical field

Tools

Ab Initio GDE

Co>Operating System

EME

Conduct>It

Data Profiler

Continuous Flows

Kafka

Job description

Veriipro is seeking an experienced ETL Architect to design and maintain complex Ab Initio workflows. You will develop end-to-end data integration across RDBMS, mainframe, flat files, and streaming platforms, and optimize performance through partitioning and parallelism.

In this role you will implement CDC, manage metadata in EME, and mentor junior developers, collaborating with DBAs and business teams to translate requirements into scalable data solutions.