Oracle EPM DI Consultant will be part of project delivery and responsible for the following activities:
? Working closely with Hyperion Planning and HFM Techno-Functional Consultants to understand data integration requirements.
? Driving technical design of FDMEE and Cloud Data Management solution to load data into Hyperion Planning, HFM, PBCS/ EPBCS, FCCS applications.
?Driving technical design of suitable metadata load solution using Outline Load Utility, EPM Automate, FDMEE etc.
? Coordinating and driving discussions with relevant teams for design sign-off.
? Mentoring and supporting Tech Mahindra development team through the implementation phase of the project.
? Reviewing system documentation and training material.
? Driving System Integration Testing and supporting User Acceptance Testing of the data integration solution.
? Production deployment and roll out.
Required Experience ? 7+ yrs of IT experience with min 5 years of expereince focused on Oracle Hyperion FDMEE, Cloud Data Management and Metadata Integration tools
? Hands-on experience with the latest version of Oracle Hyperion - i.e. 220.127.116.11.
? Demonstrated experience in designing and implementing EPM Data Integration solutions.
? Managed and executed at least 2 end-to-end FDMEE implementations covering complete life cycle with Hyperion Planning and/or HFM applications as target and 1 Cloud EPM data integration solution (PBCS/ FCCS)
? Well versed with Import Format, Location, Period Mapping, Category Mapping, Data Load Rule, Data Load Mapping, etc.
? Hands-on experience around FDMEE scripting (import/mapping/event/custom scripts).
? Should have worked on Batch Definition and Execution in FDMEE.
?? Experience in direct integration with Oracle EBS or Fusion Cloud for data load will be beneficial.
? Well versed in oral and written communication. Must be able to articulate his/her thoughts clearly.
? Good documentation skills.
Tool/Technology Skills Must have hands-on experience in working with the following tools/technologies:
1) Oracle Hyperion FDMEE with Hyperion Planning and/or HFM as the target.
2) FDMEE Scripting (Jython/VBScript/SQL).
3) Metadata Integration Technologies (Outline Load, EPM Automate etc.)
4) Expert in SQL
5) Excel Macro skills (good to have)
Note: Experience in working with Oracle Data Integrator will be an added benefit.