Job Role: Oracle Agile PLM Data Migration Expert/Agile PLM Data Migration Expert
Location: Austin, Texas (Onsite)
Contract
Our client is looking for an experienced Oracle Agile PLM Data Migration Expert to support the migration of product lifecycle data from legacy Agile PLM to a next-generation PLM platform.
Required Skills
- Hands-on Oracle Agile PLM experience.
- Data migration and extraction expertise.
- Strong SQL and PL/SQL programming skills.
- Agile PLM schema analysis and revision-based extraction.
- Data quality validation and reconciliation.
- Understanding of Bills of Materials (BOM), Approved Manufacturer Lists (AML) and FileVault structures.
Key Responsibilities
- Extract complete revision history, including historical versions.
- Extract attachments and preserve file paths, metadata, and document associations.
- Perform data profiling, completeness checks, referential integrity validation, and error resolution.
- Optimize queries, indexes, and batch processes for high-volume extraction.
- Prepare structured data for downstream transformation, mapping, and cloud ingestion.
- Support mock migrations, dry runs, User Acceptance Testing (UAT), and migration troubleshooting.
- Prepare technical designs, impact assessments, Business Requirements Documents (BRDs), and RICEFW specifications.