Azmat Z.
Senior ETL Testing and QA Lead
Open to offersNew to PlatformAbout
Azmat Z., based in Noida, India, is a seasoned ETL Testing & QA Lead with over a decade of experience in the realms of data validation, database testing, and quality assurance. She has significant expertise in managing data accuracy and compliance on Azure, AWS, and Big Data platforms. Azmat is adept at validating intricate ETL pipelines using tools such as SQL, PySpark, Databricks, and Informatica, specifically across Life Sciences, Media, and Pharma domains. Her current role at Indegene Private Limited involves leading ETL testing using AWS Athena and Amazon S3, crafting data validation strategies and optimizing validation queries for enhanced performance. Her tenure at Tata Consultancy Services saw her spearheading ETL testing on Azure and Databricks, improving ETL efficiency by 40% and reducing discrepancies by 30%. Azmat holds an M.Sc. Tech from Jamia Millia Islamia, complemented by certifications in ITIL and Agile Delivery Foundations.
Experience
Data Validation Lead (ETL QA)
Indegene Private Limited · 2025 — PresentConducted end-to-end ETL testing on large-scale datasets utilizing AWS Athena and Amazon S3. Developed data validation strategies incorporating count checks, null checks, referential integrity checks, and transformation validation. Created Source-to-Target Mapping (STTM) documents detailing transformation logic and validation rules. Ensured consistency and accuracy of ETL workflows based on AWS Glue and Spark SQL. Executed data reconciliation testing between source and target systems. Enhanced performance and cost efficiency of validation queries optimized for Athena. Collaborated with data engineering teams to achieve defect resolution and maintain data quality compliance.Assistant Consultant – ETL Testing / QA Lead
Tata Consultancy Services (TCS) · 2015 — 2025Oversaw ETL testing and data validation for pipelines developed on Azure Data Factory and Databricks. Ensured data transformations aligned with business rules through validation using SQL and PySpark. Developed and implemented test plans, test cases, and test scenarios for ETL workflows and reporting systems. Executed database testing in Azure SQL and SQL Server environments. Performed regression and functional testing for BI reports and data pipelines. Validated the ingestion of data from various sources into Azure Data Lake, maintaining data integrity, completeness, and accuracy. Managed the defect lifecycle in JIRA and facilitated coordination with cross-functional teams using Agile/Scrum methodologies. Supported CI/CD validation and release testing processes while documenting test outcomes and QA reports in JIRA and Confluence.ETL QA Engineer
FedEx · 2024 — 2025Performed validation of data migration from GCP to ATLAS through Databricks and Delta Lake. Conducted data reconciliation and pipeline validation, automating validation checks for ETL workflows.QA Lead (ETL Testing)
Outfront Media Canada · 2023 — 2024Led the QA strategy, planning, and execution for ETL pipelines. Designed comprehensive test cases and ensured thorough data validation coverage. Coordinated with clients and stakeholders during UAT and delivery phases.Data QA Analyst
Vertex Pharmaceuticals · 2017 — 2018Executed clinical data validation and database testing to ensure compliance with regulatory standards and maintained data accuracy for SDTM datasets.
Skills & Expertise
Education
- Master of Science in TechnologyJamia Millia Islamia · — — 2014
- Bachelor of Science in Maths & ScienceDAV College · — — 2011