Description

Develop and maintain complex reporting solutions within the Oracle ERP Cloud ecosystem.

Responsibilities

• Collaborate with users to define requirements and align on report deliverables.
• Develop and customize reports, prompts, and dashboards using OTBI and BI Publisher.
• Build data models and write complex SQL for reports based on Oracle Fusion Cloud tables.
• Manage mass data extracts using Oracle Business Intelligence Cloud Connector, including scheduling and incremental extracts.
• Troubleshoot performance issues and analyze existing SQL to resolve technical defects.

Required Skills

• 8-10 years of experience in OBIEE/OBIA development.
• Expertise in Oracle Transactional Business Intelligence (OTBI) and FAW reports.
• Proficiency with BI Publisher reporting and data model construction.
• Strong Oracle SQL skills for querying Oracle Fusion Cloud tables.
• Deep knowledge of Oracle ERP Cloud GL, AP, AR, PA, and FA transactional and subledger data.
• Experience developing high data volume reports.
• Hands-on experience with Oracle Business Intelligence Cloud Connector for mass data extraction and log monitoring.
• Ability to manage on-demand and scheduled incremental extracts.

Key Skills

Education

Any Graduate