[Remote] Oracle FDI Consultant

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.Responsibilities14+ years of experience in handling implementations of Oracle BI Apps or development of Custom Data WarehousesExperience in working with FDI, ODI MP, OACHands on experience in development and customizations for FDI, OAC, OBIA ODI and OBIEEExperience in working with Cloud HCM, Cloud ERP and PVO analysis for designing DWHKnowledge in integrating multiple data sources to load into Enterprise DWHOAC, OBIA, OBIEE, ODI Certifications are plusHave very good functional understanding of Oracle HCM, Financials, SCM, Procurement etcWorked 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 AnalyticsHave experience in responding to RFPs, review documents and participate in OralsAbility to identify risks, and communicate mitigation plan with key stakeholders at clientAbility to perform Project Management, Delivery Management and Client communicationsUnderstanding requirement, solution blueprint, performing fit gap analysis, Business process designsGood querying skills on Oracle database with ability to understand and debug PL/SQL procedureExperience as architect for Dimension Modelling and Data Warehouse buildsExperience of effective performance tuningMust be well versed and hands-on in troubleshooting various issues and providing workaroundsAbility to prepare Status reports and communicate with clientGood problem solver and prompt decision makerAble to plan / track tasks / activities / co-ordinate and report on periodical basisOnsite Offshore Co-ordination on a day-to-day basis on deliverables and inter-team interaction on need basisSkills14+ years of experience in handling implementations of Oracle BI Apps or development of Custom Data WarehousesExperience in working with FDI, ODI MP, OACHands on experience in development and customizations for FDI, OAC, OBIA ODI and OBIEEExperience in working with Cloud HCM, Cloud ERP and PVO analysis for designing DWHKnowledge in integrating multiple data sources to load into Enterprise DWHHave very good functional understanding of Oracle HCM, Financials, SCM, Procurement etcWorked 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 AnalyticsHave experience in responding to RFPs, review documents and participate in OralsAbility to identify risks, and communicate mitigation plan with key stakeholders at clientAbility to perform Project Management, Delivery Management and Client communicationsUnderstanding requirement, solution blueprint, performing fit gap analysis, Business process designsGood querying skills on Oracle database with ability to understand and debug PL/SQL procedureExperience as architect for Dimension Modelling and Data Warehouse buildsExperience of effective performance tuningMust be well versed and hands-on in troubleshooting various issues and providing workaroundsAbility to prepare Status reports and communicate with clientGood problem solver and prompt decision makerAble to plan / track tasks / activities / co-ordinate and report on periodical basisOnsite Offshore Co-ordination on a day-to-day basis on deliverables and inter-team interaction on need basisOAC, OBIA, OBIEE, ODI Certifications are plusCompany OverviewProphecy 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 SponsorshipProphecy 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.