PLM agile Data migration expert

Tata Consultancy Services; Austin (TX); Hybrid; USD 100,000 - 145,000; Full time

Job summary

Tata Consultancy Services seeks a Data Extraction Specialist to design and implement extraction logic across PLM+ environments. You will collaborate with PLM+ teams, DBAs, and SMEs to ensure accurate mapping, validation, and scalable extraction processes.

Responsibilities include building SQL/PLSQL/SDK-based extract programs, optimizing performance, handling FileVault content, and delivering clean extraction outputs for downstream transformation.

Qualifications

• Understanding of Agile schemas and extraction design.
• Experience building and optimizing SQL/PLSQL/SDK-based extract programs.
• Profiling, completeness checks, referential integrity validation, and error triage.
• Ability to implement full revision history extraction for migrations.
• Skill in tuning queries, indexes, and batch logic to improve throughput.
• Experience with FileVault, attachments, metadata, and cloud ingestion prep.
• Deliver clean, structured extract files/tables for downstream transformation.
• Participate in iterative mock runs, troubleshoot failures, and refine logic.
• Collaborate with PLM+ teams, DBAs, SMEs, and integration teams.
• Create and maintain design docs, BRDs, and technical specs (RICEFW).

Responsibilities

• Understand and map extraction scope and design.
• Develop and optimize extraction scripts for high-volume data.
• Validate data quality and perform error triage.
• Implement full revision history extraction for migrations.
• Tune queries, indexes, and batch logic to improve throughput.
• Handle FileVault attachments and metadata for cloud ingestion.
• Deliver structured extract files for downstream transformation.
• Participate in dry runs and UAT to refine extraction logic.
• Collaborate with PLM+ teams, DBAs, SMEs, and integration teams.
• Produce technical design artifacts and BRDs.

Skills

Agile schema analysis

Extraction script development

Data quality validation

Revision-based extraction

Performance optimization

FileVault handling

Staging & transformation support

Dry run & UAT support

Cross-team collaboration

Documentation artifacts

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)

Job Description
Must Have Technical/Functional Skills

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

Location:Sunnyvale,CA/Austin,TX (3days in office)
Salary range:$100,000-$145,000 Per Year.