PLM agile Data migration expert

JOB DETAILS:

Position: PLM agile Data migration expert

Location: Sunnyvale, CA Onsite

Type of Employment: 12+ Months Contract

Role Description:

• Scope of activities and deliverables (not exhaustive list)
• 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, 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)