Test Specialist (IN)
HCLTech
HCLTech
Seeking a skilled ETL Tester to ensure data integrity and accuracy across enterprise data warehouse and analytics platforms. This role involves validating data movement, transformation logic, data quality, and reporting accuracy.
You will collaborate closely with development, business, and QA teams to understand requirements, create test scenarios, execute data validation, and identify defects, ensuring end-to-end data integrity from source to target systems.
Analyze business requirements and design documents to define test scope. Prepare detailed test scenarios, test cases, and SQL validation scripts for ETL and data warehouse testing. Perform source-to-target data validation, checking transformation rules, joins, filters, and aggregations. Execute backend database testing with complex SQL queries and perform data quality checks. Validate various file formats and utilize Unix/Linux commands for file analysis. Identify, log, and track defects using tools like JIRA. Collaborate with cross-functional teams to resolve data issues and support end-to-end testing cycles. Prepare test execution reports and participate in Agile ceremonies.
Requires strong experience in ETL, data warehouse, database testing, and data migration validation. Proficiency in writing complex SQL queries for data validation and root cause analysis is essential. A solid understanding of ETL/ELT concepts, data warehouse architecture, and dimensional modeling is necessary. Experience with databases like Oracle, SQL Server, Teradata, Snowflake, or similar platforms. Familiarity with ETL tools such as Informatica, Azure Data Factory, or Talend. Experience validating batch jobs, file loads, data pipelines, and incremental loads. Working knowledge of Unix/Linux commands for file validation. Proficiency with test management and defect tracking tools like JIRA or Azure DevOps. Understanding of SDLC, STLC, and Agile methodologies.
HCLTech
IT Consulting