Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Amit Mathur

Amit Mathur

Senior Quality Assurance Lead
Pune

Summary

I am a Quality Assurance Lead with total experience of 12+ years in end to end test management projects. I have worked on ETL Testing, Datawarehouse Testing, Database Testing, API Testing using Manual and Automation methods.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
3
3
Certifications

Work History

Technical Test Lead

Infosys
06.2016 - Current
  • Lead team of 8-10 QAs towards delivering quality product with no major issues and in reduced delivery time using automation as well as manual testing.
  • Helped team in understanding business requirements and creating test scenarios and test cases for complete coverage of functionality.
  • Sourced heterogenous sources and loaded them in databases with maximum correctness.
  • Performed data analysis and testing between source and targets to ensure that all business logic and transformations are applied correctly.
  • Data validation is done using queries created in SQL Database language. This involved joining multiple tables and databases and applying business logic in queries.
  • Once the data comparison is done, making intelligent and informed decision about the test outcome and making sure that any observation arising out of the mismatches between source data and data warehouse does not occur again.

ETL Test Lead

Cognizant
12.2012 - 02.2016
  • Business and Requirement Understanding: Understanding the High Level Design and Low Level Design.
  • Test Planning: Analyzing the test scenarios based on HLD and preparing test cases around those test scenarios.
  • Designing Test Cases: Preparing the test cases as per the ETL flow for the project which workflow execution, data load and data validation.
  • Quality Centre set up: Creating the folder structure on Quality Centre and uploading the test cases in Quality Center tool on those folders and executing the test cases in Quality Center.
  • ETL Testing which involves all the activities like data cleansing, data quality checks, data comparison etc using SQL queries and UNIX file validations
  • Change Data Capture: Performing CDC (Change Data Capture) checks. CDC is a method to analyze multiple logical day data and check for Insert/Update/Delete records.
  • Performed automation activities using UNIX scripts and Teradata macros.

Education

Bachelor of Engineering - IT

Shri Vaishnav Institute of Technology And Science
Indore
06.2004 - 05.2008

Skills

    ETL Testing

    Database Testing

    API Testing

    Performance Testing

    Data warehouse Testing

    GIT, Test Rail, Bit Bucket

Certification

Microsoft Certified: Power BI Data Analyst Associate

Timeline

Microsoft Certified: Power BI Data Analyst Associate

07-2024

Certified Associate In Python Programming

03-2020

ISTQB

03-2018

Technical Test Lead

Infosys
06.2016 - Current

ETL Test Lead

Cognizant
12.2012 - 02.2016

Bachelor of Engineering - IT

Shri Vaishnav Institute of Technology And Science
06.2004 - 05.2008

Similar Profiles

CREATE PROFILE
Amit MathurSenior Quality Assurance Lead