Description

Lead Ab Initio ETL development, data architecture, and performance tuning for logistics and supply chain systems.

This role is on-site.

Responsibilities

• Design and build complex Ab Initio graphs, plans, and components with a focus on parallelism and optimization.
• Tune data architecture and debug performance bottlenecks in large-scale ETL pipelines.
• Develop and maintain SQL database queries for data analysis and integrity verification.
• Implement CI/CD pipelines using Jenkins for release deployment and promotions.
• Apply advanced data modeling concepts including SCD, join types, and null keys.

Required Skills

• 10+ years of experience in Ab Initio ETL Development (Components, Parallelism, Graphs, Plans).
• 10+ years of experience with SQL Database Queries and Data Analysis.
• 10+ years of experience in Data Architecture and Performance Tuning (Debugging & Graph Optimization).
• Proficiency in UNIX/Linux Operating Systems and Shell Scripting.
• Experience with CI/CD Pipelines and Release Deployment (e.g., Jenkins-based promotions).
• Bachelor's degree in a related field.

Preferred Skills

• Knowledge of advanced data modeling concepts (SCD, null keys, rollups).
• Experience in the Logistics or Supply Chain industry.

Key Skills

Education

Bachelor's degree