Oracle EPM Specialist - IT Architect

Overview

Oracle EPM Specialist (IT Architect III) to support, develop and optimize EPBCS planning, budgeting, forecasting and reporting solutions, acting as the primary functional and technical resource for EPBCS.

What you'll do

• Gather business requirements and translate them into functional designs, technical specifications and EPBCS solutions.
• Configure and maintain planning applications, dimensions, hierarchies, forms, dashboards, navigation flows, task lists and approval workflows.
• Develop and optimize business rules, calculation scripts, member formulas and allocation logic using Calculation Manager and, where applicable, Groovy.
• Support planning models across scenarios, versions, entities, currencies and business units.
• Enhance budgeting, forecasting, long-range planning and management reporting processes.
• Configure and support relevant EPBCS frameworks such as Financials and Workforce based on business requirements.
• Configure, administer and monitor Data Integration/Data Exchange processes, data mappings, pipelines and import/export definitions.
• Manage actuals, budget, forecast and metadata integrations between EPBCS and source systems.
• Validate and reconcile financial data to ensure completeness, accuracy and consistency.
• Collaborate with upstream and downstream system owners to assess dependencies and resolve integration issues.
• Automate routine data loads, metadata updates and application processes using EPM Automate, REST APIs or scripting.
• Provide functional and technical support during budgeting, forecasting, financial close and reporting cycles.
• Investigate and resolve data load failures, mapping errors, calculation issues, validation failures and performance problems.
• Support users with forms, dashboards, approvals, reporting and Smart View queries.
• Perform root cause analysis, implement preventive fixes and manage Oracle Service Requests through resolution.
• Monitor scheduled jobs, business rules, integrations and application performance.
• Administer user access, predefined roles, application permissions and dimension-level security.
• Review monthly Oracle EPM release notes, assess impacts and coordinate regression testing.
• Manage controlled migration of application changes across development, test and production environments.
• Maintain application backups, configuration documentation, support runbooks and operating procedures.
• Follow change management processes and support audit and internal control requirements.
• Partner with Finance and IT teams to improve planning processes, application usability and operational efficiency.
• Assess the downstream impact of application and integration changes.
• Lead knowledge transfer from implementation partners and establish sustainable application support practices.
• Work with Financial Systems leadership to prioritize enhancements and deliver EPM roadmap initiatives.

What you'll need

• Strong hands-on experience implementing, developing or supporting Oracle EPBCS/EPM Planning applications.
• Understanding of financial planning, budgeting, forecasting, management reporting and financial close dependencies.
• Experience with dimensions, forms, dashboards, approval workflows, business rules, calculation scripts and Smart View.
• Strong knowledge of Essbase concepts, multidimensional modeling and calculation performance optimization.
• Experience with Data Integration/Data Exchange, data mappings, metadata management and financial data reconciliation.
• Experience managing application security, migrations, monthly update testing and production support.
• Strong analytical, troubleshooting, documentation and stakeholder communication skills.
• Ability to translate Finance requirements into practical, maintainable technical solutions.

Nice to have

• Experience with Groovy, EPM Automate, REST APIs and scripting.
• Experience with EPBCS Financials and Workforce.
• Exposure to Oracle ERP or other financial source-system integrations.
• Familiarity with PCMCS and EDMCS.
• Exposure to PCMCS and EDMCS is desirable as a secondary area of responsibility, including limited support for PCMCS allocation models and profitability processes and EDMCS metadata updates, hierarchy maintenance and subscriptions.

Details

• Location: Bangalore, India.
• Work schedule: Standard, Monday to Friday.
• Environmental conditions: Office.