ETL Data Testing

ETL Data Test Engineer / Senior ETL Data Tester

Experience

6 to 14 Years

Location

Bangalore Whitefield

Notice Period

0 to 60 Days

Role Overview

We are looking for an experienced ETL Data Testing professional with 6–14 years of experience in data warehouse testing, ETL validation, data quality, and database testing. The candidate should have strong experience in validating data pipelines, source-to-target mappings, data transformations, reconciliation, and end-to-end data flows.

The role requires close collaboration with Data Engineers, ETL Developers, Business Analysts, and Data Architects to ensure data accuracy, completeness, consistency, and integrity across enterprise data platforms.

Key Responsibilities

• Design and execute ETL and Data Warehouse testing strategies and test cases.
• Validate source-to-target data mappings, transformations, business rules, and data loads.
• Perform data validation, data reconciliation, data integrity, and data quality testing.
• Write and execute complex SQL queries for data validation and backend testing.
• Validate ETL workflows, jobs, pipelines, incremental loads, full loads, and CDC processes.
• Perform database testing across source and target systems.
• Identify, analyze, document, and track data defects through to resolution.
• Validate data across multiple layers including staging, ODS, data warehouse, and reporting layers.
• Perform functional, regression, integration, system, and end-to-end testing.
• Validate data transformations, aggregations, joins, lookups, filters, and calculations.
• Verify data completeness, accuracy, consistency, uniqueness, and referential integrity.
• Work with developers and data engineers to troubleshoot data discrepancies and pipeline failures.
• Develop and maintain automated data testing frameworks where applicable.
• Participate in test planning, estimation, execution, defect management, and reporting.
• Analyze source systems and understand data models, schemas, and data lineage.
• Support testing of cloud-based and modern data platforms where required.

Mandatory Technical Skills

• ETL Testing
• Data Warehouse Testing
• SQL
• Database Testing
• Data Validation
• Data Reconciliation
• Source-to-Target Testing
• Data Quality Testing
• Strong understanding of ETL concepts and data warehousing
• Experience with complex SQL queries
• Good understanding of Fact and Dimension tables
• Knowledge of Star Schema / Snowflake Schema
• Experience with test case design and execution
• Defect tracking and test management

ETL Tools – Good to Have

Experience with one or more of the following:

• Informatica
• Azure Data Factory
• Databricks

Database / Data Platform Skills

Experience with one or more:

• Oracle
• SQL Server
• PostgreSQL
• MySQL
• Teradata
• Snowflake
• Databricks
• BigQuery
• Redshift

Automation – Good to Have

• Python
• PySpark
• Selenium / API testing exposure
• Data testing automation
• ETL automation frameworks
• CI/CD exposure
• Jenkins / Git

Key Testing Areas

The candidate should have hands-on experience in:

• ETL Testing
• Data Warehouse Testing
• Source-to-Target Validation
• Data Migration Testing
• Data Reconciliation
• Data Quality Testing
• Data Completeness Testing
• Data Integrity Testing
• Data Transformation Testing
• Regression Testing
• Integration Testing
• End-to-End Testing
• Backend Testing
• Database Testing
• Batch Job Testing
• Incremental Load Testing
• Full Load Testing
• CDC Testing
• Data Pipeline Testing

Required Skills

Mandatory:

• ETL Data Testing
• Data Warehouse Testing
• SQL
• Database Testing
• Source-to-Target Validation
• Data Reconciliation
• Data Quality
• ETL Concepts
• Data Warehousing
• Test Case Design
• Defect Management

Good to Have:

• Informatica
• Databricks
• Cloud Data Platforms
• Python / PySpark
• Data Testing Automation
• CI/CD
• Agile / Scrum

Candidate Profile

• 6–14 years of overall experience in ETL/Data Testing or Data Warehouse Testing.
• Strong hands-on experience in SQL and backend data validation.
• Strong understanding of ETL processes, data warehousing, and data models.
• Experience working with large datasets and complex data pipelines.
• Ability to independently analyze data discrepancies and identify root causes.
• Strong communication and analytical skills.
• Experience working in Agile development environments is preferred.

Location

Whitefield, Bangalore

Notice Period

Immediate Joiners to 60 Days

Preference: Candidates who can join within 0–60 days.