Oracle FDI Specialist

Nexttec Technology Outsourcing; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Nexttec Technology Outsourcing seeks a skilled FDI (Fusion Data Intelligence) Specialist to integrate and analyze data from multiple sources, delivering actionable insights for business decisions.

You will own end-to-end delivery—from requirements and data modelling to dashboard UX, governance, and production support—building high-quality FDI dashboards and KPIs with strong UX and alerts. Strong SQL, dimensional modelling, and security expertise are essential.

Qualifications

• 4–6+ years in Oracle analytics/BI
• 2+ years hands-on with FDI (or FAW) and Oracle Analytics Cloud/Server (OAC/OAS)
• Advanced SQL (Oracle) and dimensional modelling
• Proven record building production dashboards with DV and analytics
• Experience with OTBI and BI Publisher for reporting
• Security: data roles and row-level access implementation
• Excellent requirements gathering and stakeholder communication

Responsibilities

• Design, build, and support BI analytics and dashboards across Fusion ERP and EPM using FDI schema and Oracle tooling.
• Own end-to-end delivery from requirements and data modelling to dashboard UX and governance.
• Create high-quality FDI dashboards and KPIs with strong UX, prompts, drill-downs, and alerts.
• Design conformed dimensions across ERP, HCM, EPM and define metrics.
• Implement row-level security, lineage, and documentation standards.
• Reconcile dashboard results to source data and define controls.
• Run demos, training, and hand-offs; produce runbooks and guides.
• Promote content across environments and support production incidents.

Skills

Oracle analytics

FDI schema

SQL (Oracle)

Dimensional modelling

KPI design

Data visualization

OTBI & BI Publisher

Tools

OAC/OAS

Job description

We are seeking a skilled FDI (Fusion Data Intelligence) Specialist to join our client team. The ideal candidate will be responsible for integrating and analyzing data from various sources to generate actionable insights that drive business decisions. Key responsibilities include:

Key responsibilities

• FDI (Fusion Data Intelligence) specialist to design, build, and support BI analytics and dashboards across Fusion ERP and EPM using the FDI schema and Oracle analytics tooling.
• You will own end-to-end delivery—from requirements and data modelling to dashboard UX, performance tuning, governance, and production support.
• Dashboard design & delivery (FDI/OAC): Build high-quality FDI dashboards and KPIs with strong UX (navigation, prompts/filters, drill-downs, alerts, mobile views).
• Semantic modelling: Design conformed dimensions and subject areas across ERP, HCM, EPM; define metrics (e.g., GL balances, AP aging, procurement spend, project performance, headcount/attrition, workforce cost, plan vs. actuals).
• Security & governance: Implement row-level/data-role security (BU/LE/Dept), lineage, naming standards, and documentation.
• Quality & reconciliation: Reconcile dashboard results to source (ERP/HCM/EPM); define controls and exception reports.
• Stakeholder enablement: Run demos, training, and hand-offs; create runbooks and self?service guides.
• Lifecycle & DevOps: Promote content across environments, version assets, manage change/releases, and support production incidents.

Required qualifications

• 1. 4 – 6+ years in Oracle analytics/BI, including 2+ years hands-on with FDI (or FAW) and Oracle Analytics Cloud/Server (OAC/OAS).
• 2. Strong FDI schema knowledge across ERP (GL, AP, AR, Procurement, Projects), and EPM (Planning/FCCS/ARCS reporting datasets).
• 3. Advanced SQL (Oracle), dimensional modelling (star/snowflake), and KPI design; capable of authoring logical/derived measures and complex filters.
• 4. Proven record building production dashboards with Data Visualization (DV) and classic analytics, including actions/drill-anywhere and alerts.
• 5. Experience with OTBI and BI Publisher (data models, bursting, scheduling) for complementary reporting.
• 6. Security: data roles, duty roles, row-level security implementation and testing.
• 7. Excellent requirements gathering, stakeholder communication, and documentation skills.

The successful candidate will possess strong analytical skills, proficiency in data visualization software, and a deep understanding of data management principles. Excellent communication skills and the ability to work collaboratively in a fast-paced environment are essential.