PL/SQL Developer

RiDiK (a Subsidiary of CLPS. Nasdaq: CLPS); Dubai; On-site; AED 240,000 - 320,000; Full time

Job summary

RiDiK, a subsidiary of CLPS, Dubai, seeks an experienced BI Engineer specializing in PL/SQL and Amazon Redshift to enhance commercial BI data flows and data integration. The candidate will design scalable ETL components, optimize complex SQL queries, and collaborate across teams to support data-driven decision making.

The role requires 6+ years of experience, strong Oracle/Redshift proficiency, and familiarity with Hadoop/Spark/Hive on AWS. Airlines domain experience is preferred.

Qualifications

• Advanced SQL and PL/SQL knowledge.
• Experience with complex SQL queries, stored procedures, and bulk data processing.
• Data modeling, schema design, and query optimization expertise.
• Hands-on with Oracle and Amazon Redshift databases.

Responsibilities

• Develop and implement data integration requirements for scalable pipelines.
• Design modular and reusable ETL components for large-scale data processing.
• Perform and optimize data flows and SQL queries for performance.
• Collaborate with cross-functional teams and communicate effectively.

Skills

Advanced SQL

PL/SQL

SQL tuning

Data modeling

Redshift

Oracle

ETL design

Data integration

Spark

Hadoop

Hive

AWS Cloud

Airlines domain experience

Cross-functional collaboration

Tools

Oracle

Amazon Redshift

Hadoop

Hive

Spark

AWS

Job description

Role: PL SQL Redshift Commercial BI Enhancement

Location: Dubai

Year of experience- 6+ Years

Required Skills and Experience:

Advanced SQL and PL/SQL Knowledge

Strong skills in writing, optimizing, and debugging complex SQL queries and stored procedures.

Experience in bulk data processing using advanced SQL and PL/SQL techniques.

Proficiency in data modeling, schema design, and query optimization.

Hands on knowledge on Oracle, Amazon Redshift databases

Develop, and Implement Data Integration Requirements

Expertise in gathering and analyzing data integration requirements to create scalable solutions.

Ability to design modular and reusable ETL components for large-scale data pipelines.

Problem-Solving and Debugging Skills

Strong aptitude for identifying and resolving ETL and data-related issues efficiently.

Proven experience in performance tuning of Data flows and SQL queries.

Other Skills

Strong communication and collaboration skills for working with cross-functional teams.

Prefer to have experience working with Hadoop, Hive, Spark frameworks, AWS cloud

Airlines domain experience preferred