Plm Agile Data Migration Expert

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

Job summary

Tata Consultancy Services Limited is seeking an Engineer in the TECHNOLOGY function for an office-based role in Austin, TX with three days in the office. The role focuses on designing and implementing extraction logic for PLM systems, including Item, BOM, Change, AML, and FileVault structures, using Agile methodologies and SQL/SDK-based solutions.

The candidate will perform data quality validation, staging and transformation support, and cross-team collaboration with PLM teams, DBAs, SMEs, and

Qualifications

• Experience with Agile schema analysis and PLM integrations.
• Strong SQL/PLSQL experience for high-volume extractions.
• Familiarity with data quality validation and staging/transformation workflows.

Responsibilities

• Analyze and design extraction logic for Item, BOM, Change, AML, and FileVault structures.
• Develop and optimize SQL/PLSQL/SDK-based extract programs for large datasets.
• Validate data quality, profiling, referential integrity, and error triage.
• Implement revision-based extraction for PLM migrations.
• Collaborate with DBAs, SMEs, and integration teams to ensure correct mapping and validation.

Skills

Agile

SQL

PLM

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.

LI-AS3

Location: Austin, TX

Function: TECHNOLOGY

Role: Engineer

ID: 433617

Skills: Agile | SQL | PLM

Salary Range: $100,000 - $145,000