Senior ETL Designer & Developer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Design and develop ETL workflows, optimize Teradata environments, and support cloud data solutions while leveraging strong telecom domain expertise and scripting skills.
Key Skills for This Role
Full Job Posting
Overview
We are seeking a Senior ETL Designer & Developer to design, build, and support enterprise-scale data integration and analytics solutions across Informatica PowerCenter, Teradata EDW, and Google Cloud Platform (GCP).
The role involves developing scalable ETL pipelines, enabling telecom data processing, supporting enterprise reporting (including ad-hoc analytics), and optimizing large-scale EDW environments.
ETL & Data Engineering
- Design, develop, and maintain ETL/ELT workflows using Informatica PowerCenter
- - Build scalable batch and near real-time data pipelines
- - Develop reusable mappings, workflows, and transformation logic
- - Automate ETL processes using Unix shell scripting
Data Warehouse (Teradata)
- Work extensively with Teradata Enterprise Data Warehouse environments
- - Strong experience with Teradata CLDM (Common Logical Data Model)
- - Design and manage EDW layered architecture (Staging, ODS, EDW, Data Marts)
- - Teradata performance optimization: explain plan analysis, partitioning strategies, join/index optimization (PI, NUSI, etc.), query tuning and workload management
- - Strong Teradata SQL coding for complex transformations and large datasets
- - Design and optimize dimensional models (star/snowflake schemas)
Cloud Data Engineering
- Develop solutions on Google Cloud Platform (BigQuery, Dataflow, Cloud Storage, Pub/Sub)
- - Implement and support hybrid data architectures integrating on-prem EDW with cloud systems
BI, Reporting & Data Virtualization
- Support enterprise BI tools: SAP BusinessObjects, Qlik Sense, Looker
- - Support ad-hoc reporting requirements from business users using EDW and BI layers
- - Work with Denodo Platform for federated data access, performance optimization, and logical data modeling
Telecom Domain
- Strong experience in telecom OSS/BSS data environments
- - Hands-on knowledge of CDR/IPDR data processing; billing, CRM, and subscriber lifecycle data; network performance, fault, and mediation systems
- - Understanding of telecom KPIs (ARPU, churn, usage patterns, QoS metrics)
- - Experience handling high-volume, complex telecom datasets
Scripting & Performance Optimization
- Strong expertise in Unix shell scripting for automation, scheduling, and monitoring
- - Advanced Teradata performance tuning for large-scale workloads
- - Optimize ETL jobs, SQL queries, and EDW processes for scalability and efficiency
- - Troubleshoot pipeline failures and ensure system reliability
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Confidential Company
Client Relationship Officer
Dubai, UAE
Respond to client inquiries, maintain records, build relationships, and ensure client satisfaction using CRM tools and strong communication skills.
Testing & Commissioning Manager
Abu Dhabi, UAE
Lead testing and commissioning for HV/EHV substations, develop strategies, supervise engineers, ensure compliance with standards, and manage project execution.
Purchaser
Ras Al Khaimah, UAE
Responsible for sourcing and purchasing raw materials, negotiating with suppliers, managing inventory, and ensuring compliance with procurement standards.
Manager After-Sales/Spare Parts/ Maintenance Division
Abu Dhabi, UAE
Lead after-sales service and maintenance operations for mechanical equipment, requiring expertise in spare parts, customer relationship management, and Oil & Gas industry experi...
Job Opportunity - Associate Contract Administration
Abu Dhabi, UAE
Responsible for contract administration, including drafting documents, supporting negotiations, and ensuring compliance with policies and regulations.
Procurement Coordinator
Dubai, UAE
Manage purchasing activities, evaluate suppliers, prepare orders, and ensure compliance with procurement processes while supporting supply chain management and reporting.
Job Opportunity - Technician - Automation & Control
Al Ain, UAE
Responsible for installation, testing, and maintenance of automation systems, requiring expertise in electrical engineering and preventive maintenance.
Personal Assistant (Female Only)
Dubai, UAE
Manage calendars, assist in daily activities, prepare reports, conduct research, and travel with the Managing Director; requires strong communication and organizational skills.
Client Relationship Officer
Dubai, UAE
Testing & Commissioning Manager
Abu Dhabi, UAE
Purchaser
Ras Al Khaimah, UAE
Manager After-Sales/Spare Parts/ Maintenance Division
Abu Dhabi, UAE
Job Opportunity - Associate Contract Administration
Abu Dhabi, UAE
Procurement Coordinator
Dubai, UAE
Job Opportunity - Technician - Automation & Control
Al Ain, UAE
Personal Assistant (Female Only)
Dubai, UAE