Oracle EPM Integration Specialist

Oracle EPM Integration Specialist

Job Type:  Full Time Employee, Contract or Contract to Hire

Timings: 2pm to 11pm shift

Must Have/ Required Skillset:

•  Hands-on experience of minimum 10+ years in developing inbound and outbound integrations from various source systems (e.g.Oracle EBS, PeopleSoft, Oracle Cloud, Essbase)
• Hands-on experience of 5+ years with metadata integration technologies, including EPM Automate
• Hands-on experience of minimum of 7+ years' experience with Oracle EPM Cloud Data Management, and FDM, and/or FDMEE design and build with Oracle Financial Close and Consolidation, Reconciliations, HFM, and/or Planning as the target including:
  • Data load locations
  • Import formats
  • Target and source application setup
  • Period mappings
  • Category mappings
  • Data load rules
  • Data load mappings
  • Metadata validation rules
  • Data load automation
  • Batch scheduler / open batch
  • FDMEE Scripting (Jython/VBScript/SQL)
  • ODI
• Experience with Oracle EPM Integration Agent is a plus.

Key Responsibilities

• Collaborate with clients to gather and understand integration requirements.
• Assess existing systems and processes to identify integration opportunities.
• Provide advice and guidance to clients on EPM Cloud integration best practices.
• Design and architect integration solutions that align with client business goals.
• Create integration specs and documentation for client approval.
• Collaborate with the team to ensure integration designs meet client expectations.
• Develop integrations using Oracle EPM Cloud data management.
• Write custom code, scripts, connectors using Java and Python as necessary.
• Conduct thorough testing and validating of integrations.
• Monitor, troubleshoot and resolve integration issues in a timely manner.
• Maintain and enhance existing integrations.
• Provide post implementation support and training to clients.
• Maintain documentation of integration designs, configurations, and procedures.
• Prepare and deliver regular status reports to the client and project teams.

Education: Graduate or Equivalent degree