Agile PLM Data Migration

About the role

NextGen PLM+ Data Migration is the end‑to‑end process of moving Item, BOM, Change, and File Vault data from Agile PLM into the new cloud‑based PLM+ platform. It covers base migration for full data load and delta migration for incremental changes. The project ensures accurate data mapping, transformation, validation, and seamless loading into Oracle Cloud PLM+. It enables coexistence between legacy Agile and NextGen PLM+ until full cutover.

Responsibilities

• Agile Schema Analysis – Understand Item, BOM, Change, AML, and FileVault structures to design accurate extraction logic.
• Extraction Script Development – Build and optimize SQL/PLSQL/SDK‑based extract programs for high‑volume objects and revisions.
• Data Quality Validation – Perform profiling, completeness checks, referential integrity validation, and error triage.
• Revision‑Based Extraction – Implement logic to extract full revision history, not just latest rev, for PLM+ migration needs.
• Performance Optimization – Tune queries, indexes, and batch logic to reduce extraction time and improve throughput.
• FileVault Handling – Extract attachments, manage file paths, metadata, and prepare content for cloud ingestion.
• Staging & Transformation Support – Deliver clean, structured extract files/tables for downstream transformation and mapping.
• Dry Run & UAT Support – Participate in iterative mock runs, troubleshoot failures, and refine extraction logic.
• Cross‑Team Collaboration – Work with PLM+, DBAs, SMEs, and integration teams to align mapping, sequencing, and validation.
• Documentation artifacts – Produce conceptual design and technical design, technical impact assessments, reviewed and finalized Business Requirements Documents (BRD), and technical specifications for RICEFW (reports, integrations, customizations, extensions, forms, workflows).