Senior Oracle ERP/EPM Integration Consultant

Role & responsibilities

• Design, develop, integrate, and support Oracle ERP/EPM solutions across Oracle EBS and Oracle Cloud environments.
• Develop and maintain Oracle integrations using Oracle Integration Cloud (OIC), BICC, REST APIs, HTTP requests, and related integration technologies.
• Build and support data integration and ETL pipelines using Oracle Data Integrator (ODI) 12c, Informatica PowerCenter, and other enterprise data integration tools.
• Develop and optimize Oracle database solutions, including SQL, PL/SQL, T-SQL, stored procedures, packages, functions, and complex queries.
• Work with Oracle Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), Oracle Database 12c, SQL Server, and Snowflake for data processing and analytics.
• Develop and support Oracle BI and analytics solutions, including Oracle BI Apps, Oracle Analytics Cloud (OAC), OTBI, and related reporting platforms.
• Support Oracle ERP Financials, Oracle Fusion, Oracle EBS, Oracle SaaS, Oracle EPM, and Oracle OTM applications and integrations.
• Develop, enhance, and troubleshoot Oracle APEX applications and supporting database components.
• Design and implement cloud-based solutions leveraging OCI and Oracle Cloud services.
• Develop and maintain data extraction, transformation, loading, reporting, and analytics solutions across Oracle and non-Oracle platforms.
• Develop and consume REST-based integrations, troubleshoot HTTP/API issues, and perform API testing using tools such as Postman and SoapUI.
• Automate Oracle EPM processes using EPM Automate and scripting technologies.
• Develop supporting utilities, automation, and integration components using Java, Python, JavaScript, TypeScript, Shell Scripting, and other relevant technologies.
• Work with web technologies including HTML, CSS, Bootstrap, jQuery, and ASP.NET where required for application and integration solutions.
• Develop, maintain, and troubleshoot Crystal Reports and other enterprise reporting solutions.
• Perform production support, incident resolution, root-cause analysis, performance tuning, and issue troubleshooting across Oracle ERP/EPM and integration environments.
• Collaborate with business users, technical teams, architects, and other stakeholders to gather requirements, translate business needs into technical solutions, and deliver projects independently.
• Maintain technical documentation, integration specifications, data mappings, deployment procedures, and support documentation.
• Use development and administration tools such as GitHub, VS Code, Eclipse, NetBeans, SQL Developer, Toad, and WinSCP as appropriate.
• Follow enterprise SDLC, development, testing, deployment, security, and production-support standards

Preferred candidate profile

• Senior-level Oracle ERP/EPM technical consultant with strong hands-on experience across Oracle EBS and Oracle Cloud environments.
• Strong experience designing and implementing Oracle integrations, preferably using OIC, BICC, REST APIs, and Oracle integration technologies.
• Hands-on expertise with Oracle Data Integrator (ODI) 12c and/or Informatica PowerCenter for enterprise ETL and data integration.
• Strong knowledge of Oracle ERP Financials, Oracle Fusion, Oracle EBS, Oracle SaaS, Oracle EPM, and Oracle OTM.
• Strong database development experience with Oracle 12c, PL/SQL, SQL Server, T-SQL, Snowflake, ADW, and ATP.
• Experience with Oracle BI Apps, OTBI, OAC, and enterprise analytics/reporting solutions.
• Experience working with OCI and Oracle Cloud services, with the ability to support cloud-based enterprise applications and integrations.
• Hands-on experience with Oracle APEX and/or other Oracle application development technologies.
• Strong programming/scripting capabilities in one or more of Java, Python, JavaScript, TypeScript, and Shell Scripting.
• Good understanding of REST APIs, HTTP protocols, API integration, Regex, Postman, and SoapUI.
• Experience with EPM Automate and Oracle EPM process automation is preferred.
• Exposure to Crystal Reports and enterprise reporting environments.
• Strong troubleshooting, debugging, performance-tuning, and production-support capabilities.
• Comfortable working independently in a hands-on technical consultant role while also communicating effectively with business and technical stakeholders.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into scalable technical solutions.
• Experience working in enterprise SDLC environments with GitHub and modern development tools.
• Ability to work across development, integration, data, analytics, cloud, and production support functions.
• Strong communication, stakeholder-management, documentation, and collaboration skills.
• Experience working in ERP/EPM, finance, enterprise applications, or other complex business-critical environments would be highly desirable.