Technical Integration Lead - Oracle Primavera Integrations and Data Migration

Technical Integration Lead – Oracle Primavera Integrations and Data Migration

U.S. Citizenship Required: This position supports projects with specific access and/or contractual requirements. As a result, U.S. citizenship is required for consideration for this role.

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 a Technical 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.

Disclaimer:

Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from: $87,000 to $187,000 per annum. May be eligible for bonus and equity.


Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:
1. Medical, dental, and vision insurance, including expert medical opinion
2. Short term disability and long term disability
3. Life insurance and AD&D
4. Supplemental life insurance (Employee/Spouse/Child)
5. Health care and dependent care Flexible Spending Accounts
6. Pre-tax commuter and parking benefits
7. 401(k) Savings and Investment Plan with company match
8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
9. 11 paid holidays
10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
11. Paid parental leave
12. Adoption assistance
13. Employee Stock Purchase Plan
14. Financial planning and group legal
15. Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
As part of Oracle's onboarding process and consistent with applicable law, US-based employees are required to complete identity verification, which involves the collection and processing of their biometric information. Accommodations to this requirement may be granted following an individualized assessment.

Key Responsibilities:

1. Engage with all customers, Oracle internal teams and Partners for delivery of bug free software.

2. Design, Develop and test the assigned solution/software framework.

3. Contribute to software code reusability and knowledge management

4. Effective communication and excellent demonstrable knowledge of Oracle Primavera products.

5. Take ownership of assigned projects and pre-sales opportunities and drive them to closure.

6. Refine and improve the blended delivery processes

7. Participate in Organizational initiatives related improvement of services from Oracle Construction and Engineering Global business unit.

8. Report and collaborate with all related stakeholders

9. Ability to work independently and with the team to ensure quality deliverables on the project

Job Skills:

1. Technical Competencies

• Work with customers to understand their integrations and data migration requirements and come up with an integrations/data migrations strategy
• Present integrations strategy to Oracle/customers management team
• Must have prior integrations experience using any one of the integrations middleware like MuleSoft, Dell Boomi, OIC and etc
• Must have strong PL SQL, Web/REST Services, SOAP UI, POSTMAN
• Expertise in Project Integrated Framework
• Hands on experience with Oracle Primavera product (P6, Unifier, Primavera Cloud, Gateway, Analytics, Aconex, OPPM)
• Strong PL SQL, Web/REST Services
• Expertise in Cloud infrastructure
• Expertise in Networking and security concepts
• Java or any programming background, 
• Oracle Database, Advance PLSQL 
• Expertise with Web services; SOAP and REST
• Working with APIs/Integrations 
• Hands on experience in integration development and data migrations