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
Responsibilities
- 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
- Work extensively with Teradata Enterprise Data Warehouse environments
- Design and manage EDW layered architecture (Staging, ODS, EDW, Data Marts)
- Perform Teradata performance optimization: explain plan analysis, partitioning strategies, join/index optimization, query tuning and workload management
- Write strong Teradata SQL for complex transformations and large datasets
- Design and optimize dimensional models (star/snowflake schemas)
- 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
- Support enterprise BI tools: SAP BusinessObjects, Qlik Sense, Looker
Requirements
- 7 12 years of experience in ETL design and development
- Strong experience with Informatica PowerCenter
- Strong experience with Teradata EDW environments
- Experience with Google Cloud Platform (BigQuery, Dataflow, Cloud Storage, Pub/Sub)
- 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
- Strong expertise in Unix shell scripting for automation, scheduling, and monitoring
- Advanced Teradata performance tuning for large scale workloads
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.
Key Responsibilities
- 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.
- 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).
- 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.
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
Commercial Marketing & Visual Communications Specialist/Officer
Abu Dhabi, UAE
Job Title Commercial Marketing & Visual Communications Specialist/Officer Role Purpose To support the Commercial Team by developing high-quality marketing and business developme...
Human Resources Executive
Dubai, UAE
A confidential company seeks an organized HR Executive to manage daily HR operations including recruitment, onboarding, record management, employee relations, and payroll support. The ideal candidate has strong communica
Designer / Architect
Dubai, UAE
Seeking a creative Designer or Architect to develop design concepts, manage client interactions, and produce high-quality outputs using various design software.
Techno-Functional Consultant – Enterprise AI / Generative AI Architect
Abu Dhabi, UAE
AI Strategy & Executive Advisory Serve as the trusted AI advisor to C-Level executives and senior business leaders. Translate complex business challenges into practical AI trans...
HR Manager/Test
Dubai, UAE
Develop and implement HR strategies aligned with the company's goals to drive employee engagement and performance. Oversee recruitment processes, ensuring the attraction and ret...
Sales Executive
Dubai, UAE
The role and responsibilities for this position includes managing showroom sales, customer service, stock management, display, cashier and store upkeep. About Us: We are distrib...
Head of Manufacturing Cost Accounting
Dubai, UAE
Lead manufacturing cost accounting, ensuring accurate product costing, budgeting, variance analysis, and compliance while mentoring a high-performing team.
Electrical Eplan Design Engineers
Abu Dhabi, UAE
Design LV switchgear and control panels using EPLAN Electric P8. Prepare electrical schematics, single-line diagrams (SLD), multi-line diagrams, wiring diagrams, and control cir...
Commercial Marketing & Visual Communications Specialist/Officer
Abu Dhabi, UAE
Human Resources Executive
Dubai, UAE
Designer / Architect
Dubai, UAE
Techno-Functional Consultant – Enterprise AI / Generative AI Architect
Abu Dhabi, UAE
HR Manager/Test
Dubai, UAE
Sales Executive
Dubai, UAE
Head of Manufacturing Cost Accounting
Dubai, UAE
Electrical Eplan Design Engineers
Abu Dhabi, UAE