Agile PLM TCRA Developer / Agile Data migration expert.

Cognizant; Austin, Town of Texas (TX, WI); On-site; USD 100,000 - 170,000; Full time

Job summary

Cognizant is seeking an Agile Data Migration expert - Software engineer for an onsite assignment in Austin, TX to drive data extraction, transformation, and loading from Oracle Agile PLM to the NextGen PLM+ cloud platform.

You will collaborate with PLM+, DBAs and SMEs to design extraction logic, build scripts (SQL/PLSQL/SDK), validate data quality, manage FileVault content, and optimize performance across full and delta migrations, with hands‑on participation in dry runs and UAT.

Qualifications

• Experience with Oracle Agile PLM required.
• Data migration experience required.
• Ability to design extraction logic for Item, BOM, Change, and FileVault data.
• Experience with SQL/PLSQL/SDK for high-volume extractions.

Responsibilities

• Agile Schema Analysis to map Item, BOM, Change, AML and FileVault structures.
• Extraction Script Development using SQL/PLSQL/SDK for high-volume objects.
• Data Quality Validation including profiling and referential integrity checks.
• Revision-Based Extraction to capture full history for PLM+ migration.
• Performance Optimization to reduce extraction time.
• Cross‑Team Collaboration with PLM+, DBAs, SMEs, and integration teams.

Skills

Agile Schema Analysis

Extraction Script Development

Data Quality Validation

Revision-Based Extraction

Performance Optimization

FileVault Handling

Staging & Transformation

Dry Run & UAT Support

Cross-Team Collaboration

Tools

SQL/PLSQL/SDK

Job description

"Applicants must be currently authorized to work for any employer in the United States. The company is unable to provide employment-based immigration sponsorship for this position."

Onsite Location: Austin

JD:

NextGen PLM+ Data Migration is the end‑to‑end process of moving Item, BOM, Change, and File Vault data from Agile PLM into the new cloud‑based PLM+ platform. It covers base migration for full data load and delta migration for incremental changes. The project ensures accurate data mapping, transformation, validation, and seamless loading into Oracle Cloud PLM+. It enables coexistence between legacy Agile and NextGen PLM+ until full cutover. Let me know if you want a crisp one‑liner for leadership.

Role: Agile Data Migration expert - Software engineer

Oracle Agile PLM - Required

Data Migration - Required

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)