Data Migration Engineer

Irvine, CA - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Project Overview

We are seeking a technical Data Migration Engineer to lead the transition of our requirements and test management data. While we haveexisting baseline migration scripts (Python/REST API) we are looking for a specialist who can evaluate these tools enhance them where necessary or develop a superior custom solution to ensure a seamless high-fidelity migration.

Key Responsibilities

Script Evaluation & Development: Review existing baseline migration scripts. Decide whether to optimize and extend the current codebase or build a new automated framework to handle the extraction and ingestion.
API Integration: Leverage theJama Connect REST API and the target tools API to move complex data sets including rich text tables and file attachments.
Hierarchical Mapping: Replicate complex Parent-Child hierarchies and maintain stricttraceability links (Upstream/Downstream) between requirements and test cases.
ETL Management: Manage the end-to-end process:
- Prepare:Prepare and clean data with teams prior to migration. Extract and pull data from Jama.
- Transform: Map fields clean data and convert formats.
- Load: Push to the new environment.
Validation: Conduct dry-run migrations and develop automated validation reports to prove 100% data parity and integrity.

Requirements

Experience: 3 years in Data Migration Systems Integration or DevOps.
Technical Stack: High proficiency inPython (preferred) or Java. Experience with REST APIs and JSON/XML data structures is mandatory.
Jama Connect Knowledge: Prior experience with Jama Connect (specifically its API and item relationship model) is highly desirable.
Process Oriented: Ability to manage a migration Runbook including planning for data freezes and cutover windows.
Availability: Must be able to work on-site in Insert City3 days per week.

Required Experience:

Project OverviewWe are seeking a technical Data Migration Engineer to lead the transition of our requirements and test management data. While we haveexisting baseline migration scripts (Python/REST API) we are looking for a specialist who can evaluate these tools enhance them where necessary or deve...