ETL Testing Engineer

Job Title

ETL Testing Engineer / ETL QA Analyst

Experience

1-13 Years

Job Location

As per business requirement

Job Summary

We are seeking a detail-oriented ETL Testing Engineer with strong experience in Data Warehouse (DWH), ETL processes, and database testing. The candidate will be responsible for validating data extraction, transformation, and loading processes, ensuring data accuracy, completeness, and integrity across source and target systems.

Key Responsibilities
- Analyze business requirements, data models, source-to-target mappings, and ETL specifications.
- Design and develop ETL test strategies, test plans, test cases, and test scenarios.
- Validate data extraction, transformation, and loading processes.
- Perform source-to-target data validation and reconciliation.
- Execute database testing using SQL queries.
- Identify, document, track, and resolve data quality issues and defects.
- Verify data integrity, data completeness, and data consistency.
- Perform regression, integration, system, and performance testing for ETL workflows.




- Validate data warehouse and data mart implementations.
- Collaborate with ETL developers, business analysts, and data architects.
- Participate in test execution cycles and provide status reports.
- Ensure compliance with data governance and data quality standards.

Required Skills

Technical Skills
- Strong experience in ETL Testing and Data Warehouse Testing.
- Excellent SQL skills with experience in:
- Complex joins
- Stored procedures
- Views
- Functions
- Data validation queries
- Experience with ETL tools such as:
- Informatica
- Talend
- DataStage
- SSIS
- Azure Data Factory (ADF)
- AWS Glue
- Solid understanding of:
- Data Warehousing concepts
- Star Schema
- Snowflake Schema
- Fact and Dimension Tables
- Experience in Data Quality Testing.
- Knowledge of Unix/Linux commands.
- Exposure to API and file validation testing (CSV, XML, JSON).

Database Skills
- Oracle
- SQL Server
- PostgreS

📌 Etl Testing Engineer-Panindia-1-13 yrs (Bengaluru)
🏢 Infosys
📍 Bengaluru