OIC Solution Architect

Job Summary:

As a Principal Integrations Solution Architect, you will lead the design and implementation of complex integration solutions across cloud and on-premises enterprise systems. Leveraging Oracle Integration Cloud (OIC), OCI, SOA, and API-based technologies, you will translate complex business requirements into scalable, secure, and high-performing architectures. Strong expertise in PL/SQL, database technologies, and SCM is required. This role is ideal for technical leaders passionate about technology, innovation, and architectural excellence.

Key Responsibilities :

Lead the architecture, design, and delivery of integration solutions using OIC, OCI, SOA, and related tools for SaaS and on-premises systems.

Design and optimize PL/SQL and database workflows to ensure efficient, secure, and high-performing data processing.

Collaborate with business and technical stakeholders to define integration strategies and scalable architectures.

Implement and govern RESTful and SOAP-based services to connect diverse applications.

Apply integration design patterns, error handling, and security best practices across solutions.

Troubleshoot, analyze, and resolve complex integration issues and technical challenges.

Provide technical leadership, mentoring, and guidance to development teams.

Identify opportunities for process automation, efficiency, and continuous improvement.

Qualifications & Skills

Mandatory:

Strong hands-on experience with Oracle Integration Cloud (OIC), SOA, VBCS, and API-based integration solutions.

Proficiency in PL/SQL, with the ability to write efficient queries, stored procedures, and performance-tuned database code.

Experience working with RESTful and SOAP-based web services.

Familiarity with SaaS and on-premises application software.

Solid understanding of integration design patterns, error handling, and security best practices.

Strong analytical and debugging skills.

Comfortable working in a collaborative, fast-paced environment.

Good-to-Have:

Knowledge of Supply Chain (SCM) processes or systems.

Experience with Oracle ERP Cloud or other enterprise applications.

Exposure to VBCS and advanced API management tools.

Self-Assessment Questions

Do I have hands-on experience designing and implementing integrations with OIC, SOA, and API-based solutions?

Can I efficiently develop, optimize, and troubleshoot PL/SQL for complex integration scenarios?

Am I comfortable working with SaaS and on-premises environments, including RESTful and SOAP-based integrations?

Do I have a strong understanding of integration design patterns, error handling, and security best practices?

Can I effectively communicate technical concepts and collaborate in a fast-paced, dynamic team?