SQL Tester

Key Responsibilities

Data Validation

Write SQL queries to check source vs. target data.

Validate CRUD operations (Create, Read, Update, Delete).

Ensure data completeness & correctness after migrations.

ETL Testing

Validate transformations, aggregations, joins, and filters.

Check row counts, duplicate data, and null handling.

Test incremental loads (daily, weekly).

Database Testing

Verify indexes, constraints, triggers, stored procedures.

Check performance of queries (execution plans, indexing).

Validate transactions & rollback scenarios.

Automation

Use Python/Java + PyTest/JUnit for automated SQL validations.

Integrate with CI/CD (Jenkins, GitHub Actions).

Required Skills

SQL (Core skill)

Joins, Subqueries, Window functions, CTEs.

Database Systems

Oracle, MySQL, PostgreSQL, SQL Server, Teradata, Snowflake, Redshift.

ETL & Data Warehousing Concepts

Fact & dimension validation.

Slowly Changing Dimensions (SCDs).

Testing Tools

JIRA, HP ALM, Selenium (for UI + backend testing).

Programming Basics

Python / Shell scripting for automation.