Sign up to access all features of our service
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Oracle Oac, Odi & Pl/sql Developer

Full-time

Namasys Analytics

We are looking for an experienced Oracle OAC, ODI & PL/SQL Developer with strong expertise in Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), Oracle SQL, PL/SQL, and OBIEE. The candidate will be responsible for developing and enhancing analytics dashboards and reports, building and optimizing data integration workflows, developing database programs, and providing production support for enterprise reporting and data warehouse solutions.

 

The role also involves troubleshooting data discrepancies, optimizing data loads and database performance, supporting OAC security and migrations, and modernizing legacy OBIEE reports to Oracle Analytics Cloud.

 

Key Responsibilities

 

1. Oracle Analytics Cloud (OAC) & OBIEE

 

  • Develop, enhance, and maintain OAC dashboards, analyses, visualizations, and reports
  • Provide production support for dashboard, report, data, and performance-related issues
  • Troubleshoot reporting failures, data discrepancies, query execution issues, and dashboard performance problems.
  • Perform RPD repository and Catalog migrations across environments, including validation and post-migration testing.
  • Coordinate user access provisioning, role assignments, and LDAP authentication issues with infrastructure and security teams
  • Analyze OAC session logs, generated SQL, and query execution details to identify and resolve reporting issues.
  • Support the migration and modernization of legacy OBIEE reports and dashboards to OAC.
  • Validate report outputs, calculations, filters, prompts, and data consistency across environments.

 

2. Oracle Data Integrator (ODI)

 

  • Develop and maintain ODI mappings, packages, procedures, scenarios, and load plans
  • Configure and manage source and target connections for data integration workflows.
  • Enhance existing ODI mappings to support new business requirements, additional columns, and transformation logic changes.
  • Monitor scheduled data loads, troubleshoot failures, and implement error-handling and recovery procedures
  • Investigate ETL issues, data discrepancies, and source-to-target reconciliation failures.
  • Optimize ODI mappings, transformations, and data loading processes to improve performance.
  • Analyze ODI session logs and execution statistics to identify bottlenecks.
  • Support the deployment and migration of ODI objects across development, testing, and production environments.

 

3. Oracle SQL & PL/SQL Development

 

  • Develop, maintain, and optimize complex SQL queries, joins, subqueries, analytical functions, views, and data extraction logic.
  • Develop and maintain PL/SQL procedures, functions, packages, triggers, cursors, and exception-handling routines
  • Implement error handling, logging, and recovery mechanisms in database programs and data processing workflows.
  • Perform data validation, reconciliation, and root-cause analysis using SQL queries and OAC-generated SQL.
  • Analyze source tables, views, and dependencies to identify the root causes of data discrepancies.
  • Optimize database performance through execution-plan analysis, SQL tuning, indexing, and partitioning.
  • Develop and maintain stored procedures for materialized view refreshes and related data processing activities.
  • Troubleshoot PL/SQL execution errors, data integrity issues, and long-running database operations.
  • Support data extraction, transformation, aggregation, and reconciliation requirements across reporting and data warehouse systems.

 

4. Production Support & Performance Optimization

 

  • Provide ongoing production support for OAC, ODI, OBIEE, and database-related issues.
  • Perform root-cause analysis and implement corrective and preventive actions.
  • Monitor scheduled jobs, data loads, report execution, and integration workflows
  • Coordinate with business users, database administrators, infrastructure teams, and other technical stakeholders to resolve issues.
  • Maintain technical documentation for mappings, reports, database programs, migrations, and support procedures.
  • Ensure data accuracy, system reliability, and adherence to established development and deployment standards.

 

Required Technical Skills

 

  • Minimum 6 years of relevant experience in Oracle BI, data integration, database development, and production support.
  • Hands-on experience with Oracle Analytics Cloud (OAC) and OBIEE
  • Strong knowledge of Oracle Data Integrator (ODI), including mappings, packages, procedures, scenarios, and load plans
  • Advanced proficiency in Oracle SQL and PL/SQL programming
  • Experience with RPD repository development or administration and Catalog migrations.
  • Strong understanding of ETL processes, data warehousing concepts, data modelling, and source-to-target reconciliation.
  • Experience in SQL tuning, query optimization, and database performance troubleshooting.
  • Knowledge of OAC security, role assignments, LDAP authentication coordination, and environment migrations.
  • Experience supporting production environments and resolving complex data and reporting issues.

 

