Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Generic

Shubham Bhardwaj

Quality Assurance Tester
Greater Noida

Summary

  • 7 Plus years of experience in ETL/BI/QA testing.
  • Good Understanding of QA and Banking, Payments, Telecom & Insurance domain.
  • KT Documentation and Providing KT for the new resources joined.
  • Develop Test strategy, Test plan, and execution of testing with good understanding of mapping document.
  • Feasibility analysis and impact assessment of the solution on the overall business Tested Power BI Reports with the backend database.
  • Experience in Duck Creek Technologies.
  • Experience in working with management tool- JIRA, Rally, Azure DevOps.
  • Experience in writing & executing the test cases.
  • Having Good Knowledge on Data warehouse Architecture and concepts
  • Experience in software Development Life cycle like debugging, testing, maintenance and Designing.
  • Experience in manual testing with writing SQL queries
  • Experience in dealing clients and understanding the requirements and providing the support.
  • Having Knowledge in QC and JIRA tool.
  • Experience in Writing SQL Scripts based on the logics mentioned in mapping document.
  • Experience in working with Database - SQL Server, Oracle, Big Query, GCP, Snowflake
  • Experience in Agile Methodology of testing.

Overview

8
8
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
2
2
Languages

Work History

Senior Test Engineer - QA

Coforge
Greater Noida
02.2024 - Current
  • Work closely with software developers/project owners/Business Analyst to get the requirements to develop and execute through test.
  • Working on Duck Creek Technologies and Suites in all phases of the STLC & SDLC.
  • Develop Test strategy, Test plan, execute test cases and defect management for the ETL.
  • Whole sole responsibility for loading and execution of data in Clarity-Snowflake under Data Insights.
  • Regression test cases, documentation and providing KTs.
  • Analyze and understand the ETL work flow developed and do the execution and validation of all parts of Insurance like Policy, Billing and Claims.
  • Analyzing the Requirement documents and Mapping Documents and involved in designing test scripts using SQL.

Consultant – ETL Testing

Capgemini
Pune
02.2022 - 11.2023
  • Work closely with software developers/project owners to develop and execute through test Suites in all phases of the software development cycle.
  • Develop Test strategy, Test plan, execute test cases and defect management for the ETL & BI systems.
  • Develop and execute detailed ETL related functional, performance, integration and Regression test cases, and documentation.
  • Analyze and understand the ETL work flow developed.
  • Verified session logs to identify the errors occurred during the ETL execution.
  • Analyzing the Requirement documents and Mapping Documents and involved in designing testscripts using SQL.
  • Work closely with software developers/project owners to develop and execute through test Suites in all phases of the software development cycle.
  • Develop Test strategy, Test plan, execute test cases and defect management for the ETL & BI systems.
  • Develop and execute detailed ETL related functional, performance, integration and Regression test cases, and documentation.
  • Analyze and understand the ETL work flow developed.
  • Verified session logs to identify the errors occurred during the ETL execution.
  • Worked with on-site and off-site quality assurance team to coordinate testing.
  • Analyzing the Requirement documents and Mapping Documents and involved in designing testscripts using SQL.
  • Provide KTs for new resource joined.

Engineer (QA-Tester)

Bharat Seats Ltd.
Gurgaon
11.2017 - 01.2022
  • Analyzing the Requirement documents and Mapping Documents and involved in designing testscripts using SQL.
  • Verifying the ETL data in target Tables based on the mapping between source and targetTables.
  • Involved in different phases of Software Testing Life Cycle Requirement Analysis, Test CaseDesign, Test Execution, Regression and Defect Management.
  • Good Knowledge on advanced SQL on both SQL Server and Teradata.
  • Usage of complex aggregate Functions, analytical functions etc.
  • Extensively written SQL Queries based on the mapping/business logics used on source tables to confirm the data transfer from source to Staging and Staging to Datawarehouse.
  • Good with the inbuilt functions of Teradata and SQL Server.
  • Worked with on-site and off-site quality assurance team to coordinate testing.
  • Analyzing the Requirement documents and Mapping Documents and involved in designing testscripts using SQL.
  • Working closely with the business analyst for all the clarifications on requirements.
  • Verifying the ETL data in target Tables based on the mapping between source and targetTables.
  • Executing the Difference ETL Testing Scenarios in Target Database and performed Root Cause Analysis for each issue identified in execution.
  • Reporting the identified issues to developers.
  • Active participation in Peer Review of Test Scripts.
  • Methodolgies- Agile (Scrum)

Education

Bachelor Of Technology -

Uttar Pradesh Technical University (UPTU)
Noida
01.2011 - 01.2015

Skills

  • Power BI

  • ETL Testing

  • Application Testing

  • SQL

  • Regression Testing

  • Quality Assurance

  • Snowflake

  • Google Cloud Platform

  • Duck Creek

  • Agile Methodology

  • Azure DevOps

  • JIRA

Certification

Agile with Atlassian Jira, Coursera

Personal Information

Date of Birth: 09/18/94

Timeline

Senior Test Engineer - QA

Coforge
02.2024 - Current

Consultant – ETL Testing

Capgemini
02.2022 - 11.2023

Engineer (QA-Tester)

Bharat Seats Ltd.
11.2017 - 01.2022

Bachelor Of Technology -

Uttar Pradesh Technical University (UPTU)
01.2011 - 01.2015

Similar Profiles

CREATE PROFILE
Shubham BhardwajQuality Assurance Tester