Oracle Techno-Functional Consultant – FAH & Fusion Data Intelligence (FDI)

Role: Oracle Techno-Functional Consultant – FAH & Fusion Data Intelligence (FDI)

Location: Remote

We are seeking an experienced Oracle Techno-Functional Consultant with strong expertise in Oracle Financials Accounting Hub (FAH) and Oracle Fusion Data Intelligence (FDI). The consultant will be responsible for designing, implementing, integrating, and supporting financial data and analytics solutions across Oracle Fusion Cloud applications.

The ideal candidate should have a strong understanding of Finance business processes, Oracle Financials, Accounting Hub, data integration, reporting, and analytics, combined with hands-on technical experience in FDI and Oracle Cloud technologies.

Key Responsibilities

FAH – Functional & Technical

• Design and implement Oracle Financials Accounting Hub (FAH) solutions based on business and accounting requirements.
• Configure and support Accounting Hub rules, sources, journal entry rules, mapping sets, account derivation rules, and accounting methods.
• Analyze upstream transaction sources and design appropriate accounting transformations and integrations.
• Develop and troubleshoot integrations between FAH and Oracle Fusion Cloud Financials or external source systems.
• Support Subledger Accounting (SLA) configurations, accounting rules, journal generation, and reconciliation processes.
• Work with Finance stakeholders to translate accounting requirements into Oracle FAH solutions.
• Perform data validation, reconciliation, unit testing, integration testing, and production support.
• Investigate accounting and data issues and provide root-cause analysis and corrective solutions.

Fusion Data Intelligence (FDI)

• Design and implement analytics solutions using Oracle Fusion Data Intelligence (FDI).
• Configure and extend FDI subject areas, semantic models, dashboards, KPIs, and analytical content as required.
• Work with Oracle Fusion Cloud application data and understand the underlying business and analytical data models.
• Develop and customize Oracle Analytics Cloud (OAC) dashboards, reports, visualizations, and KPIs within the FDI ecosystem.
• Support data ingestion, transformation, validation, and reconciliation between Oracle Fusion applications and FDI.
• Analyze and troubleshoot data pipeline, data refresh, and reporting issues.
• Develop data models and analytical solutions to support Finance, Accounting, and Management Reporting requirements.
• Work with business users to define reporting requirements and translate them into FDI/OAC analytical solutions.

Integration & Technical Responsibilities

• Design and support integrations using Oracle integration and data technologies such as Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, and other Oracle integration mechanisms.
• Understand data flows between Oracle Fusion applications, FAH, FDI, and external systems.
• Perform data mapping, transformation, validation, and reconciliation.
• Troubleshoot integration failures and data-quality issues.
• Work with technical teams on extraction, transformation, and loading of financial data.
• Participate in solution design, technical documentation, code/configuration reviews, and deployment activities.

Functional Responsibilities

• Collaborate with Finance, Accounting, IT, Data, and Analytics teams to understand business requirements.
• Provide guidance on accounting, financial reporting, data, and analytics requirements.
• Conduct requirement workshops and prepare functional and technical design documents.
• Support UAT, user training, deployment, and post-production stabilization.
• Provide production support and participate in incident and problem management.
• Ensure solutions follow Oracle Cloud best practices and organizational standards.

Required Skills & Experience

• 6+ years of experience in Oracle ERP/Oracle Financials consulting, implementation, or support.
• Strong hands-on experience with Oracle Financials Accounting Hub (FAH) and Subledger Accounting (SLA).
• Strong experience with Oracle Fusion Cloud Financials.
• Hands-on experience with Oracle Fusion Data Intelligence (FDI).
• Experience with Oracle Analytics Cloud (OAC) and financial reporting/analytics.
• Good understanding of Finance processes such as:
  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Fixed Assets
  • Cash Management
  • Subledger Accounting
  • Financial Reporting
• Experience with Oracle Fusion data models and financial subject areas.
• Strong SQL skills for data analysis, validation, reconciliation, and troubleshooting.
• Experience with REST/SOAP APIs and Oracle integration technologies.
• Knowledge of Oracle Integration Cloud (OIC) is highly desirable.
• Experience with FBDI, spreadsheets, file-based integrations, or other Oracle Cloud data-loading mechanisms.
• Strong understanding of data integration and data warehouse concepts.
• Excellent analytical and problem-solving skills.

Preferred Skills

• Oracle Cloud Financials certification.
• Experience with FAH implementations involving external/non-Oracle source systems.
• Experience building financial dashboards and KPIs in FDI/OAC.
• Knowledge of Oracle Autonomous Data Warehouse (ADW) and Oracle Cloud Infrastructure (OCI).
• Experience with data governance, data quality, and financial reconciliation.
• Experience working in large-scale Oracle Cloud transformation programs.
• Knowledge of accounting standards and financial reporting requirements.
• Experience in Agile delivery methodologies.

Key Deliverables

• FAH accounting solution design and configuration.
• Accounting rules and mapping documentation.
• FDI data and analytics solution design.
• Financial dashboards, KPIs, and analytical reports.
• Integration and data-mapping specifications.
• Data reconciliation and validation frameworks.
• Functional and technical design documents.
• Test scenarios, test scripts, and defect resolution.
• Production support and root-cause analysis.