R Systems
Website:
rsystems.com
Job details:
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
(ref:hirist.tech)
Click on Apply to know more.