HCLTech—Senior Tester

Job description

Description: Job Summary We are looking for a highly motivated ETL Test Engineer with strong experience in Banking and Financial Services projects. The candidate should have expertise in ETL testing, strong SQLKnowledge, Data Warehouse testing, and database validation across large-scale data platforms. Key Responsibilities Perform ETL testing and Data Warehouse testing for banking and financial applications. Validate source-to-target data mappings and transformation logic. Design and execute test cases for batch data loads and ETL workflows. Develop and execute SQL queries for data validation and reconciliation. Identify data quality issues and perform root cause analysis. Collaborate with business analysts, developers, and data engineers. Participate in defect tracking and test reporting activities. Mandatory Skills Experience in creating and executing ETL test cases, test scenarios, and SQL-based data validation scripts. Strong SQL writing and query optimization skills. Exposure with Any ETL Tools (such as Informatica, DataStage Designer, or equivalent). Hands-on expertise in Oracle DB for data integration and management. Strong analytical, problem-solving, and solution design skills. Bachelor's or master's degree in computer science, Information Technology, Engineering, or a related discipline. Banking or Financial Services domain experience. Experience with one or more databases: Oracle MYSQL SQL Server PostgreSQL Teradata DB2 Shell Scripting Experience in Any ETL tools such as Informatica, DataStage, Talend, SSIS, Ab Initio, or similar. Understanding of data validation, data migration, and data reconciliation. Good to Have Exposure to cloud data platforms like AWS, Azure, GCP Unix/Linux commands. Skill Requirements DB/ETL/Datawarehousing/Data Stage Other Requirements Strong SQL+Control M+Hadoop+ Banking domain+Shell Scripting