PLM agile Data migration expert

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 the latest revision, 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 and 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

• 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)

Location

Sunnyvale, CA / Austin, TX (3 days in office)

Pay

$100,000 – $145,000 per year