Snowflake Data QA ​/ Quality Manager

Data Validation Engineer

Validate source-to-target data mapping to ensure data is accurately loaded from source systems into Snowflake tables according to business requirements. Perform ETL/ELT testing to verify data extraction, transformation, and loading processes to ensure correct data movement and transformation. Execute data quality testing to validate completeness, accuracy, consistency, uniqueness, and integrity of data stored in Snowflake. Develop and run SQL validation queries to compare source and target data, identify discrepancies, and verify business rules.

Test Snowflake objects to validate databases, schemas, tables, views, materialized views, stages, streams, tasks, and stored procedures. Perform regression and functional testing to ensure new changes do not impact existing functionalities and validate end-to-end business processes. Conduct performance testing to analyze query execution performance, warehouse utilization, and data load efficiency for large datasets. Validate security and access controls to test role-based access control, user permissions, data masking policies, and security compliance.

Automate data validation processes to develop automation scripts using SQL, Python, or testing frameworks to improve testing efficiency and coverage. Defect tracking and reporting to identify, document, track, and retest defects while collaborating with developers and data engineers to resolve issues.