ETL Test Engineer – Data Warehouse, SQL, Database Testing & Python

Overview

ETL Test Engineer focused on validating data warehouse, database testing, and basic Python scripting to ensure end-to-end data accuracy and integrity.

What you'll do

• Validate ETL workflows, data migrations, transformations, and loading across source, staging, warehouse, and target systems.
• Perform source-to-target data validation and reconciliation for completeness, consistency, and integrity.
• Design, develop, and execute ETL test cases, scenarios, scripts, and test data.
• Conduct database testing using complex SQL queries, joins, and stored procedures.
• Prepare test plans, test strategies, traceability records, and execution approaches.
• Run regression, integration, system, migration, and data quality testing across the delivery lifecycle.
• Identify, track, and report defects using test management and defect tracking tools.

What you'll need

• 5–8 years of experience in ETL testing, data warehouse testing, database testing, or related QA roles.
• Hands-on experience with an ETL tool such as Informatica, Talend, SSIS, or DataStage.
• Strong SQL skills including complex queries, joins, subqueries, stored procedures, and data validation scripts.
• Basic Python knowledge for scripting, test automation support, and data validation/comparison.
• Experience preparing test plans, test strategies, test cases, test scenarios, test scripts, execution reports, and defect documentation.
• Experience using defect tracking/test management tools such as JIRA, ALM, or Azure DevOps.

Details

• Location: Bengaluru - Bellandur (GTP).
• Role is for the Bangalore team.