Lead Consultant, Oracle EPM Data Integration

This is a fully remote position, open to applicants in Canada.

📋 Description

• Develop, implement, and oversee comprehensive integrations between Oracle EPM Cloud applications and both source and target systems.

• Register source applications, create integrations with mappings, export data to target systems or files, and enable automation through pipelines.

• Establish and manage data mappings, transformations, and validations to ensure accurate and consistent data transfer.

• Automate integration tasks utilizing EPM Automate scripts, batch files, and REST APIs.

• Monitor integration jobs, review logs, and quickly address any errors or data-related issues.

• Collaborate with both business and technical teams to outline integration specifications and ensure compliance with enterprise architecture standards.

• Communicate any blockers, dependencies, risks, status updates, and other project-related information to stakeholders.

• Document integration designs, configurations, and runbooks to promote operational clarity.

⛳️ Requirements

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

• Over 5 years of experience with Oracle EPM Cloud Analytical products such as FCCS, EPBCS, PCMCS, or ARCS.

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

• Experience in data wrangling, mapping, and transforming data between source and target systems.

• Proficiency with relational database management systems and expertise in ANSI SQL, T-SQL, or Oracle SQL.

• Experience in Java, Groovy, or C# development.

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

• Proficient in English.

• Intermediate proficiency in French.

• Experience with scripting languages such as PowerShell, VBScript, Jython, Python, or Groovy.

• Familiarity with system integration testing and user acceptance testing (UAT).

• Experience with Oracle Integration Cloud (OIC).

• Proven ability to author detailed design documents for integration and system administration guides.

🏝️ Benefits

• Flexible work options.

• Unlimited Vacation Plan.

• 24/7 virtual healthcare.

• Wellness portal offering tools and resources for physical, mental, emotional, and financial well-being.

• Access to thousands of online courses and certifications.

• Exclusive leadership programs.

• Tuition reimbursement program for external training.

• Employee Share Purchase Plan featuring matched contributions.