> Markdown version of [/jobs/ext/598656-test-architect-data-migration-snowflake](https://www.wearedevelopers.com/jobs/ext/598656-test-architect-data-migration-snowflake). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Test Architect (Data Migration & Snowflake) - **Company:** Job Cloud Inc. - **Location:** Kansas City, MO, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Vbscript, Application Programming Interfaces (APIs), Application Integration Architecture, Automation of Tests, Big Data, Cloud Computing, Cloud Database, Cloud Engineering, Code Review, Computer Programming, Continuous Integration, Data Validation, Information Engineering, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Profiling, Data Security, Relational Databases, Interoperability, Python (Programming Language), Microsoft SQL Server, Oracle (Applications), Software Configuration Management, SQL Databases, Systems Integration, Test Data, Toolchain, Tricentis Tosca, Scripting, Sql Optimization, Delivery Pipeline, Snowflake, Pandas, Pytest, Api Management - **Published:** June 22, 2026 - **Apply:** https://www.dice.com/job-detail/45a9bf60-4ea7-4318-9c76-ff0740859cd5 ## About the Role * Architecture-Led, Data-Centric Automation Design - We need someone who can design the blueprint, not just build within one. * CI/CD Integration for Data and Analytics Testing * Strong Data Quality & Reconciliation Expertise ability to validate cloud-native, event-driven pipelines or generate audit-ready evidence for regulatory compliance . * Toolchain and Interoperability Mastery - Snowflake. * Pragmatic Leadership & Enablement - demonstrate architect-level strategic thinking - Automation phasing, guardrails, or maturity roadmaps, * Cloud Platforms: Expert-level knowledge of Snowflake architecture, including Virtual Warehouses, Stages, Snowpipe, and Secure Data Sharing. * Automation Tooling (Tosca): Mastery of Tricentis Tosca, including Distributed Execution (DEX), Test Data Service (TDS), and API scan modules. * Automation Tooling (UFT): Advanced proficiency in Micro Focus UFT/One, specifically VBScript scripting, Object Repository management, and legacy application integration. * Programming: High proficiency in Python for data engineering tasks, utilizing libraries such as Pandas, PyTest, Great Expectations, and the Snowflake-Python Connector. * Data Engineering & ETL: Deep understanding of ETL/ELT lifecycles, data mapping, and validating transformations from RDBMS (Oracle, SQL Server) to Cloud Data Warehouses. * Advanced SQL: Mastery of complex SQL for data profiling ## Description We are seeking a strategic and highly technical Test 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., * Strategic Framework Design: 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. * Snowflake Validation: Develop custom Python-based utilities and libraries to perform automated source-to-target reconciliation, schema validation, and data quality checks within Snowflake. * End-to-End Orchestration: Lead the design of automated workflows that bridge the gap between legacy on-premises systems and modern cloud data environments. * CI/CD Integration: Embed automated testing suites into the DevOps pipeline to enable continuous testing for ETL jobs and data transformations. * Technical Leadership: Provide architectural governance, conduct code reviews for Python scripts, and establish best practices for Model-Based Test Automation (MBTA) in Tosca. * Performance & Scalability: Design automated tests to evaluate Snowflake warehouse performance, concurrency, and data throughput. ## Related Videos - [pytest: Simple, rapid and fun testing with Python](https://www.wearedevelopers.com/videos/213-pytest-simple-rapid-and-fun-testing-with-python) - [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript) - [SMART Test Automation - the experience of legacy transformation](https://www.wearedevelopers.com/videos/100215-smart-test-automation-the-experience-of-legacy-transformation) - [Automagic Configuration in Python](https://www.wearedevelopers.com/videos/363-automagic-configuration-in-python) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) ## Related Articles - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [What is a Test Plan: Guide to Test Planning](https://www.wearedevelopers.com/magazine/191-what-is-a-test-plan-guide-to-test-planning)