: Oracle Technical Consultant (OIC & BIP)Location: Pune

Experience: 5+ years

Interview Mode: Face-to-Face (F2F)

Interview Date: 24 October

Work Arrangement: Offshore

Role OverviewWe are looking for an experienced Oracle Technical Consultant with strong hands-on expertise in Oracle Integration Cloud (OIC) and BI Publisher (BIP) for Oracle ERP Cloud. The ideal candidate should have experience developing complex integrations, outbound reporting solutions, and bank payment-related reports, along with expertise in performance optimization and reusable integration frameworks.

Key Responsibilities

- Design, develop, test, deploy, and support OIC integrations for Oracle ERP Cloud.
- Develop and maintain complex BI Publisher reports using RTF, Excel, and other output formats.
- Build outbound integrations and reporting solutions, including bank payment and payment-related reports.
- Design and implement scalable, reusable OIC integration frameworks.
- Troubleshoot and optimize OIC integrations and BIP reports across environments.
- Improve BIP performance by optimizing SQL queries, data models, and report templates.
- Work with REST/SOAP APIs, XML, SQL, and Oracle ERP Cloud interfaces.
- Support technical design, System Integration Testing (SIT), User Acceptance Testing (UAT), deployments, and production issue resolution.




- Explain technical architecture, design decisions, implementation approaches, and troubleshooting solutions.
- Follow Oracle development standards, best practices, and reusable design patterns.

Required Skills and Qualifications
- Minimum 5 years of Oracle technical development experience.
- Strong hands-on experience with Oracle Integration Cloud (OIC) and BI Publisher (BIP).
- Expertise in BIP RTF and Excel reports, including performance optimization.
- Experience developing complex outbound integrations and reporting solutions.
- Mandatory: Experience with bank payment or payment-related reporting.
- Strong knowledge of scalable and reusable OIC integration frameworks.
- Proficiency in REST/SOAP APIs, XML, SQL, and Oracle ERP Cloud.
- Strong technical troubleshooting, problem-solving, and solution design skills.
- Experience with Oracle ERP Cloud integration and technical development practices.

Positive to Have
- Oracle Cloud technical certification.
- Experience with OTBI and Oracle Visual Builder.
- Knowledge of Oracle ERP Cloud Financials and payment processes.
- Exposure to enterprise integration architecture and reusable frameworks.

Interview Process
- Face-to-face interview.

📌 Oracle Technical Consultant (OIC & BIP) (Pune)
🏢 Helios Systems Asia
📍 Pune