Oracle OAC, ODI & PL/SQL Developer

About the role

Namasys Analytics is hiring an experienced Oracle OAC, ODI and PL/SQL developer in Abu Dhabi. The role covers analytics dashboards and reports, data integration workflows, database programs and production support for enterprise reporting and data warehouse solutions, including modernizing legacy OBIEE reports to Oracle Analytics Cloud.

Key responsibilities

• Develop, maintain and support OAC dashboards, analyses, visualizations and reports, and troubleshoot reporting failures, query issues and performance problems
• Migrate RPD repositories and catalogs across environments, coordinate user access, roles and LDAP authentication, and migrate legacy OBIEE reports to OAC
• Build and maintain ODI mappings, packages, procedures, scenarios and load plans, monitor scheduled loads, fix ETL issues and optimize data loading performance
• Develop and tune complex SQL queries, views and analytical functions, and PL/SQL procedures, functions, packages, triggers and cursors
• Provide production support, perform root-cause analysis, maintain technical documentation and ensure data accuracy and compliance with development standards

Required profile

• Minimum 6 years of experience in Oracle BI, data integration, database development and production support
• Hands-on experience with Oracle Analytics Cloud (OAC) and OBIEE
• Experience with RPD repository development or administration and catalog migrations
• Strong understanding of ETL, data warehousing, data modelling and source-to-target reconciliation

Required skills

• Oracle Analytics Cloud (OAC) and OBIEE
• Oracle Data Integrator (ODI)
• Advanced Oracle SQL and PL/SQL
• SQL tuning, query optimization and database performance troubleshooting
• OAC security, role assignments, LDAP authentication and environment migrations