EDW Developer

Enterprise Data Warehouse ETL Developer (Ab Initio Specialist)Position OverviewWe 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 InitioCore ResponsibilitiesAb Initio DevelopmentDesign and develop complex ETL workflows using Ab Initio GDE for Teradata EDWBuild 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 mechanismsOptimize performance through parallelization, partitioning, and efficient component usageWork with Ab Initio EME, Control Center, Conduct>It, and Co>Operating SystemData Integration & LoadingIntegrate 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 & CollaborationTranslate 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 SupportTroubleshoot 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 SkillsAb Initio (Primary - Required)5+ years hands-on experience with Ab Initio GDE, Co>Operating System, Conduct>It, Express>ItAdvanced 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 SkillsFull SDLC (Agile/Scrum, Waterfall); strong analytical and debugging skillsGood communication for technical and business collaborationPreferred QualificationsBachelor's degree in Computer Science or related fieldAb Initio certificationExperience with Ab Initio Express>It for data qualityKey DeliverablesFunctional 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