13 hours ago
Responsibilities
- Analyze Agile PLM schemas covering Items, BOMs, Changes, AML, and FileVault structures.
- Build and optimize SQL, PL/SQL, and SDK-based extraction programs for high-volume objects and revisions.
- Implement extraction of complete revision histories for PLM+ migration.
- Perform data profiling, completeness checks, referential integrity validation, and error triage.
- Tune queries, indexes, and batch logic to improve extraction performance and throughput.
- Extract FileVault attachments and manage file paths, metadata, and cloud-ingestion preparation.
- Provide clean, structured extract files and tables for downstream transformation and mapping.
- Support dry runs and UAT by troubleshooting failures and refining extraction logic.
- Collaborate with PLM+, DBAs, SMEs, and integration teams on mapping, sequencing, and validation.
- Produce conceptual and technical designs, technical impact assessments, finalized BRDs, and RICEFW technical specifications.
Requirements
- Oracle Agile PLM experience is required.
- Data migration experience is required.
- Experience developing SQL, PL/SQL, or SDK-based extraction programs.
- Experience with Agile PLM data structures, revision history, FileVault content, and migration validation.
- Ability to perform query, index, and batch performance optimization.
- Applicants must be currently authorized to work for any employer in the United States.
- The role requires onsite work in Austin.
Tech Stack
Categories
Data Engineering
About Cognizant
Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.