Description

TOP HARD SKILLS
 

• Ab Initio ETL tool expertise (Join, Dedup, Sort, Reformat, Rollup, Merge, Gather, Filter by Expression) – 10+ years of experience
• Core SQL query design, debugging, and data issue analysis – 10+ years of experience
• Comprehensive understanding of Ab Initio parallelism concepts, graphs, and plans – 10+ years of experience

NICE-TO-HAVES
 

• UNIX/Linux operating systems commands and shell scripting
• Automated deployment exposure (Jenkins-based promotion processes)
• Prior experience working within the Logistics industry

The Ab Initio Onsite Lead will join the client Prometheus (SCO-GOS-Sort and Dock) allocation team to oversee critical data integration architecture.
This team focuses on designing, developing, and optimizing high-performance ETL pipelines that power core logistics and supply chain sortation operations.
The mission is to ensure robust data flow and operational efficiency across critical enterprise infrastructure.

DAY-TO-DAY RESPONSIBILITIES

• Develop and enhance Ab Initio ETL graphs and data flows based on project requirements.
• Handle production issues, analyze code and data defects, and provide critical fixes and improvements.
• Perform performance tuning, optimization, and root cause analysis for live/production issues.
• Work on application defects, bundle changes, and data/coding-related system modifications.
• Independently lead technical research, own enhancement stories, and drive them to successful closure.
• Participate directly in client and onsite interactions, leading daily and weekly status discussions.
• Ab Initio ETL Development (Components, Parallelism, Graphs, Plans) – 10+ years
• SQL Database Queries & Data Analysis (Basic to Intermediate) – 10+ years
• Data Architecture & Performance Tuning (Debugging & Graph Optimization) – 10+ years
• UNIX/Linux Operating Systems and Shell Scripting
• Advanced Data Modeling concepts (Join types, SCD concepts, null keys, rollups)
• CI/CD Pipelines and Release Deployment (e.g., Jenkins-based promotions)
• Logistics / Supply Chain industry experience

TOP 3 REQUIRED SKILLS

ADDITIONAL DESIRED SKILLS

IDEAL CANDIDATE PROFILE

The ideal candidate is a seasoned, autonomous technical leader with more than a decade of deep Ab Initio expertise. They should possess strong consultative communication skills, as this role demands high-touch onsite client interaction and collaborative daily problem-solving. This individual must thrive in dynamic, live production environments, showing an exceptional ability to optimize complex codebases and take complete ownership of technical outcomes.

Job Responsibilities

• Design, build, and optimize complex Ab Initio ETL graphs and data flows aligned to enterprise performance standards.
• Provide comprehensive root cause analysis, performance tuning, and technical remediation for live production data streams.
• Partner with onsite stakeholders and clients to lead daily technical alignment discussions and track project deliverables.
• Independently research, engineer, and drive lifecycle development for systems enhancements and application defects

Key Skills

Education

Bachelor's degree