Lead Test Engineer - ETL Testing

As a Lead Test Engineer at our company in Noida, you will play a crucial role in ensuring the integrity, accuracy, and reliability of our enterprise data systems. Your primary responsibilities will include: - Leading and executing end-to-end ETL testing activities across data warehousing and analytics platforms. - Validating ETL workflows, source-to-target mappings, data transformations, and data movement processes. - Designing and executing comprehensive test plans, test cases, and test strategies for data validation. - Performing data reconciliation and verification to ensure completeness, consistency, and accuracy of enterprise datasets. - Validating large datasets, business rules, and complex transformations across multiple systems. - Performing data lineage validation to ensure accurate data flow and traceability. In addition to ETL and Data Testing, you will also be responsible for: - Performing testing and validation on Snowflake data platforms, ensuring performance, integrity, and correctness. - Developing and executing complex SQL queries for data verification and validation. - Ensuring adherence to enterprise data quality standards and governance frameworks. - Working with data quality tools and frameworks such as DBT, Great Expectations, and equivalent data validation frameworks. - Collaborating within agile squads to ensure continuity, domain alignment, and quality assurance throughout the development lifecycle. - Managing defect tracking, test execution, and reporting using JIRA or equivalent tools. - Supporting continuous integration and continuous testing practices in modern data environments. - Maintaining detailed testing documentation, defect reports, and validation records. To excel in this role, you should possess: - 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. - Experience working with Data Quality frameworks such as DBT, Great Expectations, or similar tools. - Familiarity with Agile methodologies and embedded squad models. - Excellent analytical and problem-solving skills with high attention to detail and data accuracy. - Strong verbal and written communication skills. Preferred qualifications include experience in the US Healthcare domain, leading testing initiatives, and working in cloud-based data ecosystems. By joining our team, you will have the opportunity to work on large-scale enterprise data platforms, collaborate on high-impact projects, and contribute to data quality and reliability in a fast-paced environment. As a Lead Test Engineer at our company in Noida, you will play a crucial role in ensuring the integrity, accuracy, and reliability of our enterprise data systems. Your primary responsibilities will include: - Leading and executing end-to-end ETL testing activities across data warehousing and analytics platforms. - Validating ETL workflows, source-to-target mappings, data transformations, and data movement processes. - Designing and executing comprehensive test plans, test cases, and test strategies for data validation. - Performing data reconciliation and verification to ensure completeness, consistency, and accuracy of enterprise datasets. - Validating large datasets, business rules, and complex transformations across multiple systems. - Performing data lineage validation to ensure accurate data flow and traceability. In addition to ETL and Data Testing, you will also be responsible for: - Performing testing and validation on Snowflake data platforms, ensuring performance, integrity, and correctness. - Developing and executing complex SQL queries for data verification and validation. - Ensuring adherence to enterprise data quality standards and governance frameworks. - Working with data quality tools and frameworks such as DBT, Great Expectations, and equivalent data validation frameworks. - Collaborating within agile squads to ensure continuity, domain alignment, and quality assurance throughout the development lifecycle. - Managing defect tracking, test execution, and reporting using JIRA or equivalent tools. - Supporting continuous integration and continuous testing practices in modern data environments. - Maintaining detailed testing documentation, defect reports, and validation records. To excel in this role, you should possess: - 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. - Experience working with Data Quality frameworks such as DBT, Great Expectations, or similar tools. - Familiarity with Agile methodologies and embedded squad models. - Excellent analytical and problem-solving skills with high attention to d