TC
Agile Data Migration expert - Software engineer
TechDigital Corporation
🇺🇸 United States
Hybrid
1 week ago
- Vault
- Agile
- Oracle Cloud
- Oracle
- AML
- SQL
- PL/SQL
- triage
1 week ago
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.
Years of Exp : 8+ Years
Oracle Agile PLM - Required
Data Migration - Required
Scope of activities and deliverables (not exhaustive list)
Agile Schema Analysis — Understand Item, BOM, Change, AML, and File Vault 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.
File Vault 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, including but not limited to: - Conceptual design and technical design - Technical Impact Assessments - Review and finalized Business Requirements Documents (BRD) - Technical Specifications for RICEFW (reports, integrations, customizations, extensions, forms, workflows)
Agile Data Migration expert - Software engineer · TechDigital Corporation