Etl Tester (Hyderabad)

Etl Tester (Hyderabad)

20 Nov
|
Infosys
|
Hyderabad

20 Nov

Infosys

Hyderabad

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 environments.
- 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.
- Strong 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)
🏢 Infosys
📍 Hyderabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: etl tester (hyderabad) / hyderabad