Data Migration & Test Data Expert (AWS & Oracle)

Cartney; United States; Vor Ort; USD 110.000 - 170.000; Vollzeit

Zusammenfassung

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,

Qualifikationen

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

Aufgaben

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

Kenntnisse

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

Jobbeschreibung

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,