PLSQL Developer

Raqmiyat; Dubai; On-site; AED 279,000 - 446,000; Full time

Job summary

Raqmiyat is seeking a hands-on PL/SQL and ODI/OBIEE specialist to design and optimize data solutions in a demanding BI environment in Dubai.

You will develop complex PL/SQL code, build ETL processes with ODI, model relational data, and create OBIEE dashboards and reports to meet business needs. You will install configure and tune ETL/BI tools and work with teams to drive improvements.

Strong debugging, collaboration skills, and the ability to work six days a week Sunday-Friday are expected.

Qualifications

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

Responsibilities

• Develop complex and optimized PL/SQL packages, procedures, triggers and functions.
• Analyze, design and implement relational data models to support app/reporting needs.
• Build and maintain ETL processes using 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, DB performance bottlenecks and integration errors.
• Support ongoing maintenance and enhancement of existing data solutions.

Skills

PL/SQL development

SQL queries & procedures

ODI

OBIEE development

ETL tooling

Data modeling

BI tool tuning

Troubleshooting

Tools

Oracle Data Integrator (ODI)

OBIEE

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)