Lead Test Engineer - ETL Testing

Job Title Lead Test Engineer Location Noida Employment Type FullTime About The Role We are seeking a highly skilled and detailoriented Lead Test Engineer to join our dynamic team in Noida. The ideal candidate will bring strong expertise in ETL testing, data quality validation, and Snowflakebased data platforms, along with handson experience in SQL and largescale data validation. In this role, you will ensure the integrity, accuracy, and reliability of enterprise data systems by validating complex ETL pipelines, data transformations, and data lineage processes. You will work closely with agile squads, data engineers, business stakeholders, and development teams to maintain high standards of data quality and testing excellence. Candidates with prior exposure to the US Healthcare domain and modern data quality frameworks will be highly preferred. Key Responsibilities Lead and execute endtoend ETL testing activities across data warehousing and analytics platforms. Validate ETL workflows, sourcetotarget mappings, data transformations, and data movement processes. Design and execute comprehensive test plans, test cases, and test strategies for data validation. Perform data reconciliation and verification to ensure completeness, consistency and accuracy of enterprise datasets. Validate large datasets, business rules and complex transformations across multiple systems. Perform data lineage validation to ensure accurate data flow and traceability. Snowflake Testing & SQL Validation Perform testing and validation on Snowflake data platforms, ensuring performance, integrity and correctness. Develop and execute complex SQL queries for data verification and validation. Validate Snowflake Components Including SnowSQL Snowpipe processes Stored procedures Data ingestion and transformation pipelines Identify and troubleshoot data inconsistencies, anomalies and performance issues. Data Quality & Automation Ensure adherence to enterprise data quality standards and governance frameworks. Work with data quality tools and frameworks such as: DBT (Data Build Tool) Great Expectations Equivalent data validation frameworks Implement automated validation approaches for improving testing efficiency and reducing manual effort. Monitor and improve data quality metrics and reporting. Agile Collaboration & Stakeholder Management Work within agile squads (56 members) as an embedded QA to ensure continuity, domain alignment and quality assurance throughout the development lifecycle. Collaborate Closely With Data Engineers Developers Product Teams Business Analysts QA Teams Participate in sprint planning, backlog grooming, daily standups, retrospectives, and release activities. Provide testing insights, defect analysis and quality recommendations to stakeholders. Test Management & DevOps Collaboration Manage defect tracking, test execution and reporting using JIRA or equivalent tools. Work with CI/CD pipelines and version control systems such as: Git Bitbucket Support continuous integration and continuous testing practices in modern data environments. Maintain detailed testing documentation, defect reports and validation records. Required Skills & Qualifications Strong QA experience in Data Warehousing and ETL Testing. Expertise in SQL with strong handson experience in writing and validating complex SQL queries. Strong experience with Snowflake and associated components including SnowSQL, Snowpipe and stored procedures. Handson Experience Validating Large datasets Data transformations Data lineage ETL pipelines Experience working with Data Quality frameworks such as DBT, Great Expectations or similar tools. Familiarity with Agile methodologies and embedded squad models. Working Knowledge Of CI/CD processes Git / Bitbucket JIRA for defect and test management Excellent analytical and problemsolving skills with high attention to detail and data accuracy. Strong verbal and written communication skills. Preferred Qualifications Experience in the US Healthcare domain with understanding of healthcare datasets such as: Patient Demographics Encounters Claims Data Healthcare Data Models Prior experience leading testing initiatives or functioning as a Test Lead in enterprise data programs. Experience in cloudbased data ecosystems and modern data engineering environments. Key Competencies ETL Testing Snowflake Testing SQL & Data Validation Data Warehousing QA Data Quality Frameworks (DBT, Great Expectations) Data Lineage Validation CI/CD & Agile QA Practices Defect Management (JIRA) US Healthcare Domain Knowledge Analytical & ProblemSolving Skills WHY JOIN US Opportunity to work on largescale enterprise data platforms and Snowflake ecosystems. Exposure to modern data engineering, ETL pipelines and cloud data environments. Collaborative agile work culture with highimpact projects. Opportunity to contribute to data quality and reliability in a fastpaced environment. Job Title Lead Test Enginee