← Back to Jobs

Other

TC

PLM agile Data migration expert

TATA Consultancy Services LimitedAustin, TX🇺🇸United StatesPosted Sep 28, 2026

Quick Overview

Salary

$100k - $145k/yr

Seniority

Mid Senior

Work mode

On Site

Location

Austin, TX, United States

Posted

23 hours ago

SQLAgileTriage

Job Description

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

Similar jobs