Data Warehouse Engineer - Oracle SQL & Redshift (Dubai)

Zoho; Dubai; On-site; AED 107,000 - 179,000; Full time

Job summary

Zoho in Dubai seeks a Senior Software Engineer to own Oracle SQL & PL/SQL, AWS Redshift and Python/PySpark data warehouse development. This onsite role requires 7+ years of experience, relocation to Dubai, and a readiness to work 5 days from the office.

You will design and optimize ETL/ELT processes, implement data modeling strategies (dimensional modeling) and tune queries, indexes, and Redshift Spectrum usage. Candidates with AWS/Oracle certifications and mentoring skills are a plus.

Qualifications

• 7+ years of experience with Oracle SQL/PL/SQL in data warehousing.
• Experience with Amazon Redshift and AWS data services.
• Strong Python/PySpark skills for ETL/ELT pipelines.
• Expertise in dimensional modeling and performance tuning.

Skills

Oracle SQL & PL/SQL

Python / PySpark

Data Warehousing & ETL/ELT

Dimensional Modeling

Query Optimization

Indexing & Partitioning

Stored Procedures / Packages / Views

Redshift Spectrum

Tools

Amazon Redshift

AWS S3

AWS Glue

AWS EMR

Job description

Zoho in Dubai seeks a Senior Software Engineer to own Oracle SQL & PL/SQL, AWS Redshift and Python/PySpark data warehouse development. This onsite role requires 7+ years of experience, relocation to Dubai, and a readiness to work 5 days from the office.

You will design and optimize ETL/ELT processes, implement data modeling strategies (dimensional modeling) and tune queries, indexes, and Redshift Spectrum usage. Candidates with AWS/Oracle certifications and mentoring skills are a plus.