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, Conduct>
It, and Co>
Operating System
Data Integration & Loading
Integrate data from Oracle, flat files, XML, JSON into Teradata using Ab InitioImplement 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 (Plus)Documentation & Collaboration
Translate LLD and mapping documents into Ab Initio graphsCreate technical documentation : design docs, graph specifications, deployment guidesCollaborate with data modelers, architects, QA teams, and Teradata DBAsDevelop Ab Initio scripts (.pset, .ksh, .plan files) and Unix shell scripts for automationProduction Support
Troubleshoot Ab Initio job failures, analyze logs, and implement performance tuningManage version control (Git / SVN) and coordinate deploymentsMonitor jobs through Control Center and provide production supportRequired Skills
Ab Initio (Primary - Required)
5+ years hands-on experience with Ab Initio GDE, Co>Operating System, Conduct>
It, Express>
It
Advanced expertise in Ab Initio components, graph development, and performance tuningAb Initio DML, parameter management, EME, and deployment proceduresUnix / Linux shell scripting for Ab Initio automationTeradata & Database (Required)
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 extractionBig Data (Plus)
Cloudera Data Platform (CDP) experience; Hadoop ecosystem (Hive, HDFS, Sqoop)Telecommunications Domain (Required)
Strong understanding of telecom processes, data flows, and industry standardsOSS : Network inventory, provisioning, fault / performance managementBSS : Billing, customer management, order management, revenue assuranceTelecom KPIs : ARPU, churn rate, network utilizationProfessional Skills
Full SDLC (Agile / Scrum, Waterfall); strong analytical and debugging skillsGood communication for technical and business collaborationPreferred Qualifications
Bachelor's degree in Computer Science or related fieldAb Initio certificationExperience with Ab Initio Express>It for data quality
Key Deliverables
Functional Ab Initio ETL graphs with parameter files and scriptsTechnical documentation : design docs, graph specs, deployment guidesUnit tested and optimized code ready for productionData reconciliation reports and performance tuning recommendations