Oracle OAC, ODI & PL/SQL Developer

Role overview

OAC and OBIEE

• Build and maintain OAC dashboards, analyses, visualizations, and reports; support report, data, and performance issues.
• Migrate RPD repositories and Catalogs; validate outputs, calculations, filters, prompts, and data consistency.
• Coordinate access, roles, and LDAP issues; analyze logs and generated SQL; modernize legacy OBIEE content to OAC.

ODI and data integration

• Develop ODI mappings, packages, procedures, scenarios, and load plans; configure source and target connections.
• Enhance transformations, monitor scheduled loads, resolve ETL and reconciliation failures, and implement recovery procedures.
• Optimize data workflows, analyze session logs, and support deployment across development, test, and production.

SQL, PL/SQL, and support

• Develop and tune SQL queries, PL/SQL programs, database routines, and stored procedures for data processing and materialized view refreshes.
• Perform validation, reconciliation, root-cause analysis, execution-plan analysis, indexing, and partitioning as needed.
• Support OAC, ODI, OBIEE, and database production issues; monitor jobs and coordinate with users and technical teams.
• Maintain technical documentation and ensure data accuracy, reliability, and adherence to development and deployment standards.

Required qualifications

• At least 6 years of relevant Oracle BI, data integration, database development, and production support experience.
• Hands-on OAC and OBIEE; strong ODI knowledge; advanced Oracle SQL and PL/SQL.
• Experience with RPD development or administration, Catalog migrations, ETL, data warehousing, data modeling, and reconciliation.
• Experience with SQL tuning, database performance troubleshooting, OAC security, role assignments, LDAP coordination, and production support.

Preferred qualifications

• Experience migrating legacy OBIEE reports and dashboards to OAC, and working with enterprise data warehouses and complex reporting environments.
• Familiarity with materialized views, database partitioning, indexing, and scheduled data processing.
• Analytical problem-solving, communication, stakeholder coordination, and effectiveness in time-sensitive project environments.