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 |
Tata Consultancy Services
$100,000 - $145,000
Oct 28, 2026