SQL Data Tester

Hi

Hope you are doing well

Please look at below mentioned Job Description and share your updated resume and mention your work authorization & Current Location .

If the JD match with your skills.

Title :SQL Data Tester

Location:Remote

Job type:Long Term Contract

Position is 100% remote. Consultants working hours must overlap 3-5 hours with CST time zone.

Skill Priority: SQL testing, ETL, SSIS, and CICD experience

"Nice to Haves": tSQLt, ADF, and SQL Linting experience

Seeking candidates available to start immediately, not seeking candidates with lengthy notice periods. Candidate location and candidate availability/start date should be listed at the top of the resumes.

We are seeking a detail-oriented and highly skilled SQL Tester to join our Data & Analytics team. In this role, you will be responsible for Design and develop automated SQL test cases to validate data transformations and data quality. Validating data integrity, accuracy, and performance across our ETL pipelines and data platforms. You will work closely with data engineers, QA analysts, and DevOps teams to ensure high-quality data delivery in a CI/CD environment.

________________________________________

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.

Thanks & Regards

Pradeep Pathak

Senior Technical Recruiter

KPG99 Inc. |http://www.kpg99.com/

Direct:

Email id: pradeepk@kpgtech.com /pradeep1@kpg.in

LinkedIn:

Address: 3240 E State St EXT , Hamilton, NJ 08619