Data Migration Consultant

Job Summary
We are seeking an experienced Data Migration Consultant with expertise in Oracle Primavera P6, Primavera Integration Framework (PIF), and Oracle Unifier. The ideal candidate will be responsible for planning, designing, and executing data migration activities during Oracle Primavera and Unifier implementation or upgrade projects. This role requires strong technical knowledge of migration strategies, ETL processes, data validation, and Oracle databases.
 
Key Responsibilities
Plan, design, and execute end-to-end data migration activities for Oracle Primavera P6 and Oracle Unifier implementations.
Analyze legacy systems and map data to Oracle Unifier and Primavera P6 data models.
Develop and execute migration strategies using Primavera Integration Framework (PIF), Oracle tools, SQL, and ETL technologies.
Extract, transform, cleanse, validate, and load project, cost, schedule, contract, document, and workflow data into Oracle Unifier.
Configure and utilize Primavera Integration Framework (PIF) for system integrations and automated data migration.
Develop SQL scripts, PL/SQL procedures, and migration utilities to support data conversion.
Perform data quality assessments and reconciliation to ensure migration accuracy and completeness.
Troubleshoot migration issues and resolve data inconsistencies.
Collaborate with business users, project managers, functional consultants, and technical teams to gather migration requirements.
Support User Acceptance Testing (UAT), system integration testing, and post-go-live validation.
Create migration documentation, mapping documents, technical specifications, and runbooks.
Ensure compliance with organizational security, governance, and data management standards.
 
Required Qualifications
Bachelor''s degree in Computer Science, Information Technology, Engineering, or a related field.
5+ years of experience in Oracle Primavera P6 and Oracle Unifier implementations or support.
Hands-on experience with Primavera Integration Framework (PIF).
Strong experience in enterprise data migration and system integration projects.
Advanced knowledge of Oracle Database, SQL, and PL/SQL.
Experience with ETL tools and data transformation methodologies.
Strong understanding of Primavera P6 scheduling concepts and Oracle Unifier business processes.
Experience in data mapping, cleansing, reconciliation, and validation.
Excellent analytical, problem-solving, and communication skills.
 
Preferred Skills
Experience with Oracle Primavera Cloud (OPC) migrations.
Knowledge of Oracle Integration Cloud (OIC) and REST/SOA integrations.
Experience integrating Oracle ERP, Oracle E-Business Suite, Oracle Fusion ERP, or SAP with Oracle Unifier.
Familiarity with XML, JSON, Web Services, APIs, and middleware technologies.
Experience working in Engineering, Construction, Infrastructure, Utilities, or Capital Projects environments.
Oracle Primavera and Oracle Unifier certifications are preferred.
 
Technical Skills
Oracle Primavera P6
Oracle Unifier
Primavera Integration Framework (PIF)
Oracle Database
SQL / PL/SQL
ETL Tools
Oracle Integration Cloud (OIC)
REST APIs
XML / JSON
Data Mapping & Data Validation
Data Reconciliation
Performance Tuning
System Integration
Microsoft Excel
 
Nice to Have
Oracle Primavera Cloud (OPC)
Oracle Fusion Applications
Oracle E-Business Suite
SAP Integration
Python or Shell Scripting
Agile/Scrum methodology
 
Soft Skills
Strong communication and stakeholder management.
Excellent analytical and troubleshooting abilities.
Ability to work independently and in cross-functional teams.
Strong documentation and presentation skills.
Effective time management and multitasking capabilities.