Description:
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.