EDW Developer

Master-Works; Riyadh; On-site; SAR 120,000 - 150,000; Full time

Job summary

A leading technology solutions provider in Saudi Arabia is seeking an experienced ETL Developer with specialized expertise in Ab Initio. The successful candidate will design complex ETL solutions for Teradata EDW, requiring a minimum of 5 years of experience in ETL development and a strong understanding of telecommunications processes. This role offers an opportunity to work with advanced data integration technologies and to contribute to high-performance ETL solutions.

Qualifications

• Minimum 5+ years in ETL development with Ab Initio.
• Strong telecommunications domain knowledge.
• Experience with data integration solutions for Teradata EDW.

Responsibilities

• Design and develop ETL workflows using Ab Initio GDE.
• Build scalable data pipelines and develop reusable components.
• Monitor jobs and provide production support.

Skills

Ab Initio GDE

Teradata SQL

Unix/Linux Shell Scripting

Telecommunications Domain Knowledge

Education

Bachelor's degree in Computer Science or related field

Tools

Ab Initio Components

Git/SVN

Cloudera Data Platform (CDP)

Job description

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 Initio
• Implement Ab Initio to Teradata connectivity using BTEQ, FastLoad, MultiLoad, TPump
• Develop incremental/full load strategies, CDC logic, and SCD Types 1, 2, 3 implementations
• Create data quality checks, validation rules, and reconciliation processes
• Work with Cloudera Data Platform (CDP) for big data integration (Plus)

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

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 tuning
• Ab Initio DML, parameter management, EME, and deployment procedures
• Unix/Linux shell scripting for Ab Initio automation

Teradata & 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 extraction

Big Data (Plus)

• Cloudera Data Platform (CDP) experience; Hadoop ecosystem (Hive, HDFS, Sqoop)

Telecommunications Domain (Required)

• 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 (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>It 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