Software QA
Insight Global
Job Description
Insight Global is seeking an experienced Software QA Analyst to join one of the largest Retail Clients in Vancouver BC. This person will be joining the Data Platform and Governance Team. We are seeking candidates with specialized expertise in Snowflake data warehousing. This role is critical to ensuring data integrity and system reliability across our enterprise data platform. The successful candidate will work collaboratively within a multi-tiered QA ecosystem, interfacing with upstream and downstream QA teams while leading complex Snowflake testing initiatives.
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
Principal Duties and Responsibilities:
Design, develop, and execute comprehensive test plans and test cases for Snowflake-based data pipelines.
Perform functional, integration, and regression testing across multiple Snowflake environments.
Identify, document, and track defects through resolution using established defect management processes.
Collaborate with development teams to understand system requirements and translate them into effective testing strategies.
Provide quality-focused feedback on database schemas and data transformation logic.
Snowflake Migration Testing
Lead end-to-end testing efforts for Snowflake version migrations and platform upgrades.
Develop and maintain automated scripts to validate data consistency, schema integrity, and functional equivalence between Snowflake versions.
Create database comparison utilities to identify discrepancies in data, metadata, and performance characteristics.
Execute pre-migration, migration, and post-migration validation processes.
Document migration testing procedures and maintain testing artifacts for future upgrades.
Database Testing & Validation
Develop and maintain SQL scripts for data validation, comparison, and quality assessment.
Perform comprehensive database testing including data integrity checks, and referential integrity validation.
Establish and maintain test data management processes for Snowflake environments.
Testing Expertise
Solid understanding of software testing methodologies, SDLC, test design techniques, and QA best practices.
Experience with test management tools (JIRA, TestRail, or similar).
Knowledge of CI/CD processes and integration testing within DevOps environments.
Experience with automated testing frameworks and tools.
Understanding of data warehousing concepts.
Must Haves:
5+ years of experience in software quality assurance with at least 3 years of hands-on Snowflake experience.
Expert-level SQL skills with proven ability to write complex queries, and database comparison scripts.
Strong experience in Snowflake migration testing including version upgrades and platform transitions.
Proficiency in scripting languages (Python, Shell scripting) for test automation.
Strong communication skills with ability to work effectively across multiple teams.
Experience with ETL/ELT testing and data pipeline validation.
Experience with Microsoft Azure and Amazon Basic understanding of PowerBI
Familiarity with Salesforce is an advantage null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
Por favor confirme su dirección de correo electrónico: Send Email