Test Automation Architect

Description:

Test Automation Architect (Data Migration & Snowflake)

Location: Calgary (Onsite)

Job type: Long Term Contract

Overview

Looking for a senior Test Automation Architect to lead automation strategy for a large-scale data migration to Snowflake. This role focuses on ensuring data integrity, ETL validation, and automation framework design across modern and legacy systems.

Key Responsibilities

• Design hybrid automation framework using:
• Tricentis Tosca
• Micro Focus UFT
• Python
• Build Python-based data validation frameworks (ETL reconciliation, schema checks)
• Validate Snowflake data pipelines & transformations
• Integrate automation into CI/CD pipelines
• Lead end-to-end test orchestration (on-prem → cloud)
• Define best practices for Model-Based Testing (MBTA)
• Perform performance & scalability testing for Snowflake

Required Skills

• Strong expertise in Snowflake (Warehouses, Snowpipe, Stages)
• Hands-on with:
• Tosca (DEX, TDS)
• UFT / UFT One (VBScript)
• Advanced Python (Pandas, PyTest, Great Expectations)
• Strong ETL / Data Migration validation
• Experience with Oracle / SQL Server → Cloud migration