QA Automation Engineer; Snowflake __ Chicago, IL __
Job in
Chicago, Cook County, Illinois, 60601, USA
Listed on 2026-06-27
Listing for:
Ace Stack
Contract
position Listed on 2026-06-27
Job specializations:
-
IT/Tech
Data Engineering, Data Analyst, IT QA Tester / Automation, Data Warehousing
Job Description & How to Apply Below
QA Automation Engineer
Location:
Chicago, IL (Onsite from Day
1)
Long-Term Contract
We are seeking a QA Automation Engineer with hands-on experience in testing Snowflake data platforms and automation scripting. The ideal candidate will be responsible for designing and executing test strategies for data validation, ETL/ELT pipelines, and automation of database testing across cloud-based data warehouses—primarily Snowflake.
Key Responsibilities:- Design, develop, and execute automated test cases focused on data validation, ETL/ELT pipelines, and Snowflake-based data solutions.
- Perform data integrity, transformation logic, and end-to-end pipeline testing for large datasets.
- Develop reusable test scripts using SQL, Python, or Java for automation of data tests.
- Work closely with data engineers, QA leads, and business analysts to understand data transformation rules and ensure accurate data delivery.
- Validate stored procedures, data ingestion jobs, and dataflows within the Snowflake environment.
- Integrate automated data tests into CI/CD pipelines (Jenkins, Git Lab, etc.).
- Identify, log, and track issues using JIRA or similar tools, and ensure timely resolution.
- Document test strategies, test plans, and results for internal QA and stakeholder reference.
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent industry experience.
- 7-10+ years of experience in QA Automation, with data testing and Snowflake experience.
- Strong proficiency in writing complex SQL queries for data validation and reconciliation.
- Hands-on experience with Snowflake: schema design, queries, views, data ingestion, and role-based access.
- Familiarity with ETL/ELT testing using tools like Informatica, DBT, Matillion, or similar (any is a plus).
- Scripting skills in Python or Java for test automation.
- Understanding of data warehouse concepts, data modeling, and cloud data pipelines.
- Experience working with CI/CD tools (e.g., Jenkins, Git).
- Knowledge of Agile methodology, and ability to work in sprints and deliver testable features.
- Exposure to cloud platforms like AWS, Azure, or GCP.
- Experience with data visualization tools (e.g., Power BI, Tableau) for validation purposes.
- Familiarity with test reporting tools like Allure, Extent Reports, etc.
- Experience with large-scale data migration or modernization projects.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×