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.

- Solid 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.

- Robust 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.

📌 Senior Oracle ERP/EPM Integration Consultant (Bengaluru)
🏢 CGI
📍 Bengaluru