PLM agile Data migration expert
Artech
27 days ago
Contract
On-site
Sunnyvale, California, United States
$50 - $64 USD hourly
Job ID: 110693-1
Job Title: PLM agile Data migration expert
Location: Hybrid: Sunnyvale, CA/Austin, TX
Duration: 6 Months
Pay Range: $50.00 - $64.00/Hour on W2/C2C
Skills: Agile Way of Working & Teamcenter Product (PLM)
Experience Required: 8-10
Requested to attach LinkedIn with application
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)
Company Benefits & Culture
• Inclusive and diverse work environment
• Opportunities for professional growth and development
• Comprehensive health and wellness benefits
Job Title: PLM agile Data migration expert
Location: Hybrid: Sunnyvale, CA/Austin, TX
Duration: 6 Months
Pay Range: $50.00 - $64.00/Hour on W2/C2C
Skills: Agile Way of Working & Teamcenter Product (PLM)
Experience Required: 8-10
Requested to attach LinkedIn with application
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)
Company Benefits & Culture
• Inclusive and diverse work environment
• Opportunities for professional growth and development
• Comprehensive health and wellness benefits