Senior ETL Designer & Developer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
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.
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)
- Optimize Teradata performance using Explain plan analysis, partitioning strategies, join/index optimization, query tuning, and workload management
- 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
- Support ad hoc reporting requirements from business users using EDW and BI layers
Requirements
- 7+ years of experience in ETL development and data warehousing
- Strong hands on experience with Informatica PowerCenter
- Deep expertise in Teradata EDW, including CLDM and optimization techniques
- Strong Teradata SQL coding and performance tuning skills
- Experience with EDW architecture (Staging, ODS, EDW, Data Marts)
- Advanced SQL and data modeling (Kimball/Inmon)
- Experience with Google Cloud Platform data services
- Unix shell scripting for automation
- Telecom domain experience (preferred/required based on role level)
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 processin
Key Responsibilities
- 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); Extensive expertise in Teradata performance optimization tec
- 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 Experience: 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)
- Scripting & Performance Optimization: Strong expertise in Unix shell scripting for automation, scheduling, and monitoring; Advanced Teradata performance tuning and optimization for large scale workloads; Optimize ETL jobs, SQL queries, and EDW processes for scalability and efficiency; Troubleshoot p
Required Skills
- 7+ years of experience in ETL development and data warehousing
- Strong hands on experience with Informatica PowerCenter
- Deep expertise in Teradata EDW, including CLDM and optimization techniques
- Strong Teradata SQL coding and performance tuning skills
- Experience with EDW architecture (Staging, ODS, EDW, Data Marts)
- Advanced SQL and data modeling (Kimball/Inmon)
- Experience with Google Cloud Platform data services
- Unix shell scripting for automation
- Telecom domain experience (preferred/required based on role level)
Preferred Skills
- Cloud migration experience (on prem EDW to GCP)
- Python or additional scripting/automation skills
- CI/CD pipelines for data engineering workflows
- Experience with BI semantic layers and enterprise reporting frameworks
- Experience supporting ad hoc business reporting in enterprise environments
Soft Skills
- Strong communication and stakeholder management skills
- Analytical thinking and strong problem solving ability
- Ability to work in agile, fast paced environments
- Strong ownership mindset with focus on data quality and delivery
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
Business Set-up Consultant (French Speaker)
Dubai, UAE
Role Description The Business Set-up Consultant (French Speaker) is a full-time, on-site role based in Dubai. This role involves guiding clients through the complete business formation process, including advising on lega
Global Human Resources Director
Dubai, UAE
A confidential company seeks a Global Human Resources Director to lead global HR functions from Dubai. The role involves strategic HR leadership, talent acquisition, performance management, compensation, compliance, and
Senior Specialist - Risk & Business continuity ( UAE national )
Dubai, UAE
The employer is seeking a Senior Specialist to support enterprise resilience initiatives, including business continuity management, crisis preparedness, risk assessments, and recovery planning. The role requires collabor
Chemist
Dubai, UAE
We are seeking a Chemist for a full-time, on-site role in Dubai to perform chemical analysis and laboratory testing of soil and water samples. Requires a Bachelor's degree in Chemistry or related field and 2-5 years of e
Housekeeper
Doha, QAT
A prestigious VIP household in Qatar is seeking a professional Housekeeping Attendant for a live-in position. The role involves maintaining exceptional cleanliness and presentation standards, handling luxury furnishings,
Head of Corporate Governance & Board Secretariat
Dubai, UAE
A large diversified organization seeks an accomplished executive to lead Corporate Governance and Board Secretariat functions. The role oversees governance frameworks, legal compliance, enterprise risk, ESG, and Board su
Financial Analyst – Growth & Investments
Dubai, UAE
A confidential company seeks a Financial Analyst to support expansion strategy through financial modeling, feasibility studies, and investment analysis. You will build models, evaluate deals, and provide commercial insig
Senior Azure AI Engineer
Dubai, UAE
A confidential company is seeking a Senior Azure AI Engineer to design, develop, and deploy enterprise AI solutions on Microsoft Azure. The role requires deep expertise in the Azure AI ecosystem, including Azure AI Found
Business Set-up Consultant (French Speaker)
Dubai, UAE
Global Human Resources Director
Dubai, UAE
Senior Specialist - Risk & Business continuity ( UAE national )
Dubai, UAE
Chemist
Dubai, UAE
Housekeeper
Doha, QAT
Head of Corporate Governance & Board Secretariat
Dubai, UAE
Financial Analyst – Growth & Investments
Dubai, UAE
Senior Azure AI Engineer
Dubai, UAE