Vacancy posted 27 days ago
Similar jobs that could be interesting for youBased on the Oracle Oac, Odi & Pl/sql Developer in Abu Dhabi vacancy
  •  ...We are seeking experienced Oracle Retail Cloud Functional and Techno...  ...Strong expertise in SQL, PL/SQL, Pro*C, Shell scripting Hands...  ...Proven capability in designing, developing, testing, deploying, and...  ...technologies , including: OIC, ADF, ODI, Informatica, OBIEE, SOA... 

    TechBiz Global GmbH

    Abu Dhabi
    2 days ago
  • AED20000 - 23000 per month

     ...We have an urgent requirement for Senior Oracle FLEXCUBE SME((12.x/14.x), Core/CIF, CASA, Deposits, Lending, Trade Finance, Payments,...  ...Web Services), Oracle Banking APIs and REST integration.SQL and PL/SQL for analysis and troubleshooting.FLEXCUBE batch architecture and... 

    Talent Arabia

    Abu Dhabi
    3 days ago
  •  ...Pricing orchestration Real-time price streaming Develop systems capable of high throughput and deterministic latency performance Pricing & Quant Integration... 

    Luxoft

    Abu Dhabi
    2 days ago
  •  ...Tech ECS Limited is seeking an experienced Oracle EPM Cloud Consultant to join its team in Abu Dhabi. This role is ideal for professionals...  ...support, and performance optimization activities. • Develop and maintain Oracle EPM applications using industry best practices... 

    Tech ECS Limited

    Abu Dhabi
    22 days ago
  • AED18000 - 20000 per month

     ...We have an urgent requirement for Oracle FLEXCUBE Techno Functional Consultant(Core Banking Support) in Banking Domain for one of our banking client in Abu Dhabi, UAE     Provide L2/L3 support for Oracle FLEXCUBE and related banking applications. Handle incidents... 

    Talent Arabia

    Abu Dhabi
    3 days ago
  •  ...We are seeking a highly skilled Senior Full-Stack Developer to join our engineering team in Abu Dhabi. In this role, you will lead the development and integration of high-impact, multi-tenant digital service portals. The ideal candidate has deep expertise in building secure... 

    Edge Corporation

    Abu Dhabi
    5 days ago
  •  ...We are seeking an experienced OutSystems Senior Developer with strong expertise in designing, developing, and delivering high-performance web and mobile applications using the OutSystems platform. The successful candidate will play a key role in solution architecture... 

    Tech Mahindra

    Abu Dhabi
    11 days ago
  •  ...At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio. We are currently seeking a .Net Developer to join one of our clients ' teams. If you're looking for an exciting opportunity to grow in a innovative environment, this could... 

    TechBiz Global GmbH

    Abu Dhabi
    5 days ago
  •  ...third-party development within ADNOC Distribution's Mobility Hub strategy by originating, structuring, and coordinating investor/developer projects from concept to handover. Act as the single point of contact for external developers and investors, managing the commercial... 

    ADNOC

    Abu Dhabi
    5 days ago
  •  ...both our clients and our people. About the job As an Oracle EBS Finance Functional Consultant, you will be responsible for...  ...teams for integrations, reports, workflows, and custom developments. - Configure and customize Oracle EBS Finance modules to meet... 
    Remote job

    Nexttec Technology Outsourcing

    Abu Dhabi
    more than 2 months ago
  •  .../ Onsite Experience Required: Minimum 3 Years Job Summary We are looking for an experienced and skilled Frontend Developer to join our team. The ideal candidate should have strong hands-on experience in modern frontend development, with expert-level knowledge... 

    List International

    Abu Dhabi
    a month ago
  • The Integration Developer will be responsible for the design, build, testing, deployment and support of market data connectors feeding the Pricing Engine, with a primary focus on Bloomberg B-PIPE and LSEG Real-Time Market Data System (RTMDS). The scope covers real-time... 

    Luxoft

    Abu Dhabi
    10 days ago
  •  ...Job Title: SharePoint & Power Automate Developer Job Summary We are looking for an experienced SharePoint & Power Automate Developer to design, develop, customize, and support end-to-end business solutions using Microsoft SharePoint and Power Automate.... 

    Theomnihire

    Abu Dhabi
    a month ago
  •  ...Role Overview: We are seeking a skilled CRM Developer with 5–8 years of experience to develop, customise, integrate, and enhance CRM solutions using Microsoft Dynamics 365 and Power Platform. The role will focus on delivering robust CRM functionality, automation, integrations... 

    NorthBay Solutions

    Abu Dhabi
    a month ago
  •  ...Project description We are seeking an experienced Software Developer to help modernize a mission-critical Portfolio Management System (PMS) used by investment professionals across front-office investment functions. The successful candidate will play a key role in transforming... 

    Luxoft

    Abu Dhabi
    19 days ago
  •  ...have a global network of 32 offices serving clients in more than 40 countries worldwide. Job Description The Mobile App Developer is responsible for designing, developing, and maintaining the card pay mobile application, and making sure to deliver excellent... 

    Virtua Advanced Solution

    Abu Dhabi
    12 days ago
  •  ...shaping the future. ABOUT THE ROLE Halcon is seeking a talented Senior Engineer: Software (Embedded Software Engineer) to develop, integrate, test, and verify safety-critical real-time embedded software solutions for advanced defense and aerospace platforms.The... 

    EDGE Group

    Abu Dhabi
    10 days ago
  • We are looking for a Senior Java Integration Developer with deep expertise in distributed systems, Enterprise Integration Patterns (EIP), and reactive architectures to build our next-generation Portable Domain Integration API Layer. Responsibilities... 

    Luxoft

    Abu Dhabi
    3 days ago
  • AED16000 - 18000 per month

     ...stories API’s & Micro services System integration SQL & PL/SQL Technical analysis & troubleshooting Integration,...  ...validation Timely resolution of issues Tools / Platforms Jira, Confluence, ServiceNow, SQL Developer, PLSQL Developer, Postman, SoapUI... 

    Talent Arabia

    Abu Dhabi
    3 days ago
  •  ...Design, build and maintain backend services and APIs in Java Develop microservices with Spring Boot and integrate them with internal...  ...Good SQL skills and experience with relational databases (Oracle, PostgreSQL, etc.) Familiar with Git, CI/CD and containerisation... 

    Jex Recruitment | Connecting top talent with leading compani...

    Abu Dhabi
    9 days ago
  •  ...activities include working with cost and planning engineers to develop work breakdown structures and robust performance baselines, establishing...  ...of the following tools (or one of) is also required: Oracle Primavera, MS Project, Excel, PRISM (Cost Management System)... 

    Turner & Townsend

    Abu Dhabi
    9 days ago
  •  ...alignment with organizational requirements and budget constraints Develop and maintain relationships with vendors and suppliers,...  ...proficiency with procurement software and ERP systems (such as SAP, Oracle, or similar platforms) ~ Advanced analytical and data analysis... 

    Egis Group

    Abu Dhabi
    10 days ago
  •  ...representatives and continually endeavours to keep abreast of developments that influence procurement procedures and practices. • Maintains...  ...skill is a must- Spreadsheet and Database including working experience in ERP environment (MAXIMO/ORACLE/SAP) is required.... 

    ADNOC

    Abu Dhabi
    5 days ago
  •  ...expertise of its 19,500 employees at the service of its clients and develops cutting-edge innovations accessible to all projects. Through...  ...Experience with project management software such as Oracle Primavera P6, Microsoft Project, or equivalent tools Excellent... 

    Egis Group

    Abu Dhabi
    18 days ago
  •  ...and commercial excellence. Masdar is a clean energy investor, developer and operator, advancing renewable energy projects across key markets...  ...Enel, Iberdrola, TAQA, ACWA, DEWA, etc); familiarity with SAP, Oracle, O&M, IFS, Document-control, Construction SaaS, Azure, digital-... 

    Masdar

    Abu Dhabi
    3 days ago
  •  ...project management, system administration and document controls to develop a project set-up that facilitates both internal and external...  ...of the application of the Worley core systems such as Oracle (finance and time sheeting), and Ecosys (Project Control). Responsible... 

    Worley

    Abu Dhabi
    20 days ago
  •  ...and optimize product structures, BOMs, and engineering data. Develop and improve workflows supporting product development and change...  ...control. Experience with leading ERP platforms such as SAP, Oracle, or Microsoft Dynamics. PREFERRED QUALIFICATIONS... 

    EDGE Group

    Abu Dhabi
    19 days ago
  •  ...Job Responsibilities   Portfolio Planning & Performance Develop and maintain integrated portfolio programmes across all D-Sell...  ...Project Portfolio reporting Risk management Power BI / Oracle / AI-enabled reporting tools Interpersonal Skills Strategic... 

    Aldar

    Abu Dhabi
    12 days ago
  •  ...delivering datasets. Instead, the role is centred on: • Designing and developing shared platform capabilities • Building internal libraries and...  ...skills for troubleshooting and performance optimisation (e.g., Oracle, MS SQL). ~Experience with Git and CI/CD workflows. ~... 

    Luxoft

    Abu Dhabi
    19 days ago
  •  ...~ KSA ZATCA requirements ~ DOH Abu Dhabi and KSA MOH reporting standards Experience using accounting software such as: Oracle Zoho Books Tally QuickBooks Core Skills Financial reporting and reconciliations VAT, tax, and regulatory compliance... 

    alkalma Healthcare

    Abu Dhabi
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Oracle Oac, Odi & Pl/sql Developer. Be the first to apply!