SQL Data Tester

Job Description

Key Responsibilities

•            Design and develop automated SQL test cases to validate data transformations and data quality.

•            Perform end-to-end testing of ETL processes, primarily using SSIS and other Microsoft BI tools.

•            Collaborate with developers and analysts to understand data requirements and ensure test coverage.

•            Integrate testing into CI/CD pipelines to support continuous delivery and deployment.

•            Identify, document, and track defects and inconsistencies in data.

•            Contribute to test automation strategies and reusable SQL test frameworks.

________________________________________

Required Skills & Qualifications

•            Strong experience in Automated SQL testing with a focus on data validation and transformation logic.

•            Proficiency in ETL testing, particularly with SSIS.

•            Experience working in CI/CD environments and integrating tests into automated pipelines.

•            Solid understanding of relational databases and data warehousing concepts.

•            Excellent analytical and problem-solving skills.

________________________________________

Nice to Have

•            Experience with tSQLt for unit testing SQL Server code.

•            Familiarity with Azure Data Factory (ADF) and cloud-based data integration.

•            Knowledge of SQL linting tools and best practices for SQL code quality.

•            Exposure to Agile/Scrum methodologies.