Why This Role Stands Out
This hybrid role offers a fantastic opportunity to leverage your expertise in Agile PLM data migration, contributing to a high-impact project with a reputable company. You'll thrive here if you excel at schema analysis, SQL scripting, and data validation, and enjoy collaborating with cross-functional teams to ensure seamless data transfer and transformation. Apply now to gain valuable experience and advance your career in a dynamic environment.
Quick Overview
Job 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)
Similar jobs
- RT
Streamer/Live Show Host
NewRefreshed Tech
Ashley, IN🇺🇸On-site21 hours agoFLSA - A&
General Maintenance
NewAtkins & Pearce Inc
Ft Mitchell, KY🇺🇸Hybrid21 hours agoREST - SK
Rental Coordinator
NewSkyworks LLC
Indianapolis, IN🇺🇸Hybrid21 hours agoInside SalesOutside Sales - LI
SaaS BDR
NewLiveswitch, Inc.
Salt Lake City, UT🇺🇸$60k - $100k/yrOn-site21 hours agoFMLAHVACOutreach+1 - EC
Project Mgr-Clinical+Operational Innovations
NewElement Care
Lynn, MA🇺🇸On-site21 hours agoMicrosoft Excel - SO
Legislative Director
NewState of Washington
Olympia, WA🇺🇸$105k - $140k/yrRemote21 hours agoPerformance Management