Oracle EPM Data Integration Lead Consultant

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.