- Design, develop, and maintain integration solutions using Oracle Data Integration (ODI) and Oracle Integration Cloud (OIC).
- Create data mappings, transformations, and workflows to facilitate data movement between systems.
- Write and optimize complex SQL and PL/SQL scripts for data extraction, transformation, and loading (ETL) processes.
- Ensure data integrity and quality through robust validation and error handling mechanisms.
- Collaborate with cross-functional teams to integrate various applications and services using OIC.
- Implement APIs and web services to support data exchange and business processes.
- Develop and maintain BI Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI) reports to provide actionable insights.
- Assist in the design and generation of analytical reports to support decision-making.
- Monitor and troubleshoot integration processes and database performance, applying optimizations as needed.
- Conduct regular assessments and make recommendations for improvements in integration architecture.
- Document integration processes, data flows, and technical specifications.
- Provide training and support to team members and end-users on integration tools and best practices.
Requirements
- 5+ years of experience in Oracle integratio technologies, with a strong focus on ODI and OIC.
- Proficiency in Oracle SQL and PL/SQL is mandatory.
- Experience with VBCS (Visual Builder Cloud Service) is a plus.
- Familiarity with BI Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI) reporting tools is advantage.