OIC - Oracle Integration Cloud & Primavera-Senior Technical Consultant

Senior Integration Developer (Oracle Integration Cloud & Primavera)

 Exp : 7+ years
Shift : 2pm- 10 pm

The Opportunity:
We are seeking a highly skilled and experienced Senior Integration Developer with a strong background in Oracle Integration Cloud (OIC) and deep expertise in Oracle Primavera software, primarily Primavera P6 Enterprise Project Portfolio Management (EPPM) and potentially other Primavera modules. This critical role involves designing, developing, and implementing robust integration solutions that connect our Primavera systems with other enterprise applications, ensuring the efficient and accurate flow of project-related data. You will play a key role in transforming our integration landscape to support effective project management, resource optimization, and operational reporting.

Key Responsibilities

• Own integration solution architecture and integration strategy for assigned programs/projects.
• Translate business/functional requirements into scalable integration designs: interface contracts, payload models, mappings, and non-functional requirements.
• Design and build OIC integrations (orchestrations, routing, transformations, enrichment, validations) using reusable components and standards.
• Implement secure connectivity and authentication: OAuth 2.0/2.1, Basic, certificates, keys, wallets; ensure compliance with enterprise security controls.
• Develop file-based integrations using SFTP/FTP, CSV/XML, and Oracle Fusion load patterns such as FBDI/BIP/UCM (as applicable).
• Define and implement robust operational patterns: error handling framework, exception routing, retries, replay/reprocessing, and idempotency.
• Drive testing strategy: unit tests, SIT coordination, test data strategy, defect triage and fixes, and UAT support.
• Own deployment and release management: versioning, packaging, environment promotion (DEV/SIT/UAT/PROD), and rollback readiness.
• Set up monitoring and operational readiness: integration tracking, alerts, dashboards, runbooks, and support handover/KT.
• Perform code reviews and enforce engineering standards for performance, resiliency, maintainability, and documentation.
• Mentor junior developers and lead technical discussions with stakeholders (business, functional, security, infra, and external vendors).

Must-Have Technical Skills

• Oracle Integration Cloud (OIC): connections, integrations, schedules, lookups, libraries, packages, monitoring and troubleshooting.
• Strong API engineering: REST/SOAP, JSON/XML, WSDL/OpenAPI familiarity, pagination, throttling, error semantics.
• Data transformation skills: mapping best practices, XSLT where needed, canonical model approach, and schema validation.
• File-based integration: SFTP polling patterns, large file handling, chunking/batching, and Fusion load patterns (FBDI/BIP/UCM where applicable).
• Security fundamentals: OAuth, JWT concepts, client credentials, mutual TLS/certificates, secrets handling, and least-privilege access.
• Operational excellence: logging, correlation IDs, retry strategy, dead-letter/error queues (conceptually), support runbooks.
• Good working knowledge of SQL for data verification, reconciliation, and troubleshooting.

What You Will Do:

• Design & Development: Lead the design, development, and implementation of complex integration solutions using Oracle Integration Cloud (OIC) for various enterprise applications, with a primary focus on Oracle Primavera applications (e.g., Primavera P6 EPPM, Primavera Unifier).
• Technical Expertise: Leverage your in-depth knowledge of OIC capabilities, including integrations, process automation (orchestrations), and visual builder to create efficient and scalable solutions.
• Primavera Integration: Work closely with Project Planning, Scheduling, Project Controls, and other functional teams to understand business requirements, identify integration points, and translate them into technical specifications for Primavera integrations. This includes orchestrating data flows for project schedules, activities, resources, roles, timesheets, costs, progress, and status updates between Primavera and systems like ERP, HR, or custom applications.
• API Development & Management: Develop, configure, and manage APIs within OIC for various integration patterns, specifically interacting with Primavera's official APIs (e.g., Primavera Web Services, Primavera API Gateway) and other source/target system APIs.
• Troubleshooting & Support: Provide expert-level support, troubleshoot complex integration issues related to Primavera data synchronization and transfers, and optimize existing integrations for performance and reliability.
• Best Practices: Advocate for and implement integration best practices, coding standards, and security guidelines within the OIC platform.
• Documentation: Create comprehensive technical design documents, mapping specifications, and support documentation for all integration solutions.
• Collaboration: Collaborate with cross-functional teams, including architects, functional consultants, business users, and other developers, to deliver integrated solutions.
• Mentorship: Mentor junior developers and contribute to the continuous improvement of our integration development processes.
• Stay Current: Keep abreast of the latest OIC features, Oracle Primavera updates, and industry integration trends in project management and enterprise solutions.

What You Bring:

• Experience: 7+ years of experience in enterprise application integration development, with at least 3-5 years specifically focused on Oracle Integration Cloud (OIC).
• Oracle Primavera Domain Expertise: Proven deep experience integrating with and understanding the data models, business processes, and functionalities of Oracle Primavera P6 EPPM. Experience with Primavera Unifier or other Primavera modules is a significant plus.
• OIC Proficiency: Hands-on experience with OIC components such as Integrations (App Driven, Scheduled, File-based), Process Automation, Visual Builder, and Adapters (e.g., REST Adapter, SOAP Adapter, FTP Adapter, Database Adapter).
• Technical Skills:
• Strong proficiency in XML, XSLT, JSON, and REST/SOAP web services.
• Experience with SQL and PL/SQL for data manipulation and validation, particularly with Oracle databases used by Primavera.
• Familiarity with security concepts in integrations (e.g., OAuth, Basic Authentication).
• Cloud Experience: Understanding of cloud-native concepts and experience working with cloud platforms (preferably Oracle Cloud Infrastructure).
• Problem-Solving: Excellent analytical and problem-solving skills with the ability to diagnose and resolve complex integration issues.
• Communication: Strong verbal and written communication skills to effectively interact with technical and non-technical stakeholders.
• Team Player: Ability to work independently and collaboratively in a fast-paced environment.
• Education: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

Bonus Points (Nice-to-Have):

• Oracle Clou