Data Migration Specialist

Job Title: Data Migration Engineer

Location: Irvine, CA

Zip Code: 92606

Duration: 6 Months

Job Description:

• We are seeking a technical Data Migration Engineer to lead the transition of our requirements and test management data. While we have existing 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 the Jama Connect REST API and the target tool"s API to move complex data sets, including rich text, tables, and file attachments.
• Hierarchical Mapping: Replicate complex "Parent-Child" hierarchies and maintain strict traceability links (Upstream/Downstream) between requirements and test cases.
• ETL Management: Manage the end-to-end process:
• Extract: 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 in Python (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 City] 3 days per week.