JOB TITLE : Lead Test Engineer

Location : Noida

Employment Type : Full-Time

ABOUT THE ROLE :

- We are seeking a highly skilled and detail-oriented Lead Test Engineer to join our dynamic team in Noida.

- The ideal candidate will bring strong expertise in ETL testing, data quality validation, and Snowflake-based data platforms, along with hands-on experience in SQL and large-scale data validation.

- In this role, you will be responsible for ensuring 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 :

ETL & Data Testing :

- Lead and execute end-to-end ETL testing activities across data warehousing and analytics platforms.

- Validate ETL workflows, source-to-target 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 (5-6 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 stand-ups, 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 hands-on experience in writing and validating complex SQL queries.

- Strong experience with Snowflake and associated components including SnowSQL, Snowpipe, and stored procedures.

Hands-on 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 problem-solving 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 cloud-based 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 & Problem-Solving Skills

WHY JOIN US ?

- Opportunity to work on large-scale enterprise data platforms and Snowflake ecosystems.

- Exposure to modern data engineering, ETL pipelines, and cloud data environments.

- Collaborative agile work culture with high-impact projects.

- Opportunity to contribute to data quality and reliability in a fast-paced environment