Job Summary
We are looking for an experienced Oracle EDMCS Techno-Functional Consultant with 5+ years of relevant experience in Oracle EPM technologies, enterprise data management, and master data governance. The candidate will be responsible for understanding business requirements, designing and implementing EDMCS solutions, managing metadata and hierarchies, configuring applications, and supporting integrations with Oracle EPM and other enterprise systems.
Key Responsibilities
- Gather and analyze business requirements related to enterprise data management, master data, and metadata governance.
- Design, configure, and maintain Oracle EDMCS applications, viewpoints, dimensions, node types, properties, and hierarchies.
- Develop and manage application registrations, viewpoints, subscriptions, imports, exports, and data transformation processes.
- Configure validation rules, node-level validations, properties, and workflow policies to ensure data quality and consistency.
- Manage change requests, approvals, data governance workflows, and metadata lifecycle processes.
- Integrate EDMCS with Oracle EPM applications such as Planning, Financial Consolidation and Close (FCCS), and other downstream systems.
- Work with metadata files, flat files, extracts, and REST APIs to facilitate data imports, exports, and integrations.
- Perform impact analysis, data mapping, reconciliation, and troubleshooting of metadata and hierarchy-related issues.
- Collaborate with finance, business, and technical teams to translate functional requirements into technical solutions.
- Prepare functional specifications, technical design documents, configuration documents, and test scenarios.
- Support unit testing, system integration testing (SIT), user acceptance testing (UAT), deployment, and production support.
- Troubleshoot application issues and implement enhancements, process improvements, and best practices.
- Support data governance initiatives and ensure compliance with enterprise data standards.
Required Skills and Qualifications
- 5+ years of experience in Oracle EPM Cloud and/or enterprise performance management solutions, with relevant experience in EDMCS.
- Strong understanding of Oracle Enterprise Data Management Cloud Service (EDMCS) concepts and functionalities.
- Hands-on experience in configuring EDMCS applications, dimensions, viewpoints, node types, properties, and hierarchies.
- Knowledge of metadata management, master data management, data governance, and hierarchy maintenance.
- Experience with data imports, exports, extracts, subscriptions, and application registrations.
- Understanding of integration between EDMCS and Oracle EPM Cloud applications.
- Knowledge of REST APIs, JSON, CSV, and flat-file processing for integrations and automation.
- Familiarity with Oracle EPM security, access controls, workflow approvals, and validation rules.
- Strong analytical, problem-solving, communication, and stakeholder-management skills.
- Ability to work independently and collaborate effectively with functional and technical teams.
Education
Bachelor’s degree in Computer Science, Information Technology, Finance, or a related discipline.
