Description

You will focus on validating data transformations and ensuring data quality through automated testing.

Responsibilities

• Design and develop automated SQL test cases to validate data transformations and quality.
• Perform end-to-end testing of ETL processes using SSIS and Microsoft BI tools.
• Collaborate with developers and analysts to define data requirements and ensure test coverage.
• Integrate testing into CI/CD pipelines to support continuous delivery.
• Identify, document, and track defects and data inconsistencies.
• Contribute to test automation strategies and reusable SQL test frameworks.

Required Skills

• 5+ years of experience in automated SQL testing with a focus on data validation.
• Proficiency in ETL testing, specifically using SSIS.
• Experience working in CI/CD environments and integrating tests into automated pipelines.
• Solid understanding of relational databases and data warehousing concepts.
• Strong knowledge of ETL processes and SQL.
• Analytical and problem-solving skills for identifying data discrepancies.
• Any Graduate degree.

Preferred Skills

• 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 Agile/Scrum methodologies.

Key Skills

Education

Any Graduate