ETL Tester

As an ETL Tester with advanced SQL and Python skills, your role will involve designing, developing, and executing comprehensive ETL test cases and scenarios. You will be responsible for writing and optimizing advanced SQL queries for data validation, transformation, and troubleshooting. Additionally, collaborating with development teams to understand business and data transformation requirements, validating large volumes of data across multiple sources and targets using advanced SQL, developing automation scripts in Python for ETL testing and process streamlining, analyzing, reporting, and tracking defects, recommending solutions, and participating in Agile/Scrum processes throughout the test life cycle. Key Responsibilities: - Design, develop, and execute comprehensive ETL test cases and scenarios - Write and optimize advanced SQL queries for data validation, transformation, and troubleshooting - Collaborate with development teams to understand business and data transformation requirements - Validate large volumes of data across multiple sources and targets using advanced SQL - Develop automation scripts in Python for ETL testing and process streamlining - Analyze, report, and track defects; recommend solutions - Participate in Agile/Scrum processes and provide expertise throughout the test life cycle Required Skills & Qualifications: - 3+ years of hands-on experience in ETL testing or related roles - Strong command of advanced SQL (complex joins, window functions, query optimization, data analysis) - Proficiency in Python for scripting and automation - Experience with ETL tools (e.g., Informatica, Talend, DataStage, SSIS) is a plus - QA professionals or Data/ETL developers with hardcore SQL expertise are welcome - Ability to troubleshoot, analyze, and validate large datasets - Excellent communication and interpersonal skills - Bachelor's degree in Computer Science, Information Technology, or related field,