Oracle EDMCS Consultant

Overview

#W2 Role Job Description

We are looking for an experienced Oracle EDMCS Consultant to support enterprise data governance, metadata management, and master data alignment across Oracle EPM and related financial systems. The consultant will work closely with Finance, Accounting, FP&A, IT, and business teams to manage hierarchies, dimensions, mappings, approvals, and metadata changes within Oracle Enterprise Data Management Cloud Service.

The ideal candidate should have strong hands-on experience in Oracle EDMCS / EDM, EPM metadata management, governance workflows, data validation, and integration with downstream applications such as Planning, FCCS, ARCS, EPBCS, ERP, or reporting platforms.

• Support design, configuration, and administration of Oracle EDMCS / EDM Cloud.
• Manage enterprise dimensions, hierarchies, node types, viewpoints, applications, and subscriptions.
• Build and maintain data governance workflows, approval processes, and change request models.
• Work with Finance and business users to gather metadata requirements and convert them into EDMCS solutions.
• Support metadata alignment across Oracle EPM applications such as Planning, FCCS, ARCS, EPBCS, and reporting systems.
• Configure validations, policies, permissions, and data quality rules.
• Manage imports, exports, mappings, subscriptions, and integrations with source and target systems.
• Support metadata migration, testing, reconciliation, and production deployments.
• Troubleshoot EDMCS issues related to hierarchy updates, approvals, validation errors, and integration failures.
• Prepare functional and technical documentation for processes, configurations, and support handoff.
• Collaborate with business stakeholders, architects, and offshore teams for timely delivery.

• 8+ years of experience in Oracle EPM / Hyperion ecosystem.
• 5+ years of hands-on experience with Oracle EDMCS / EDM Cloud.
• Strong understanding of metadata governance, master data management, and financial hierarchies.
• Experience with dimensions such as Entity, Account, Cost Center, Product, Location, Legal Entity, Department, and Custom dimensions.
• Hands-on experience with viewpoints, node types, node sets, hierarchy sets, applications, subscriptions, and request workflows.
• Experience integrating EDMCS with Oracle Planning, FCCS, EPBCS, ARCS, ERP Cloud, Essbase, or reporting tools.
• Strong knowledge of data validation, approvals, audit controls, and metadata reconciliation.
• Ability to work directly with business users and translate requirements into EDMCS design.
• Strong communication, documentation, and problem-solving skills.

• Experience with Oracle Cloud ERP and Oracle EPM Cloud integrations.
• Experience with EPM Automate, Data Management, REST APIs, or automation scripts.
• Prior experience in finance transformation, Oracle EPM implementation, or metadata governance projects.
• Knowledge of financial close, planning, forecasting, consolidation, and reporting processes.

• EDMCS application design and configuration.
• Metadata governance and approval workflows.
• Viewpoints, node types, hierarchy sets, and subscriptions.
• Integration with Oracle EPM applications.
• Troubleshooting validation and hierarchy issues.
• Business-facing communication and documentation.