Testing - Job Description
Scope
Comprehensive testing support covering unit testing, integration testing, system testing, and User Acceptance Testing (UAT) for data pipelines and the overall product.
- Design, implement, and execute test plans and scripts for data ingestion, dbt transformation models, and system functionality.
- Develop automated and manual tests ensuring data quality, completeness, and correctness across Snowflake environments.
- Validate model integrity and precision
- Collaborate with product owners, data engineers, and business users to define acceptance criteria and coordinate UAT.
- Integrate testing within CI / CD pipelines and orchestrations via Dagster.
- Manage defect tracking, error logging, and reporting frameworks.
- Set up test environments and prepare data for validation scenarios.
- Provide recommendations to improve product quality and testing processes.
Skill Set Needed
Experience across multiple testing types : unit, integration, system, UAT.Data Validation expertise : Testing data complentess, validate row counts, duplicate detectionExpertise in data validation techniques particularly in cloud data warehouse contexts.Proficient in SQL and Python for test scripting and automation.Familiarity with DBT test frameworks and CI / CD pipelines.Knowledge of orchestration tools such as Dagster and embedding tests into workflows.Strong analytic and communication skills for cross-team collaboration.Familiarity with testing best practices, test automation standards, and quality assurance methodologies.Dimensional Model testing, validating Json formats and dataAzure integration TestingDefect tracking and reporting