Data Migration Engineer

Premier Staffing Solution • Irvine, CA

22h • Hybrid

About The Position

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.

Requirements

• 3+ years in Data Migration, Systems Integration, or DevOps.
• High proficiency in Python (preferred) or Java.
• Experience with REST APIs and JSON/XML data structures is mandatory.
• Ability to manage a migration "Runbook," including planning for data freezes and cutover windows.
• Must be able to work on-site in [Insert City] 3 days per week .

Nice To Haves

• Prior experience with Jama Connect (specifically its API and item relationship model) is highly desirable.

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: 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed