Job Description: Oracle Fusion Data Intelligence (FDI) Consultant

Role Summary

We are seeking an experienced Oracle Fusion Data Intelligence (FDI) Consultant to design, extend, and deliver enterprise-grade analytics and insights for Oracle Fusion Cloud applications. The ideal candidate will have strong hands-on expertise in FDI, Autonomous Data Warehouse (ADW), and cross-functional Fusion analytics, with OTBI and BI Publisher as complementary reporting skills.

This role requires the ability to translate complex business data into actionable dashboards, ensure data accuracy and security, and support business-critical reporting across operational and analytical use cases.

Experience Requirements

• 6–8 years of overall IT experience
• Minimum 3 years of hands-on experience in Oracle FDI / Fusion Analytics
• At least 3 full-cycle project implementations involving Oracle Fusion reporting and analytics

Key Responsibilities

Oracle Fusion Data Intelligence (FDI) Analytics

• Extend out-of-the-box FDI subject areas by creating custom views, datasets, and transformations in Autonomous Data Warehouse (ADW) to address reporting gaps.
• Combine data across multiple Fusion modules such as:
• Order Management
• Inventory Management
• Shipping & Logistics
• Financials (GL, AP, AR)
• Design and deliver curated FDI dashboards aligned to business functions, simplifying subject-area complexity for end users.
• Ensure Fusion role-based security and Operating Unit (OU) security are correctly inherited and enforced within FDI analytics and dashboards.
• Optimize FDI data models and dashboards for performance and usability.

Operational & Transactional Reporting

• Design and develop OTBI reports to support:
• Real-time operational reporting
• Transactional insights
• Day-to-day business monitoring
• Develop BI Publisher (BIP) reports for:
• High-volume transactional outputs
• Complex and pixel-perfect layouts
• Regulatory, statutory, and scheduled reporting
• Apply correct reporting tool usage:
• OTBI → Real-time and operational reporting
• FDI → Analytical, trend-based, and historical insights
• BI Publisher → Pixel-perfect and bulk transactional reporting

Data Validation & Quality Assurance

• Perform end-to-end data reconciliation and validation across:
• Oracle Fusion source modules
• FDI / Autonomous Data Warehouse (ADW)
• OTBI reports
• BI Publisher outputs
• Ensure data consistency, accuracy, and completeness during:
• Month-end and quarter-end close cycles
• Go-live and post-production phases
• Identify and resolve data discrepancies proactively.

Required Skills & Competencies

• Strong expertise in Oracle Fusion Data Intelligence (FDI)
• Hands-on experience with Autonomous Data Warehouse (ADW)
• Advanced knowledge of OTBI and BI Publisher
• Strong SQL skills for analysis and validation
• Solid understanding of Oracle Fusion Cloud modules
• Experience with data security, role-based access, and OU security
• Excellent analytical, problem-solving, and communication skills

Nice to Have

• Experience with FDI extensions and customizations
• Exposure to performance tuning in ADW/FDI
• Client-facing or consulting background