Enterprise Data Warehouse ETL Developer (Ab Initio Specialist)
Position Overview :
We are seeking an experienced ETL Developer with specialized expertise in Ab Initio for developing complex data integration solutions for Teradata EDW. The candidate must have strong telecommunications domain knowledge and ability to translate technical specifications into high‑performance ETL solutions.
Experience Required :
Minimum 5+ years in ETL development with Ab Initio.
Core Responsibilities
Ab Initio Development
Design and develop complex ETL workflows using Ab Initio GDE for Teradata EDW
Build scalable data pipelines using Ab Initio components (Reformat, Join, Rollup, Dedup, Partition, Sort, Lookup)
Develop reusable components, sub‑graphs, and implement error handling, checkpoints, and recovery mechanisms
Optimize performance through parallelization, partitioning, and efficient component usage
Work with Ab Initio EME, Control Center, and Co>
Operating System
Data Integration & Loading
Integrate data from Oracle, flat files, XML, JSON into Teradata using Ab Initio
Implement Ab Initio to Teradata connectivity using BTEQ, FastLoad, MultiLoad, TPumpDevelop incremental / full load strategies, CDC logic, and SCD Types 1, 2, 3 implementationsCreate data quality checks, validation rules, and reconciliation processesWork with Cloudera Data Platform (CDP) for big data integration Documentation & Collaboration
Translate LLD and mapping documents into Ab Initio graphs
Create technical documentation : design docs, graph specifications, deployment guides
Collaborate with data modelers, architects, QA teams, and Teradata DBAs
Develop Ab Initio scripts (.pset, .ksh, .plan files) and Unix shell scripts for automation
Production Support
Troubleshoot Ab Initio job failures, analyze logs, and implement performance tuning
Manage version control (Git / SVN) and coordinate deployments
Monitor jobs through Control Center and provide production support
Required Skills
5+ years hands‑on experience with Ab Initio GDE, EME, and deployment procedures
Advanced expertise in Ab Initio components, graph development, and performance tuning
Unix / Linux shell scripting for Ab Initio automation
Teradata & Database
Strong Teradata SQL, utilities (BTEQ, FastLoad, MultiLoad, TPump, TPT)
Understanding of Teradata architecture (AMP, PE, partitioning, indexing : PI, SI, NUSI)
Oracle SQL and PL / SQL for source data extraction
Telecommunications Domain
Strong understanding of telecom processes, data flows, and industry standards
OSS : Network inventory, provisioning, fault / performance management
BSS : Billing, customer management, order management, revenue assurance
Telecom KPIs : ARPU, churn rate, network utilization
Professional Skills
Full SDLC experience (Agile / Scrum, Waterfall); strong analytical and debugging skills
Good communication for technical and business collaboration
Preferred Qualifications
Bachelor's degree in Computer Science or related field
Ab Initio certification
Experience with Ab Initio Express for data quality
Key Deliverables
Functional Ab Initio ETL graphs with parameter files and scripts
Technical documentation : design docs, graph specs, deployment guides
Unit tested and optimized code ready for production
Data reconciliation reports and performance tuning recommendations
#J-18808-Ljbffr
Edw Developer • Riyadh, Saudi Arabia