Scribd
Upload
156 views2 pages

QA Insights in ETL Testing

Vishal Koundal has over 3 years of experience in QA testing including functional, database, and ETL testing. He has worked as a QA Engineer at JR Beta Soft Technologies testing projects using agile, waterfall, and V-model SDLCs. He has expertise writing SQL queries for data validation between source and target systems. One of his projects involved testing the ETL process for Lowe Retail Stores, a large grocery retailer in the US. The project extracted data from different source systems like SQL Server and Excel files and loaded it into an Oracle data warehouse using Informatica. As part of testing, he verified correct data movement between extract, transform, and load layers using SQL queries.

Uploaded by

vishal koundal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
156 views2 pages

QA Insights in ETL Testing

Vishal Koundal has over 3 years of experience in QA testing including functional, database, and ETL testing. He has worked as a QA Engineer at JR Beta Soft Technologies testing projects using agile, waterfall, and V-model SDLCs. He has expertise writing SQL queries for data validation between source and target systems. One of his projects involved testing the ETL process for Lowe Retail Stores, a large grocery retailer in the US. The project extracted data from different source systems like SQL Server and Excel files and loaded it into an Oracle data warehouse using Informatica. As part of testing, he verified correct data movement between extract, transform, and load layers using SQL queries.

Uploaded by

vishal koundal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Introduction

HI GOOD MORNING,

 MY Name is Vishal koundal, I HAVE AROUND 3.10 YEARS OF EXPERIENCE IN TESTING


PLATFORM INCLUDES FUNCTIONAL,DB & ETL TESTING.
 I WORKED AS A QA ENGINEER IN JR BETA SOFT Technologies pvt ltd Noida
 I HAVE GOOD EXPERIENCE IN WORKING WITH PROJECTS USING DIFFERENT SDLC
MODELS LIKE WATERFALL,V-MODEL AND AGILE MODEL.
 I have a EXPERTISE IN WRITING SQL QUERIES FOR DATA VALIDATION BETWEEN SOURCE &
TARGET IN AN HETEROGENOUS PLATFORM SYSTEM.
 I ALSO GOOD AT VALIDATING INTIAL & INCREMENTAL DATA LOADS IN THE ETL
PROJECTS and we follow these 2 types of testing in our project.

 Along with this I Have a STRONG KNOWLEDGE IN DWH CONCEPTS


 GOOD HAND ON INFORMATICA POWER CENTER TOOL.
PROJECT :

 COMING TO MY PROJECT MY PROJECT WAS Lowe Retail Stores .Client location is US.
LOWES is a leader in the grocery retailing industry and it has 2500 stores. It is the largest
Company in the retailing industry.

 IT IS A WEB APPLICATION WHICH IS MAINLY USED FOR GENERATING BUSINESS


REPORTS FOR HIGHER MANAGEMENT used in supply chains operations. It has five modules,
HR & Finance, Retail, EDW & Portal, and Marketing &Merchandising.

 The EDW application in Lowe is supported to load the transactional data and aggregated
data from each department (Sources) in a store in to the Enterprise data ware house using
Oracle.

 THESE SOURCES ARE IN DIFFERENT DATA FORMATS LIKE HR & Finance, EDW & Portal
IS IN SQL SERVER DATABASE, Retail IS IN XL FILES AND Marketing & Merchandising
DATA IS IN NOTEPAD(TAB LIMITED).

 OUR ETL PROJECT WILL EXTRACT THE DATA FROM THESE DIFFERENT SOURCES
INTO STAGING AREA AND THEN TRANSFORMS THE DATA TO MEANINGFULL INFO. AS
PER THE BUSINESS RULES/MAPPING DOCUMENT AND THEN LOADS THE
TRANSFORMED DATA TO TARGET DB(Oracle)USING ETL TOOL INFORMATICA
POWER CENTER.

 AS PART OF MY QA VALIDATIONS I WILL BE VERIFYING ALL THE DATA MOVEMENTS


HAPPENED CORRECTLY OR NOT IN ALL THE LAYERS(EXRACT,TRANSFORM &
LOAD)USING SQL QUERIES.
Case1:

Suppose dev team developed etl for flat files and the etl flow is basically have DQM checks
(20-30 DQM check it applied on flow ) basically dev team create a flow to applied DQM
checks.
Initially provide tester a sample records 20-30 records .
What approach you(tester) applied to check it thoroughly or tester need to check dat
Is dev team applied DQM check properly or not?

You might also like