Drive QA planning, estimation, defect governance, and Root Cause Analysis (RCA) for production issues. Coordinate with developers, product owners, and stakeholders to ensure release readiness and alignment with business requirements. Led QA activities encompassing Snowflake, Azure Data Factory, Power BI, and API services, ensuring comprehensive test coverage and adherence to stringent quality standards. Engineered code-driven API and ETL automation frameworks using Python, Pytest, and the Requests library, incorporating Pandas and PySpark DataFrames for end-to-end data reconciliation against backend SQL databases. Led and mentored a team of 6 QA engineers, performing test case reviews, sprint planning, and QA task allocation. Performed end-to-end data reconciliation across source, staging, and reporting layers ensuring 100% data accuracy. Designed and executed SQL queries for data reconciliation, transformation validation, and large-scale dataset verification across Snowflake environments. Introduced AI-assisted approaches using GitHub Copilot and LLM tools to enhance SQL query development, test design, and defect analysis efficiency. Verified environment setup, software versions, and database connectivity to ensure systems were installed and configured according to requirements. Validated data across multi-layer architecture including landing, transformation (Silver), and reporting (Gold) layers. Validated incremental and full-load ETL data ensuring accuracy across daily data refresh cycles. Contributed to faster delivery cycles, resulting in timely product releases and increased customer satisfaction. Improved data accuracy by implementing structured reconciliation across ETL pipelines. Improved test coverage and efficiency through strategic test planning and resource allocation. Delivered QA for 50+ Power BI dashboards ensuring accurate KPIs and reporting. Reduced regression effort through optimized test planning and execution. Successfully led and mentored a team of QA engineers across multiple projects, fostering a culture of excellence and collaboration.
