Test Automation Architect (Data Migration & Snowflake) Kansas City, KS in Kansas City

Energy Jobline
Kansas City, United States of America
28 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Kansas City, United States of America

Tech stack

Vbscript
API
Application Integration Architecture
Automation of Tests
Big Data
Cloud Database
Code Review
Data Validation
Information Engineering
Data Integrity
ETL
Data Mapping
Data Transformation
Data Migration
Data Profiling
Data Security
Relational Databases
Python
Microsoft SQL Server
Oracle Applications
Software Configuration Management
SQL Databases
Systems Integration
Test Data
Tricentis Tosca Testsuite
Scripting (Bash/Python/Go/Ruby)
Delivery Pipeline
Snowflake
Pandas
Pytest
Api Management

Job description

We are seeking a strategic and highly technical Test Automation Architect to lead the quality engineering efforts for a large-scale data migration project to Snowflake. You will be responsible for designing a robust, multi-tool automation framework that ensures data integrity, performance, and seamless business process continuity. As the Architect, you will orchestrate the integration of Tricentis Tosca, UFT, and Python to validate complex ETL pipelines and cloud data warehouse architectures., Define and implement a hybrid automation strategy using Tosca for model-based UI/API testing, UFT for legacy system integration, and Python for high-volume data validation.

Develop custom Python-based utilities and libraries to perform automated source-to-target reconciliation, schema validation, and data quality checks within Snowflake.

Lead the design of automated workflows that bridge the gap between legacy on-premises systems and modern cloud data environments.

Embed automated testing suites into the DevOps pipeline to enable continuous testing for ETL jobs and data transformations.

Provide architectural governance, conduct code reviews for Python scripts, and establish best practices for Model-Based Test Automation (MBTA) in Tosca.

Design automated tests to evaluate Snowflake warehouse performance, concurrency, and data throughput.

Requirements

Expert-level knowledge of Snowflake architecture, including Virtual Warehouses, Stages, Snowpipe, and Secure Data Sharing.

Mastery of Tricentis Tosca, including Distributed Execution (DEX), Test Data Service (TDS), and API scan modules.

Advanced proficiency in Micro Focus UFT/One, specifically VBScript scripting, Object Repository management, and legacy application integration.

High proficiency in Python for data engineering tasks, utilizing libraries such as Pandas, PyTest, Great Expectations, and the Snowflake-Python Connector.

Deep understanding of ETL/ELT lifecycles, data mapping, and validating transformations from RDBMS (Oracle, SQL Server) to Cloud Data Warehouses.

Mastery of complex SQL for data profiling

Test Automation Architect (Data Migration & Snowflake) Kansas City, KS in Kansas City

Apply for this position