Data Migration Specialist (United States)

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

1. Test Data Management (TDM) & Lab Support

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

Soft Skills & Competencies

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