Role: Oracle OAC with FDI Consultant

Location: Toronto, ON (Onsite)

Project Overview:

We are seeking an experienced Oracle Analytics Cloud (OAC) and Fusion Data Intelligence (FDI) consultant to lead the design, implementation, and optimization of enterprise analytics solutions for our clients. The ideal candidate possesses deep expertise in OAC, FDI/FAW, and data integration tools, with a solid understanding of Oracle Fusion applications (ERP, HCM, SCM). You will collaborate closely with business stakeholders to translate complex requirements into scalable, high-performance analytics platforms.

Responsibilities:

- Lead the design and implementation of analytics solutions using Oracle Fusion Data Intelligence (FDI) and Oracle Analytics Cloud (OAC).
- Develop custom dashboards, reports, KPIs, and visualizations in OAC based on business requirements.
- Extend FDI semantic models and subject areas to incorporate custom measures, calculations, and external data sources.
- Design, develop,



and maintain ETL/ELT data pipelines using Oracle Data Integrator (ODI) and OCI Data Integration to extract, transform, and load data from multiple sources into Autonomous Data Warehouse (ADW).
- Perform data modeling, data validation, and reconciliation between source systems and FDI to ensure data accuracy and consistency

If you are interested, please send your updated resume to [email protected]. Pay: $50.00-$60.00 per hour

Application question(s)

- Which Oracle Fusion pillars have you built analytics for? (ERP / HCM / SCM / Two or more / None) ?
- Have you built ELT pipelines using OCI Data Integration (not just ODI on-prem)

Experience:
- Oracle Analytics Cloud: 4 years (preferred)
- Oracle Fusion Data Intelligence (FDI/FAW): 2 years (preferred)
- Oracle Data Integrator (ODI): 3 years (required)
- Autonomous Data Warehouse (ADW): 2 years (required)

Work Location: In person

📌 Oracle OAC with FDI Consultant (Toronto)
🏢 Prophecy Technologies
📍 Toronto