EDW Developer

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