Ab Initio Onsite Lead - Data Integration Architect

Location: Collierville, TN (100% In Office)

Work Setup: This is a 100% onsite role in Collierville, TN. Candidates must be local to the area; no relocation or travel/expenses are covered by the client

.Deliverables: High-performance Ab Initio graphs, prompt root-cause analysis for live production issues, and successful execution of enhancement stories

.Interview Process: Quick feedback loop; technical evaluation focusing heavily on Ab Initio components, parallelism, and debugging capabilities

.
TOP HARD SKIL

LSAb Initio ETL tool expertise (Join, Dedup, Sort, Reformat, Rollup, Merge, Gather, Filter by Expression) – 10 years of experien

ceCore SQL query design, debugging, and data issue analysis – 10 years of experien

ceComprehensive understanding of Ab Initio parallelism concepts, graphs, and plans – 10 years of experien

ce
NICE-TO-HA

VESUNIX/Linux operating systems commands and shell script

ingAutomated deployment exposure (Jenkins-based promotion process

es)Prior experience working within the Logistics indus

try
DISQUALIF

IERSNon-local candidates or individuals seeking remote/hybrid accommodati

ons.Candidates with fewer than 10 years of experience in data integration architect

ure.Lack of hand-on troubleshooting capability in active production environme

nts.
Title: RM - Ab Initio Onsite Lead - Data Integration Arch

itectLocation: Collierville, TN (In Of

fice)Start Date / End Date: 6/29/2026 – 12/31

/2026Schedule: 40 hours per

weekEquipment: Client pro

videdInterview Process: 2 rounds (Technical & Client Inter

view)

POSITION O

VERVIEWThe Ab Initio Onsite Lead will join the FedEx 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 infrastr

ucture.DAY-TO-DAY RESPONSIB

• ILITIESDevelop and enhance Ab Initio ETL graphs and data flows based on project requir
• ements.Handle production issues, analyze code and data defects, and provide critical fixes and improv
• ements.Perform performance tuning, optimization, and root cause analysis for live/production
• issues.Work on application defects, bundle changes, and data/coding-related system modific
• ations.Independently lead technical research, own enhancement stories, and drive them to successful c
• losure.Participate directly in client and onsite interactions, leading daily and weekly status discu

ssions.TOP 3 REQUIRED

• SKILLSAb Initio ETL Development (Components, Parallelism, Graphs, Plans) – 10
• yearsSQL Database Queries & Data Analysis (Basic to Intermediate) – 10
• yearsData Architecture & Performance Tuning (Debugging & Graph Optimization) – 10

yearsADDITIONAL DESIRED

• SKILLSUNIX/Linux Operating Systems and Shell Sc
• riptingAdvanced Data Modeling concepts (Join types, SCD concepts, null keys, r
• ollups)CI/CD Pipelines and Release Deployment (e.g., Jenkins-based prom
• otions)Logistics / Supply Chain industry exp

erienceIDEAL CANDIDATE

PROFILEThe 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 ou

tcomes.Job Responsib

• ilitiesDesign, build, and optimize complex Ab Initio ETL graphs and data flows aligned to enterprise performance sta
• ndards.Provide comprehensive root cause analysis, performance tuning, and technical remediation for live production data s
• treams.Partner with onsite stakeholders and clients to lead daily technical alignment discussions and track project delive
• rables.Independently research, engineer, and drive lifecycle development for systems enhancements and application d