This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Oracle EPM Data Integration Lead Consultant based in Canada.

Overview

Join a technology consulting environment 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.

Accountabilities

- 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.
- Automation and Scripting: Automate integration workflows using EPM Automate, batch files, REST APIs, and relevant scripting technologies to streamline recurring processes and minimize manual intervention.
- 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.

Requirements

- Education: Bachelor's or master's degree in Computer Science, Information Systems, Software Engineering, or a related discipline, including B.Tech, BE, M.Tech, or MCA qualifications.
- 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).
- Integration Technologies: Solid 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 supportin

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