Test Specialist (IN)
HCLTech
HCLTech
Seeking an experienced ETL Tester to ensure data accuracy and integrity across enterprise data warehouse and analytics platforms. This role involves collaborating with various teams to understand requirements, design test strategies, execute validation procedures, and pinpoint defects. The focus is on guaranteeing end-to-end data quality from source systems through to target environments.
Analyze business requirements and technical documentation to define test scope. Develop detailed test scenarios, test cases, and SQL validation scripts for ETL and data warehouse testing. Conduct source-to-target data validation, verifying transformation logic, data quality, and consistency across databases and files. Execute backend database testing using complex SQL queries and perform data quality checks for completeness, accuracy, and integrity. Validate various file formats and utilize Unix/Linux commands for file analysis as needed. Identify, document, and track defects using JIRA or similar tools. Work closely with developers and business analysts to resolve data issues and support comprehensive testing cycles. Prepare status reports and participate in Agile ceremonies, including daily stand-ups and sprint planning.
Requires strong hands-on experience in ETL, data warehouse, database testing, and data migration. Must possess excellent SQL skills for complex query writing and data reconciliation. A solid understanding of ETL/ELT concepts, data warehouse architecture, and dimensional modeling is essential. Experience with relational databases like Oracle, SQL Server, Teradata, Snowflake, etc., and ETL tools such as Informatica, Azure Data Factory, or Talend is necessary. Familiarity with validating batch jobs, incremental loads, and scheduled workflows, along with working knowledge of Unix/Linux commands, is expected. Proficiency in test management and defect tracking tools like JIRA or Azure DevOps is required. The ability to perform root cause analysis and communicate findings effectively to technical and business stakeholders is key. A good grasp of SDLC, STLC, and Agile methodologies is also important.
HCLTech
IT Consulting