Technical Integration Lead – Oracle Primavera Integrations and Data Migration

Oracle Corporation; United States; On-site; USD 120,000 - 170,000; Full time

Job summary

Oracle Corporation is seeking a Technical Integration Lead for Oracle Primavera Integrations and Data Migration within CEGBU. You will design and develop REST API integrations and data migrations using OIC or PIF, guiding implementation from requirements to production deployment.

This is a client-facing, hands-on leadership role requiring deep technical delivery experience, strong problem-solving, and the ability to translate business needs into robust integration solutions.

Qualifications

• Bachelor's degree required in CS/IT or related field.
• 10+ years of technical delivery and client-facing experience.
• Hands-on REST API integration and data migration experience.
• Experience with enterprise integration tools or middleware.
• Strong REST, JSON/XML, authentication and error handling knowledge.

Responsibilities

• Lead client workshops to gather integration requirements.
• Translate requirements into technical specifications and data mappings.
• Design integration and data migration solutions for Primavera and external systems.
• Personally build and configure integrations in OIC or PIF using REST calls.
• Develop migration processes including extraction, transformation, loading, validation.
• Create unit tests and support UAT, deployment and post-deployment support.

Skills

REST API development

Middleware platforms

API troubleshooting

Client-facing delivery

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

Oracle Integration Cloud (OIC)

Project Integration Framework (PIF)

Job description

Technical Integration Lead - Oracle Primavera Integrations and Data Migration

About the Role

Oracle's Construction and Engineering Global Business Unit (CEGBU) provides enterprise project and portfolio management solutions, including Primavera Unifier, P6 EPPM, Oracle Primavera Cloud, and Aconex.

We are seeking aTechnical Integration Lead with proven, hands-on experience designing and developing integrations and data migrations using REST APIs through integration tools or middleware such as Oracle Integration Cloud (OIC) or Project Integration Framework (PIF).

This role combines client-facing technical leadership with direct development responsibility. You will own delivery from requirements gathering and data mapping through solution design, development, unit testing, UAT support, and production deployment.

Direct integration development experience is essential. Experience limited to functional consulting, project coordination, or QA/testing on integration projects does not meet this requirement. Prior Oracle Primavera integration experience is an added advantage, but is not required.

Key Responsibilities

• Lead client workshops to gather, clarify, and document integration and data migration requirements.
• Translate business requirements into technical specifications, source-to-target data mappings, transformation rules, and validation criteria.
• Assess and establish source and target system connectivity, including API access, authentication, authorization, and connectivity troubleshooting.
• Design integration and data migration solutions for Oracle Primavera applications and external enterprise systems.
• Personally build and configure integrations and migration workflows in OIC or PIF using REST API calls, including request and response handling, data transformations, orchestration, and error handling.
• Develop migration processes covering data extraction, transformation, loading, validation, and reconciliation.
• Create and execute unit tests, troubleshoot defects, and verify data accuracy and integration behavior.
• Support system integration testing and client UAT, including issue analysis and resolution.
• Prepare deployment plans, support migration cutover activities, and deploy solutions to production.
• Provide post-deployment support, technical documentation, and knowledge transfer.
• Lead technical discussions, review development work, and guide team members while remaining actively involved in implementation.

Required Qualifications and Experience

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 10+ years of relevant technical delivery, software development, or consulting experience, including client-facing responsibilities.
• 10+ years of integration architecture and development experience using enterprise integration tools or middleware.
• Demonstrated hands-on experience personally developing and delivering REST API integrations and data migrations through middleware such as OIC, or PIF
• Strong practical knowledge of REST APIs, HTTP methods and status codes, JSON/XML payloads, authentication, pagination, and API troubleshooting.
• Experience implementing data mappings, transformations, orchestration, logging, error handling, retry mechanisms, and reconciliation.
• Experience delivering solutions across the full lifecycle: requirements gathering, technical design, development, unit testing, UAT support, and production deployment.
• Ability to independently translate client requirements into implementable technical solutions and resolve development and connectivity issues.
• Strong communication, technical documentation, stakeholder management, and coaching skills.

Candidates must be able to explain integrations they personally developed, including the middleware used, REST API interactions, data mappings, technical challenges, and deployment approach.

Preferred Qualifications

• Hands-on development experience with OIC or PIF.
• Experience leading technical delivery for enterprise integration and data migration projects.
• Good to have: Experience integrating or migrating data for Primavera Unifier, P6 EPPM, Oracle Primavera Cloud, or Aconex.
• Good to have:Experience integrating Oracle applications with external enterprise systems such as SAP or Oracle E-Business Suite.

Oracle Primavera product or integration experience is preferred, not required. Candidates with strong hands-on middleware and REST API development experience in other enterprise application environments are encouraged to apply.