Oracle Cloud EPM Technical Consultant

Job Description:

• 5+ years of experience in PCMCS and EDMCS modules
• Must have experience on allocation rules, dimension building & expense model building
• Must have experience in automating data loads using EPM automate
• Must have experience in data integration between various application to PCMCS
• Should have very good understanding and experience in Oracle Financial Consolidation and Close Cloud (FCCS)
• Hands on Implementation experience of Oracle EDMCS (Exports, Imports, Blenders, Action Scripts, Property Definition and Property Categories)
• Experience in application migration from Oracle DRM to EDMCS
• Job automation in EDMCS using EPM automate
• Security implementation in EDMCS application
• Must have knowledge on REST API & Groovy for Data Management
• EDMCS application migration from lower to higher environment
• Should have good Hyperion production Support experience
• Good to have knowledge on Linux/shell scripting
• Must have good communication to interact with client at all levels
• Must have experience in writing Python Scripts to trigger CDM/FDMEE jobs
• Must have experience in performance tuning in CDM/FDMEE application
• Must be strong in PL/SQL working with multiple databases
• Good to have production support experience in CDM & FDMEE tool
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables
• Demonstrated experience assisting in defining the systems strategy, gathering, and documenting business requirements, leading fit-gap analysis, AS-IS and TO- BE business process designs, configuration management, testing and end user training
• Ability to collaborate with team members and business customers
• Strong communication skills to present the ideas, recommendations and be an influencer
• Have worked / supported on integration of EDMCS with Hyperion tools like EPBCS, PCMCS etc