Job Description

Job Title: QA Automation Engineer Snowflake
Location: Chicago, IL (Onsite from Day 1)

Long-Term Contract

Job Description:

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, 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.

Job Tags

Similar Jobs