Lead Consultant, OIC Integration

Alithya

Lead Consultant optimizing Oracle Cloud ERP and integration solutions for North American clients. Leverage Oracle technologies to support and enhance critical business applications in managed services environments.

Posted 5/9/2026full-time🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies

CloudERPETLGroovyJavaOracleSDLCSOAPSQL

About the role

Key responsibilities & impact

Develop, troubleshoot, and maintain Oracle Integration Cloud (OIC) solutions for Oracle Fusion ERP, SCM, HCM, and EPM applications;
Design and develop integrations between Oracle Cloud Applications and third-party systems using REST and SOAP web services;
Develop and maintain OTBI reports, BI Publisher (BIP) reports, and RTF templates;
Work on RICEW objects, technical extensions, workflows, and reporting solutions across Oracle Cloud environments;
Support data loading and migration activities using FBDI and HDL tools;
Provide post-production support for live Oracle Cloud clients, including break-fixes, enhancements, and integration maintenance;
Participate in the full software development lifecycle, from requirements analysis through testing, deployment, and ongoing support;
Create and maintain technical design documents and development documentation;
Participate in technical workshops and client discussions for new and existing solutions;
Mentor and guide offshore technical team members while promoting development best practices and code quality standards;
Support mini-projects, new integrations, remote implementations and Oracle Cloud footprint expansion initiatives.

Requirements

What you’ll need

Minimum 5 years of experience with SQL, PL/SQL, OTBI, BIP, RTF templates, FBDI, HDL, and workflow tools;
Strong hands-on experience with Oracle Integration Cloud (OIC), OTBI, and BI Publisher (BIP);
Strong experience working with Oracle Fusion ERP, SCM, HCM, and EPM products;
Minimum 3 years of experience designing and developing integrations between Oracle Cloud Applications and third-party systems using REST and SOAP APIs;
Strong understanding of Oracle Cloud REST and SOAP services and ETL-based integrations;
Knowledge of Oracle technologies including Java, XML, JDeveloper, VBCS, Groovy Scripting, and Oracle Cloud frameworks;
Understanding of Oracle Fusion Security Framework;
Strong understanding of SDLC processes and integration best practices;
Strong analytical, troubleshooting, and problem-solving skills;
Excellent verbal and written communication skills.

Benefits

Comp & perks

An inclusive path to success: Fostering an environment where you can thrive starts with ensuring an accessible recruitment process.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPL/SQLOTBIBI PublisherRTF templatesFBDIHDLREST APIsSOAP APIsJava

Soft Skills

analytical skillstroubleshooting skillsproblem-solving skillsverbal communicationwritten communicationmentoringguidancecollaborationclient discussionsdevelopment best practices