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