Oracle PaaS Integration Specialist

The Oracle PaaS Integration Specialist will be responsible for designing, developing, and maintaining integration solutions using Oracle Data Integrator (ODI) and Oracle Integration Cloud (OIC). The role requires deep technical expertise in Oracle SQL/PLSQL and experience with various Oracle PaaS (Platform as a Service) technologies.

Key Responsibilities:

• Design, develop, and implement integration solutions using Oracle Data Integrator (ODI) to support business applications and processes.
• Develop, maintain, and optimize Oracle SQL/PLSQL scripts for data integration and transformation tasks.
• Work with Oracle Integration Cloud (OIC) to design integration flows between Oracle and non-Oracle systems.
• Collaborate with business and IT stakeholders to understand requirements and translate them into effective integration solutions.
• Ensure best practices are followed for design, development, and deployment of integration solutions, with a focus on security, scalability, and performance.
• Troubleshoot and resolve integration issues across various Oracle PaaS solutions.
• Provide technical guidance and expertise to other teams involved in Oracle PaaS integration projects.
• Optional: Work with Visual Builder Cloud Service (VBCS) for low-code application development and integration purposes.
• Optional: Develop and manage reports using BIP/OTBI for enhanced reporting capabilities within the Oracle ecosystem.

Requirements

Mandatory:

• Oracle Data Integrator (ODI): Strong experience in ODI for data integration, ETL, and transformation tasks.
• Oracle SQL/PLSQL: Expertise in writing complex queries, stored procedures, triggers, and database performance optimization.
• Oracle Integration Cloud (OIC): Proficient in building and managing integrations between on-premise and cloud-based applications using OIC.

Good to Have:

• Visual Builder Cloud Service (VBCS): Experience with low-code application development and UI design.
• BI Publisher (BIP) / Oracle Transactional Business Intelligence (OTBI): Experience with developing reports and analytics using Oracle reporting tools.