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.
- 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.
Top Skills
What We Do
Unison Consulting was launched in Singapore on September 2012, the hub of the financial industry, with innovative visions in the technocratic arena. We are a boutique next-generation Technology Company with strong business-interests in Liquidity risk, Market Risk, Credit Risk and Regulatory Compliance.
Unison provides technology consulting and services to implement Risk Management and Risk Analytics System for Financial Institutions. Our services suite comprises of Techno-Functional consulting, systems integration, Business Intelligence, information management, and custom development of IT solutions, plus project management expertise for financial institutions.
We have expertise in latest cutting edge technology to achieve better total cost of ownership. Through our qualified professionals, we assist you drive your unique risk management strategies, whether that means efficient monitoring, improving risk appetite of the financial institutions, complying with regulations, or capturing growth opportunities through innovation, this is what maximizes your decision taking potential. At Unison Consulting, we view clients as partners, and our success is only measured by the success of our partners. So we put it all on the table in order to exceed expectations.
Our staff consists of young, energetic and innovative consultants who are never afraid to challenge the conventions and push the boundaries in an effort to help our clients. For every project, no matter how large or how small, we strive to not only meet your needs, but deliver a showcase in your field
