PLSQL Developer

Raqmiyat; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A prominent data solutions firm in Dubai is looking for an experienced PL/SQL Developer. Responsibilities include developing PL/SQL packages, building ETL processes using Oracle Data Integrator, and creating OBIEE dashboards. The ideal candidate has over 5 years of PL/SQL experience, particularly in data modeling and BI tool configuration, and excels in problem-solving and teamwork. The role requires availability to work six days a week, from Sunday to Friday.

Qualifications

• 5+ years of hands-on experience in PL/SQL development.
• Proficient in writing efficient, scalable SQL queries and PL/SQL procedures/functions.
• Experience with Oracle Data Integrator (ODI) for ETL development.
• Solid understanding of data modeling concepts both logical and physical.
• Experience in OBIEE development and administration.
• Skilled in ETL and BI tools installation, configuration, and tuning.
• Strong debugging and problem-solving skills in production environments.
• Excellent communication and team collaboration abilities.

Responsibilities

• Develop complex and optimized PL/SQL packages, procedures, triggers, and functions.
• Analyze, design, and implement relational data models to support application and reporting requirements.
• Build and maintain ETL processes using Oracle Data Integrator (ODI).
• Design and develop OBIEE dashboards and reports based on business requirements.
• Perform installation, configuration, and administration of ETL and BI tools.
• Troubleshoot and resolve PL/SQL code issues and database performance bottlenecks.
• Support ongoing maintenance and enhancement of existing data solutions.

Skills

PL/SQL development

SQL queries

Oracle Data Integrator (ODI)

Data modeling

OBIEE development

ETL tools

Problem-solving

Team collaboration

Job description

Key Responsibilities:

• Develop complex and optimized PL/SQL packages procedures triggers and functions to support business logic and data transformation needs.
  

• Analyze design and implement relational data models to support application and reporting requirements.
  

• Build and maintain ETL processes using Oracle Data Integrator (ODI).
  

• Design and develop OBIEE dashboards and reports based on business requirements.
  

• Perform installation configuration and administration of ETL and BI tools.
  

• Troubleshoot and resolve PL/SQL code issues database performance bottlenecks and integration errors.
  

• Support ongoing maintenance and enhancement of existing data solutions
  

Requirements

5 years of hands-on experience in PL/SQL development.

Proficient in writing efficient scalable SQL queries and PL/SQL procedures/functions.

Experience with Oracle Data Integrator (ODI) for ETL development.

Solid understanding of data modeling concepts both logical and physical.

Experience in OBIEE development and administration.

Skilled in ETL and BI tools installation configuration and tuning.

Strong debugging and problem-solving skills in production environments.

Excellent communication and team collaboration abilities

Should be available to work for 6 days a week(Sunday-Friday)

5+ years of hands-on experience in PL/SQL development. Proficient in writing efficient, scalable SQL queries and PL/SQL procedures/functions. Experience with Oracle Data Integrator (ODI) for ETL development. Solid understanding of data modeling concepts both logical and physical. Experience in OBIEE development and administration. Skilled in ETL and BI tools installation, configuration, and tuning. Strong debugging and problem-solving skills in production environments. Excellent communication and team collaboration abilities Should be available to work for 6 days a week(Sunday-Friday)