QA Automation Engineer (Snowflake) __ Chicago, IL __ Contract

QA Automation EngineerLocation: Chicago, IL (Onsite from Day 1)Long-Term ContractWe 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, GitLab, 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.Required Skills: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.Nice to Have: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, ExtentReports, etc.Experience with large-scale data migration or modernization projects.