Our partner is looking for an Oracle EPM Data Integration Lead Consultant based in Canada. Join a technology consulting setting where innovation, collaboration, and digital transformation drive meaningful business outcomes. As an Oracle EPM Data Integration Lead Consultant, you will design, implement, and optimize end-to-end integrations between Oracle Enterprise Performance Management (EPM) Cloud applications and diverse enterprise systems. You will play a key role in ensuring accurate, secure, and automated data flows that support financial planning, consolidation, reconciliation, and performance management processes. Working closely with business stakeholders and technical teams, you will translate complex requirements into reliable integration solutions aligned with enterprise architecture standards. You will leverage Oracle EPM integration tools, APIs, scripting, and database technologies to improve data quality and operational efficiency. This remote opportunity offers challenging client engagements, continuous learning, and the chance to contribute to impactful enterprise technology initiatives. Integration Design and Implementation: Design, develop, deploy, and maintain end-to-end integrations between Oracle EPM Cloud applications and various source and target systems, ensuring reliable and scalable data exchange. Data Integration Management: Register source applications, configure integrations and mappings, export data to target systems or files, and automate data movement through integration pipelines. Data Mapping and Transformation: Define and maintain data mappings, transformation rules, and validation procedures to ensure accuracy, consistency, and integrity across connected systems. Monitoring and Troubleshooting: Monitor integration jobs, analyze execution logs,



identify data discrepancies, investigate failures, and implement timely corrective actions to maintain reliable operations. Stakeholder Collaboration: Work with business stakeholders, technical teams, and enterprise architects to gather requirements, define integration specifications, and ensure solutions align with business objectives and technical standards. Project Coordination: Proactively communicate project progress, dependencies, risks, blockers, and delivery updates to relevant stakeholders, supporting effective planning and execution. Technical Documentation: Develop and maintain integration design documents, configuration records, operational runbooks, and system administration guides to support knowledge transfer and ongoing maintenance. Testing and Quality Assurance: Support integration testing and user acceptance testing (UAT), validate data flows, and ensure solutions meet functional and technical requirements before deployment. Continuous Improvement: Identify opportunities to optimize integration architecture, improve automation, strengthen data quality, and enhance the performance and maintainability of Oracle EPM solutions. Bachelor's or master's degree in Computer Science, Information Systems, Software Engineering, or a related discipline, including B.
Professional

Experience:
At least 5 years of relevant experience working with Oracle EPM Cloud applications, data integration solutions,



and enterprise data management processes. Oracle EPM Expertise: Hands-on experience with Oracle EPM Cloud analytical applications such as Financial Consolidation and Close Cloud Service (FCCS), Enterprise Planning and Budgeting Cloud Service (EPBCS), Profitability and Cost Management Cloud Service (PCMCS), or Account Reconciliation Cloud Service (ARCS). Strong practical knowledge of Oracle EPM integration tools and frameworks, including Pipelines, Cloud Data Management (CDM), Data Exchange, FDMEE, EPM Integration Agent (EPMIA), and Oracle Data Integrator (ODI). Data Management

Skills:
Experience extracting, transforming, mapping, validating, and loading data across source and target systems, with a strong understanding of data quality and consistency. Database and SQL Proficiency: Experience with relational database management systems and strong SQL skills, including ANSI SQL, T-SQL, or Oracle SQL. Programming

Experience:
Working knowledge of Java, Groovy, or C# for developing and supporting integration components and custom solutions. Oracle Automation and APIs: Familiarity with Oracle EPM REST APIs, EPM Automate commands, and related data management capabilities, including CDM, FDM, or FDMEE. Experience with PowerShell, VBScript, Jython, Python, or Groovy is an advantage. Testing and Integration: Experience supporting system integration testing, user acceptance testing, and troubleshooting complex integration scenarios. Additional Technical Assets: Familiarity with Oracle Integration Cloud (OIC) and experience preparing detailed integration design documents and system administration guides are considered advantageous. Proficient English is required to collaborate daily

📌 Oracle EPM Data Integration Lead Consultant (Canada)
🏢 Jobgether
📍 Canada