Data Migration Test Analyst

Evolutyz Corp; Houston (TX); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Hybrid work environment

Job summary

Evolutyz Corp seeks a Data Migration Test Analyst to validate data moved into Snowflake within an Azure ecosystem. You will design end-to-end test strategies, execute SQL-based validation, and ensure data completeness and quality across legacy to cloud platforms.

The role emphasizes collaboration with Data Engineers, Architects, and Analysts, participation in Agile ceremonies, and developing automated data validation frameworks.

Qualifications

• Experience with data migration testing and strong SQL skills.
• Familiarity with Azure and Snowflake environments.
• Ability to validate ETL/ELT processes and data quality.
• Experience with enterprise reporting validation and automated testing methodologies.
• Alteryx experience preferred.

Responsibilities

• Design and execute end-to-end testing strategies for migration initiatives.
• Validate data transformations, mappings, and business rules between source systems and Snowflake target environments.
• Perform source-to-target reconciliation testing to confirm completeness, accuracy, and consistency of migrated data.
• Develop and execute SQL-based validation scripts against large datasets.
• Create, execute, and maintain test cases, test plans, and detailed test evidence.
• Validate ETL/ELT pipelines and data ingestion processes.
• Develop automated data validation scripts and reusable testing frameworks.
• Investigate data anomalies, transformation issues, and reconciliation exceptions.
• Support functional, integration, regression, and user acceptance testing activities.
• Perform data profiling, data quality assessments, and root cause analysis.
• Collaborate with Data Engineers, Data Architects, Product Owners, and Business Analysts to resolve data quality issues.
• Develop data quality metrics and testing dashboards to measure migration success.
• Validate reporting and analytics outputs migrated from legacy platforms into Snowflake.
• Participate in Agile ceremonies including sprint planning, backlog refinement, and defect triage.
• Document defects with detailed root-cause analysis and testing results.

Skills

Data validation

ETL/ELT validation

SQL analysis

Source-to-target reconciliation

Migration testing

Data quality testing

Enterprise reporting validation

Automated testing

Alteryx

Tools

Snowflake

Azure

Alteryx

Job description

Summary:

We are seeking a highly skilled Data Migration Test Analyst to support enterprise data migration initiatives into Snowflake within an Azure ecosystem. This role will be responsible for validating the accuracy, completeness, integrity, and transformation of data as it moves from legacy platforms and data warehouses into modern cloud-based data environments. The ideal candidate will have strong experience in data validation, ETL/ELT validation, source-to-target reconciliation, migration testing, data quality testing, SQL analysis, enterprise reporting validation, and automated testing methodologies. Experience with Alteryx is highly preferred.

Responsibilities:

• Design and execute end-to-end testing strategies for data migration and modernization initiatives.
• Validate data transformations, mappings, and business rules between source systems and Snowflake target environments.
• Perform source-to-target reconciliation testing to confirm completeness, accuracy, and consistency of migrated data.
• Develop and execute SQL-based validation scripts against large datasets.
• Create, execute, and maintain test cases, test plans, and detailed test evidence.
• Validate ETL/ELT pipelines and data ingestion processes.
• Develop automated data validation scripts and reusable testing frameworks.
• Investigate data anomalies, transformation issues, and reconciliation exceptions.
• Support functional, integration, regression, and user acceptance testing activities.
• Perform data profiling, data quality assessments, and root cause analysis.
• Collaborate with Data Engineers, Data Architects, Product Owners, and Business Analysts to resolve data quality issues.
• Develop data quality metrics and testing dashboards to measure migration success.
• Validate reporting and analytics outputs migrated from legacy platforms into Snowflake.
• Participate in Agile ceremonies including sprint planning, backlog refinement, and defect triage.
• Document defects with detailed root-cause analysis and testing results.

Requirements:

Experience with data migration testing, strong SQL skills, and familiarity with Azure and Snowflake environments.

Required Skills:

• Data validation and ETL/ELT validation.
• Source-to-target reconciliation and migration testing.
• Data quality testing and SQL analysis.
• Enterprise reporting validation and automated testing methodologies.

Preferred Skills:

• Experience with Alteryx.
• Experience in Agile methodologies and participation in Agile ceremonies.

Benefits:

Opportunity to work in a hybrid environment with a focus on cutting-edge data migration technologies.