Data Migration Engineer (Jama)
Location:
Irvine, CA – Hybrid (3 days/week onsite)
Duration:
6-Month Contract
Schedule:
Monday–Friday, 8:00 AM – 5:00 PM
Pay Range:$54.50 – $59.50/hour
Position Overview
We are seeking an experienced Data Migration Engineer
to lead the automated migration of requirements and test management data from Jama Connect
into a new requirements management platform. This role is highly technical and hands-on, focused on ensuring data accuracy, traceability, and integrity throughout the migration lifecycle.
The ideal candidate will assess existing migration scripts and either enhance the current framework or design a more robust custom solution to support a high-fidelity, scalable migration.
Key Responsibilities
Migration Framework & Automation
- Review and evaluate existing baseline migration scripts (Python / REST API-based).
- Enhance, refactor, or redesign migration automation to improve reliability, performance, and data coverage.
- Own end-to-end migration logic and execution strategy.
API Integration
- Utilize Jama Connect REST APIs and the target system’s APIs to migrate complex datasets.
- Handle rich text, embedded tables, attachments, and metadata accurately.
Data Structure & Traceability
- Recreate complex parent–child hierarchies across requirements and test cases.
- Preserve full upstream and downstream traceability between related items.
ETL Execution
- Prepare: Partner with stakeholders to clean and validate data pre-migration.
- Extract: Pull structured and unstructured data from Jama Connect.
- Transform: Map fields, normalize data, and convert formats as required.
- Load: Push validated data into the target environment.
Validation & Quality Assurance
- Execute dry-run migrations prior to final cutover.
- Develop automated validation and reconciliation reports to confirm 100% data parity.
- Ensure data integrity, completeness, and auditability.
Process & Cutover Planning
- Maintain a detailed migration Runbook, including rollback, freeze windows, and cutover plans.
- Coordinate migration timing and execution with technical and business teams.
Required Qualifications
- 3+ years of experience in Data Migration, Systems Integration, or DevOps-focused roles.
- Strong proficiency in Python(preferred) or Java.
- Hands-on experience with REST APIs, JSON, and XML data structures.
- Demonstrated experience designing or supporting automated ETL pipelines.
- Strong documentation, planning, and execution discipline.
Preferred Experience
- Prior experience working with Jama Connect, particularly its API and item relationship model.
- Experience migrating requirements or test management systems.
- Familiarity with data validation frameworks or reconciliation tooling.
...