ETL Testing / Data Warehouse Testing / Big Data Testing
Experience: 4 to 8 Years
Location: Hydrabad
Key Responsibilities
Analyze business requirements, Source-to-Target (S2T) mappings, and data models.
Design and execute ETL test cases, test plans, test scenarios, and test strategies.
Validate ETL workflows, mappings, transformations, and data pipelines.
Perform Source-to-Target validation and Data Reconciliation testing.
Execute Database Testing using complex SQL queries.
Validate data quality, completeness, consistency, accuracy, and integrity.
Perform Data Warehouse (DWH), Data Migration, and BI/Reporting testing.
Validate Fact Tables, Dimension Tables, Star Schema, and Snowflake Schema.
Verify Full Load, Incremental Load, Batch Processing, and Scheduling Jobs.
Identify, log, track, and retest defects using JIRA/ALM/Azure DevOps.
Collaborate with Developers, Business Analysts, and Data Engineers to resolve issues.
Perform End-to-End Testing across ETL, DWH, and Reporting settings.
Participate in Agile/Scrum ceremonies.
Mandatory Skills
4 to 8 years of experience in ETL Testing and Data Warehouse Testing.
Strong expertise in writing and validating complex SQL queries.
Hands-on experience with Informatica, DataStage, Talend, SSIS, Ab Initio, Pentaho or similar ETL tools.
Experience in Source-to-Target Validation, Data Reconciliation, Data Validation, and Transformation Validation.
Solid understanding of ETL workflows, mappings, and business transformation rules.
Knowledge of Data Warehousing Concepts, Fact & Dimension Tables, Star Schema, Snowflake Schema.
Experience with databases such as Oracle, SQL Server, Teradata, Snowflake, PostgreSQL, MySQL, DB2.
Experience in Full Load and Incremental Load Testing.
Solid experience with JIRA, HP ALM, Rally, Azure DevOps.
Good understanding of SDLC, STLC, and Agile methodologies.
Preferred Skills
Big Data Testing using Hadoop, Hive, HDFS, Spark, Databricks, PySpark.
Exposure to Azure, AWS, or GCP.
Experience with Azure Data Factory (ADF), Azure Synapse, Snowflake, Redshift, Data Lake environments.
Data Migration and Cloud Migration Testing.
BI Testing using Power BI, Tableau, Cognos, Business Objects, MicroStrategy.
Python or Shell Scripting for ETL validation and automation.
📌 Etl Tester Hyderabad (India)
🏢 Infosys
📍 India