Test Lead (IN)
HCLTech
HCLTech
Seeking a motivated ETL Test Engineer with significant experience in Banking and Financial Services projects. This role demands expertise in ETL testing, advanced SQL, Data Warehouse testing, and comprehensive database validation across large-scale data environments.
This position offers an opportunity to contribute to critical data projects within the finance sector, ensuring data integrity and performance. We value a proactive approach to problem-solving and a commitment to delivering high-quality testing solutions.
Key responsibilities include performing comprehensive ETL and Data Warehouse testing for banking and financial applications. You will validate source-to-target data mappings and transformation logic, design and execute test cases for batch data loads and ETL workflows, and develop/execute SQL queries for data validation and reconciliation.
Additional duties involve identifying data quality issues and conducting root cause analysis, collaborating effectively with business analysts, developers, and data engineers, and actively participating in defect tracking and test reporting activities. Your contribution will be vital in maintaining the accuracy and reliability of our data systems.
Essential qualifications include proven experience in creating and executing ETL test cases, test scenarios, and SQL-based data validation scripts, coupled with strong SQL writing and query optimization skills. Proficiency with ETL tools such as Informatica or DataStage, and hands-on expertise in Oracle DB for data integration and management are required.
Candidates must possess strong analytical, problem-solving, and solution design skills, along with experience managing and leading technical teams in large-scale projects. A Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline is necessary. Familiarity with Oracle, MySQL, SQL Server, PostgreSQL, Teradata, DB2, and Shell Scripting is essential. Experience with ETL tools like Informatica, DataStage, Talend, SSIS, Ab Initio, or similar is also a prerequisite, alongside a solid understanding of data validation, migration, and reconciliation.
While not mandatory, exposure to cloud data platforms like AWS, Azure, GCP, and Unix/Linux commands would be beneficial.
HCLTech
IT Consulting