Job Description

We are looking for an experienced ETL Test Engineer with solid expertise in ETL Testing, Data Warehouse Testing, SQL, and Source-to-Target Validation. The candidate will be responsible for validating ETL processes, ensuring data quality, and performing end-to-end testing of enterprise data warehouse solutions.

Mandatory Skills

- ETL Testing
- SQL
- Data Warehouse Testing
- Source-to-Target Validation
- Data Validation

Key Responsibilities

- Perform end-to-end ETL Testing and Data Warehouse Testing.
- Validate source-to-target mappings and transformation logic.
- Execute data validation, data reconciliation, and data quality checks.
- Validate Fact and Dimension tables.
- Perform Full Load, Incremental Load, and CDC validations.
- Create and execute ETL test cases and test scenarios.
- Analyze ETL mappings, workflows, and business requirements.
- Execute backend/database testing using SQL queries.
- Defect logging, tracking, and reporting using JIRA.
- Collaborate with developers, business analysts,



and data engineering teams.
- Support UAT, regression, and production validation activities.

Preferred Skills

- Informatica PowerCenter
- SSIS
- Talend
- Azure Data Factory (ADF)
- Azure Databricks
- Snowflake
- Oracle SQL
- SQL Server
- AWS Redshift
- GCP BigQuery
- Data Reconciliation
- Data Migration Testing
- Fact & Dimension Validation
- SCD Type 1 & Type 2 Validation
- Metadata Validation
- CDC Validation
- Unix/Linux
- Power BI / Tableau Testing
- Python / PySpark
- Agile Scrum

Preferred Candidate Profile

- Current ETL Tester / ETL QA Engineer / ETL Test Engineer.
- Strong SQL and Data Validation experience.
- Experience in Banking, Healthcare, Insurance, or Financial domains preferred.
- Excellent analytical and problem-solving skills.

Education

- BE / BTech
- ME / MTech
- MCA
- MSc
- BSc (Computer Science / IT)

📌 ETL Test Engineer (Hyderabad)
🏢 Infosys
📍 Hyderabad