Back to Jobs

[Remote] Oracle FDI Consultant

Remote, USA Full-time Posted 2026-06-21

Note: The job is a remote job and is open to candidates in USA. Prophecy Technologies is seeking an Oracle FDI Consultant with extensive experience in Oracle BI Apps and custom data warehouse implementations. The role involves managing projects, delivering solutions, and working closely with clients to ensure successful outcomes in various Oracle modules.

Responsibilities

  • 14+ years of experience in handling implementations of Oracle BI Apps or development of Custom Data Warehouses
  • Experience in working with FDI, ODI MP, OAC
  • Hands on experience in development and customizations for FDI, OAC, OBIA ODI and OBIEE
  • Experience in working with Cloud HCM, Cloud ERP and PVO analysis for designing DWH
  • Knowledge in integrating multiple data sources to load into Enterprise DWH
  • OAC, OBIA, OBIEE, ODI Certifications are plus
  • Have very good functional understanding of Oracle HCM, Financials, SCM, Procurement etc
  • Worked in at least 6 to 10 full life-cycles of OAC implementations. OBIA implementation for modules like HR, Financial Analytics, Procurement & Spend Analytics, Supply Chain Management, Project Analytics
  • Have experience in responding to RFPs, review documents and participate in Orals
  • Ability to identify risks, and communicate mitigation plan with key stakeholders at client
  • Ability to perform Project Management, Delivery Management and Client communications
  • Understanding requirement, solution blueprint, performing fit gap analysis, Business process designs
  • Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure
  • Experience as architect for Dimension Modelling and Data Warehouse builds
  • Experience of effective performance tuning
  • Must be well versed and hands-on in troubleshooting various issues and providing workarounds
  • Ability to prepare Status reports and communicate with client
  • Good problem solver and prompt decision maker
  • Able to plan / track tasks / activities / co-ordinate and report on periodical basis
  • Onsite Offshore Co-ordination on a day-to-day basis on deliverables and inter-team interaction on need basis

Skills

  • 14+ years of experience in handling implementations of Oracle BI Apps or development of Custom Data Warehouses
  • Experience in working with FDI, ODI MP, OAC
  • Hands on experience in development and customizations for FDI, OAC, OBIA ODI and OBIEE
  • Experience in working with Cloud HCM, Cloud ERP and PVO analysis for designing DWH
  • Knowledge in integrating multiple data sources to load into Enterprise DWH
  • Have very good functional understanding of Oracle HCM, Financials, SCM, Procurement etc
  • Worked in at least 6 to 10 full life-cycles of OAC implementations. OBIA implementation for modules like HR, Financial Analytics, Procurement & Spend Analytics, Supply Chain Management, Project Analytics
  • Have experience in responding to RFPs, review documents and participate in Orals
  • Ability to identify risks, and communicate mitigation plan with key stakeholders at client
  • Ability to perform Project Management, Delivery Management and Client communications
  • Understanding requirement, solution blueprint, performing fit gap analysis, Business process designs
  • Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure
  • Experience as architect for Dimension Modelling and Data Warehouse builds
  • Experience of effective performance tuning
  • Must be well versed and hands-on in troubleshooting various issues and providing workarounds
  • Ability to prepare Status reports and communicate with client
  • Good problem solver and prompt decision maker
  • Able to plan / track tasks / activities / co-ordinate and report on periodical basis
  • Onsite Offshore Co-ordination on a day-to-day basis on deliverables and inter-team interaction on need basis
  • OAC, OBIA, OBIEE, ODI Certifications are plus

Company Overview

  • Prophecy Technologies provides staffing solutions such as contract, contract-to-hire, and permanent employment. It was founded in 2014, and is headquartered in California City, California, USA, with a workforce of 501-1000 employees. Its website is https://www.prophecytechs.com/.
  • Company H1B Sponsorship

  • Prophecy Technologies has a track record of offering H1B sponsorships, with 24 in 2024, 24 in 2023, 28 in 2022, 8 in 2021, 14 in 2020. Please note that this does not guarantee sponsorship for this specific role.
  • Apply To This Job

    Similar Jobs

    [Remote] Director of Strategic Sales, Detroit

    Remote, USA Full-time

    [Remote] Sales Manager

    Remote, USA Full-time

    [Remote] Customer Service Phone Agent (Wild Pastures | US, Remote)

    Remote, USA Full-time

    [Remote] Senior Data and Analytics Engineer

    Remote, USA Full-time

    [Remote] Solutions Architect Automotive (Pre-sales)

    Remote, USA Full-time

    [Remote] Cardiac Rhythm Management Senior Sales Rep - Columbia, MO

    Remote, USA Full-time

    [Remote] Oracle Financial Consultant

    Remote, USA Full-time

    [Remote] Seasonal, Lead Customer Service

    Remote, USA Full-time

    [Remote] Account Manager-Supplements

    Remote, USA Full-time

    [Remote] Senior Account Manager - Commercial Lines

    Remote, USA Full-time

    Senior PHP Developer

    Remote, USA Full-time

    Surgical Equipment Manager -Retina - Atlanta, GA

    Remote, USA Full-time

    Territory Manager - Seattle, WA

    Remote, USA Full-time

    Director, HR Business Partner

    Remote, USA Full-time

    Typing Jobs ID-1853 – Amazon Store

    Remote, USA Full-time

    Experienced Remote Customer Service and Inside Sales Representative – Delivering Exceptional Customer Experiences and Driving Sales Growth in a Dynamic and Supportive Environment at blithequark

    Remote, USA Full-time

    Entry-Level Data Entry Specialist – Part‑Time Position at arenaflex – No Experience Required, Flexible Hours, Career Growth Opportunities

    Remote, USA Full-time

    Southwest Airlines Part-Time Remote Job – (Urge...

    Remote, USA Full-time

    Clinical Quality Operations Manager - Remote

    Remote, USA Full-time

    Florida Educational Trainer - Title Industry

    Remote, USA Full-time