Data Migration Test Analyst

DKMRBH Inc

Seattle, WA

JOB DETAILS
SKILLS
Acceptance Testing, Application Programming Interface (API), Architectural Analysis, Atlassian JIRA, Business Analysis, Business Transformation, Data Analysis, Data Migration, Data Profiling, Data Quality, Data Sets, Database Extract Transform and Load (ETL), DevOps, Documentation Plan, Functional Testing, Integration Testing, Microsoft Windows Azure, Power BI, Problem Solving Skills, Python Programming/Scripting Language, Quality Monitoring, Reconciliation, Regression Testing, Reporting Dashboards, Root Cause Analysis, SQL (Structured Query Language), Snowflake Schema, Strategic Planning, Test Automation, Test Data, Test Plan/Schedule, Test Strategy, Test Tools, Validation Testing, Wealth Management
LOCATION
Seattle, WA
POSTED
Today

Job Title: Data Migration Test Analyst - Snowflake SQL Azure

Location: Seattle, WA (Hybrid - Local Candidates Only)

Important: This is not a traditional QA Automation, Manual QA, Selenium, Cypress, Playwright, SDET, or Web Application Testing position.

We are looking for professionals with hands-on experience in Data Migration Testing, Data Warehouse Testing, ETL/ELT Validation, SQL Data Validation, Snowflake, and Source-to-Target Data Reconciliation. Candidates whose experience is primarily focused on UI testing, test automation frameworks, functional QA, mobile testing, or general application testing are unlikely to be a good fit for this role.

Local candidates in the Greater Seattle area who can work in a hybrid onsite environment are strongly encouraged to apply.

Position Overview

Join a large-scale enterprise data modernization program supporting the migration of critical business data into Snowflake within a Microsoft Azure environment. This role focuses on validating enterprise data migrations by ensuring data accuracy, completeness, integrity, transformation, and reconciliation between legacy systems and the target Snowflake platform.

This opportunity is best suited for professionals with experience in:

  • Enterprise Data Migration Testing

  • Data Warehouse Testing

  • ETL/ELT Validation

  • Data Quality Testing

  • SQL Data Validation

  • Source-to-Target Mapping and Reconciliation

  • Snowflake Migration Projects

Required Qualifications
  • 5+ years of experience in Data Migration, Data Warehouse, ETL, or Data Quality Testing.

  • Strong experience validating enterprise data migration initiatives.

  • Hands-on experience with Source-to-Target Data Validation and Reconciliation.

  • Advanced SQL skills for data validation and analysis.

  • Experience testing ETL/ELT pipelines and data transformations.

  • Hands-on experience with Snowflake.

  • Experience working within Microsoft Azure data environments.

  • Experience validating APIs and data integrations.

  • Experience creating test strategies, test plans, and test documentation.

  • Experience validating large datasets and enterprise reporting.

  • Familiarity with Azure DevOps, Jira, or similar test management tools.

Key Responsibilities
  • Validate enterprise data migrations from legacy platforms into Snowflake.

  • Perform source-to-target reconciliation across large datasets.

  • Validate ETL/ELT pipelines, transformation logic, and business rules.

  • Develop SQL queries for data validation and reconciliation.

  • Investigate data quality issues, anomalies, and transformation defects.

  • Execute functional, integration, regression, and user acceptance testing for migration initiatives.

  • Validate reports, dashboards, and analytics following data migration.

  • Collaborate with Data Engineers, Data Architects, Business Analysts, and Product Owners to resolve data quality issues.

  • Document testing results, defects, root cause analysis, and validation evidence.

Preferred Qualifications

Experience with the following technologies is highly desirable:

  • Alteryx Designer or Alteryx Server

  • Automated Data Validation and Reconciliation

  • QuerySurge or similar data comparison tools

  • Snowflake migration projects

  • Azure Data Factory

  • Data Profiling and Data Quality Monitoring tools

  • Power BI dataset validation

  • Python scripting for data validation and testing automation

Preferred Industry Experience

Candidates with experience in the following industries will be given preference:

  • Banking

  • Financial Services

  • Credit Union

  • Lending

  • Wealth Management

About the Company

D

DKMRBH Inc