Database Test Engineer / ETL Tester / SQL QA Engineer

Consult Asia; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Consult Asia is seeking a data testing specialist to verify SQL queries, ETL workflows, and DWH loads in complex data environments.

The role emphasizes validating large datasets, understanding DB schemas, and hands-on experience with Informatica, SSIS, Talend, and Snowflake to ensure data quality and accurate reporting.

Qualifications

• Proficient in writing complex SQL queries and validating data flows.
• Experience in ETL/DWH testing and validating large datasets.
• Good understanding of DB schemas and data quality concepts.
• Hands-on in ETL tools such as Informatica, SSIS, Talend, and Snowflake.

Responsibilities

• Write complex SQL queries to validate data movement and transformations.
• Validate ETL workflows and perform data quality checks.
• Test stored procedures and compare source vs target data.
• Verify data warehouse loads and document test results.

Skills

SQL

ETL testing

Data quality

DB schemas

DWH testing

Informatica

SSIS

Talend

Snowflake

Tools

Informatica

SSIS

Talend

Snowflake

Job description

Write complex SQL queries, validate ETL workflows, perform data quality checks, test stored procedures, compare source vs target data, validate DWH loads, identify defects, ensure consistency, and document test results.

Required Candidate profile

Strong SQL skills, experience in ETL/DWH testing, ability to validate large datasets, good understanding of DB schemas, data quality, and hands‑on in ETL tools like Informatica/SSIS/Talend/Snowflake.