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.