Data Migration Specialist

Cartney; United States; On-site; USD 110,000 - 170,000; Full time

Job summary

Cartney is seeking an experienced Test Data & Data Migration Specialist to drive data migration execution, mock data creation, and target-to-source reconciliation for end-to-end testing. You will bridge core database operations with quality engineering by generating high-volume, production-like datasets and establishing continuous synchronization between source and target systems.

You will work closely with testing squads, data engineering teams, and third-party partners to ensure data fidelity,

Qualifications

• Experience designing large-volume mock datasets for complex lab/testing environments.
• Ability to implement data masking, synthetic data generation, and subsetting for compliance.
• Proven track record in data migration, reconciliation, and auditing across systems.
• Experience with AWS cloud services and Oracle databases is essential.
• Strong scripting and automation skills (Python/SQL) for data provisioning and validation.

Responsibilities

• Design, create, and maintain large-volume, high-fidelity mock datasets for lab and integrated testing environments.
• Implement masking, synthetic data generation, and subsetting to ensure data compliance while maintaining relational integrity.
• Provide data provisioning support across multiple testing cycles (Integration, Performance, UAT, Regression).
• Execute end-to-end data migration activities from source systems to Oracle target environments using AWS cloud services and S3 storage.
• Build and maintain target-to-source data reconciliation frameworks to validate migration accuracy, completeness, and schema consistency.
• Establish and operate a continuous reconciliation process to keep legacy source and target environments in sync throughout the testing lifecycle.
• Manage daily change communications and track schema updates, data fixes, and structural changes across teams.
• Act as the primary Data Coordinator across internal test teams, DBAs, and external partners.
• Trace and document business workflows and dataflows to ensure transformations align with business logic.
• Perform post-test data validation to help QA investigate data-driven defects.

Skills

Data coordination

Cross-team collaboration

Analytical thinking

Communication skills

Problem-solving

Tools

Oracle Database

PL/SQL

AWS

AWS S3

AWS DMS

Informatica

Talend

Oracle GoldenGate

Python/SQL pipelines

Job description

No VISA Sponsorship or support for OPT/CPT. No C2C.

We are seeking an experienced Test Data & Data Migration Specialist to drive data migration execution, mock data creation, and target-to-source reconciliation in support of end-to-end testing. In this role, you will bridge the gap between core database operations and quality engineering by generating high-volume, production-like test datasets for lab environments and establishing continuous synchronization processes between source and target systems.

You will work closely with internal testing squads, core data engineering teams, and third-party partners to ensure robust data fidelity, proper end-to-end workflow understanding, and rapid validation of test results.

Key Responsibilities

• Design, create, and maintain large-volume, high-fidelity mock datasets tailored for complex lab and integrated testing environments.
• Implement masking, synthetic data generation, and subsetting strategies to ensure data compliance while maintaining relational integrity.
• Provide dedicated data provisioning support across multi-tiered testing cycles (Integration, Performance, UAT, and Regression).

2. Data Migration, Reconciliation & Synchronization

• Execute end-to-end data migration activities from source systems to Oracle target environments, primarily utilizing AWS cloud services and S3 storage.
• Build and maintain target-to-source data reconciliation frameworks to validate migration accuracy, completeness, and schema consistency.
• Establish and operate a continuous reconciliation process to keep legacy source and target environments in sync throughout the testing lifecycle.
• Manage daily change communications, tracking ongoing schema updates, data fixes, and structural changes across teams.

3. Cross-Functional Coordination & Workflow Expertise

• Act as the primary Data Coordinator across internal test execution teams, database administrators, and external partner organizations.
• Trace and document business workflows and dataflows across applications to ensure data transformations accurately align with business logic.
• Perform post-test data validation, helping QA engineers investigate and troubleshoot data-driven defect root causes.

Required Qualifications & Technical Experience

• Database & Core Systems: Strong expertise in Oracle Database architecture, PL/SQL, complex queries, and database tuning for bulk data loads.
• Cloud & Storage: Hands-on experience working within AWS environments, specifically managing data files, object structures, and automated transfers using AWS S3.
• ETL & Data Migration: Proficiency with enterprise Data Migration tools (e.g., AWS DMS, Informatica, Talend, Oracle GoldenGate, or custom Python/SQL migration pipelines).
• Test Data Management: Proven track record of generating synthetic mock datasets at scale and managing test data lifecycle operations.
• Reconciliation & Auditing: Solid background creating automated data verification scripts/jobs for row-count matching, field-level reconciliation, and delta tracking.
• Workflow & Process Mastery: Ability to quickly master complex enterprise workflows and map technical dataflows to business processes.
• Collaboration & Communication: Outstanding communication skills to align multiple testing teams, external partners, and vendors around daily data updates.
• Problem-Solving & Analytical Rigor: Deep detail orientation when hunting down data discrepancies between legacy and modern target systems.

Preferred Qualifications

• Experience with automated test frameworks or CI/CD data pipeline integration.
• Exposure to regulatory compliance guidelines regarding test data privacy (GDPR, HIPAA, SOC2).
• Familiarity with scripting languages (Python, Bash, or Shell) for automating S3 file parsing and daily reconciliation reports.