INTERNAL Oracle Technical Consultant (Reporting, Integration, ERP)

Design, develop, and maintain cloud-to-cloud and cloud-to-on-premise integrations using Oracle Integration Cloud, including scalable interfaces with REST/SOAP APIs and data load tools.

Design and maintain operational reports and data models using BI Publisher, OTBI, and Financial Reporting Studio; develop and optimize complex SQL and PL/SQL queries.

Translate functional specs into detailed technical designs, assist with Oracle Cloud release patch analysis, and provide production support troubleshooting and SLA-driven issue resolution.

4–7+ years of hands-on experience as an Oracle Technical Consultant, with at least 2 full-lifecycle Oracle Cloud ERP implementations.

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or equivalent practical experience.

Technical proficiency required in Oracle Cloud ERP data models (Financials, Procurement, SCM), Oracle Integration Cloud (OIC), SOA Suite, web services protocols (REST, SOAP), and SQL/PLSQL reporting tools such as BI Publisher and OTBI.

Work Experience Required: 4–7+ years; Notice Period: Not explicitly mentioned in the JD.

Experienced consultant with deep technical expertise in Oracle Cloud ERP integrations and reporting solutions focused on Financials, Procurement, and SCM domains.

Comfortable with translating functional requirements into Low-Level Technical Design and handling technical delivery support including regression testing and troubleshooting.

Strong technical acumen in Oracle Integration Cloud, REST/SOAP API development, data migration tools (FBDI, ADFdi), and advanced Oracle reporting frameworks.