Oracle EPM Data Integration Lead Consultant

Your role, your impact

As an Oracle EPM Data Integration Lead Consultant, you'll design, develop, and maintain integrations across various EPM Cloud applications and source systems. You'll focus on data exchange, automation, and ensuring seamless end-to-end data flows to support enterprise performance processes.

Leveraging your expertise in Oracle EPM integration and data exchange, you'll help clients streamline data flows, optimize integration processes, and ensure reliable, automated connections across source systems and EPM Cloud applications to support strategic business objectives. Join us and make a significant impact in transforming businesses through Oracle technologies.

Your day-to-day 

• Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and various source and target systems;

• Register source applications, build integrations with mappings, export data to target systems or files and facilitate automation via pipelines;

• Define and manage data mappings, transformations, and validations to ensure accurate and consistent data movement;

• Automate integration tasks using EPM Automate scripts, batch files, and REST APIs;

• Monitor integration jobs, analyze logs, and resolve errors or data issues promptly;

• Collaborate with business and technical teams to define integration specifications and ensure alignment with enterprise architecture standards;

• Proactively identify and communicate blockers, dependencies, risks, status updates, and other project-related information to stakeholders;

• Document integration designs, configurations, and runbooks to support operational transparency.

Keys to your success

• B.Tech, BE, M.Tech, or MCA in Computer Science, Information Systems, or Software Engineering;

• 5+ years of experience with the following:

  • Oracle EPM Cloud Analytical products such as FCCS, EPBCS, PCMCS, or ARCS;

  • Integration products, including Pipelines, Cloud Data Management (CDM /Data Exchange), FDMEE, EPM Integration Agent (EPMIA), and ODI;

  • Data wrangling, mapping, and transforming data from source to target systems;

  • Working with relational database management systems, with proficiency in ANSI SQL, T-SQL, or Oracle SQL.

• Experience with Java, Groovy, or C# development;

• Working knowledge of Oracle EPM REST APIs and EPM Automate commands, as well as CDM, FDM or FDMEE.

Extra edge 

• Experience with PowerShell, VBScript, Jython, Python, or Groovy scripting;

• Experience system integration testing and user acceptance testing (UAT);

• Experience with Oracle Integration Cloud (OIC);

• Experience authoring integration detailed design documents and system administration guides.

Language skills 

• English: Proficient 

• French: Intermediate

 Please note that due to the nature of the responsibilities of the position, a proficient level of English is required, in particular to communicate daily with employees and managers outside of Quebec.