EDW Developer at Master-Works

Riyadh, Riyadh Region, Saudi Arabia -

Full Time

Start Date

Immediate

Expiry Date

24 Jan, 26

Salary

0.0

Posted On

26 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Ab Initio, ETL Development, Teradata, Data Integration, Unix/Linux Scripting, Oracle SQL, Big Data, Telecommunications Domain, Data Quality Checks, Performance Tuning, Agile, Debugging, Collaboration, Documentation, Data Pipelines, Incremental Load Strategies

Industry

IT Services and IT Consulting

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

Responsibilities

The core responsibilities include designing and developing complex ETL workflows using Ab Initio for Teradata EDW and integrating data from various sources into Teradata. The role also involves optimizing performance and collaborating with various teams for successful data integration.