ETL Test Scenarios

ETL TEST
SCENARIOS
TEST-CASES
 Count Validation
 Data Validation
 Data Completeness Validation
 Data Correctness Validation
 Data Transform validation
 Structure Validation
 Validate Constraints
 Data Consistency checks
2
 Data Quality Validations
 Null Validation
 Duplicate Validation
 Date Validations
 Precision checks
 Full Data Validation using Minus query
 Validating Mapping document
 Any Other Test Scenarios
3
Count Validation
This involves validating the record count (Row Count) from target against source after a
successful ETL process.
Usually, the tester will execute a count (*) statement from Source with required mapping
logic(filters, joins etc) and compare it with the target record count.
Data Validation
 Data Completeness Validation
 It involves checking if all the data is loaded to the target system from the source
system. Validating the unique values of primary keys.
 Data Correctness Validation
 Misspelled or inaccurate data is found in table. Null, Not Unique data is stored when you
disable integrity constraint at the time of import.
 Data Transform validation
SOLUTION
CLOSE THE GAP TARGET AUDIENCE

Our product makes consumer lives easier, and no Our target audience is Gen Z (18-25 years old)
other product on the market offers the same features
COST SAVINGS EASY TO USE

Reduce expenses for replacement products Simple design that gives customers the targeted
information they need
20XX Pitch Deck 6

PRODUCT BENEFITS
Cool and stylish product

Areas for community connections
Online store and market swap
20XX Pitch Deck 7

COMPANY
OVERVIEW
BUSINESS MODEL
ABSTRACT
We based our research on market trends and social media
DESIGN
We believe people need more products specifically dedicated
to this niche market
RESEARCH
Minimalist and easy to use
20XX Pitch Deck 9

MARKET OVERVIEW
$3 BILLION $1 BILLION $2 BILLION
Freedom to invent Opportunity to build Few competitors

Selectively inclusive market Fully inclusive market Specifically targeted market
Serviceable available market Total addressable market Serviceable obtainable market
20XX Pitch Deck 10

MARKET COMPARISON
$3B $2B $1B
OPPORTUNITY TO FREEDOM TO INVENT FEW COMPETITORS

BUILD
Addressable market Serviceable market Obtainable market
20XX Pitch Deck 11

OUR COMPETITION
CONTOSO COMPETITORS
Our product is priced below that of other Company A

companies on the market Product is more expensive
Design is simple and easy to use, compared to Companies B & C
the complex designs of the competitors Product is expensive and inconvenient to use
Affordability is the main draw for our Companies D & E
consumers to our product Product is affordable, but inconvenient to use
20XX Pitch Deck 12

OUR COMPETITION
CONVENIENT
Competitor A
CONTOSO
AFFORDABLE EXPENSIVE
Competitor D
Competitor C
Competitor B
Competitor E
INCONVENIENT
20XX Pitch Deck 13

GROWTH STRATEGY
FEB 20XX
Roll out product to high profile or top-level participants to help establish
the product
MAR 20XX
Release the product to the general public and monitor press release and
social media accounts
OCT 20XX
Gather feedback and adjust product design as necessary
20XX Pitch Deck 14

TRACTION
Forecasting for success
KEY METRICS REVENUE BY YEAR
Clients Orders Gross revenue Net revenue $40,000
20XX 10 1100 $10,000 $7,000 $30,000
20XX 20 200 $20,000 $16,000

$20,000
20XX 30 300 $30,000 $25,000

$10,000
20XX 40 400 $40,000 $30,000

$0
20XX 20XX 20XX 20XX
20XX Pitch Deck 15

TWO-YEAR ACTION PLAN
DRAFT BLUEPRINTS G AT H E R F E E D B A C K DELIVER TO CLIENT
20XX JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
20XX JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
RUN FOCUS GROUPS TEST DESIGN LAUNCH DESIGN
20XX Pitch Deck 16

FINANCIALS
Year 1 Year 2 Year 3

INCOME
Users 50,000 400,000 1,600,000
Sales 500,000 4,000,000 16,000,000
Average price per sale 75 80 90
Revenue @ 15% 5,625,000 48,000,000 216,000,000
GROSS PROFIT 5,625,000 48,000,000 216,000,000
Expenses
Sales & marketing 5,062,500 38,400,000 151,200,000 70%
Customer service 1,687,500 9,600,000 21,600,000 10%
Product development 562,500 2,400,000 10,800,000 5%
Research 281,250 2,400,000 4,320,000 2%
TOTAL EXPENSES 7,593,750 52,800,000 187,920,000
20XX Pitch Deck 17

MEET THE TEAM
TA K U M A H AYA S H I M I R J A M N I L S S O N F L O R A B E R G G R E N R A J E S H S A N TO S H I
President Chief Executive Officer Chief Operations VP Marketing
Officer
20XX Pitch Deck 18

MEET THE TEAM
TA K U M A H AYA S H I M I R J A M N I L S S O N F L O R A B E R G G R E N RAJESH SANTOSHI

President Chief Executive Officer Chief Operations Officer VP Marketing
GRAHAM BARNES R O WA N M U R P H Y ELIZABETH MOORE ROBIN KLINE

VP Product SEO Strategist Product Designer Content Developer
20XX Pitch Deck 19

FUNDING
$14,000 $12,000 $82,000 $32,000

ANGEL INVESTMENTS P R O P E RT Y SHARES CASH
Amount obtained through Revenue obtained from Number of shares converted Liquid cash we have on hand
other investors property rentals into USD
20XX Pitch Deck 20

SUMMARY
At Contoso, we believe in giving 110%. By using our next-

generation data architecture, we help organizations virtually
manage agile workflows. We thrive because of our market
knowledge and great team behind our product. As our CEO
says, "Efficiencies will come from proactively transforming
how we do business.”
20XX Pitch Deck 21

THANK YOU
Mirjam Nilsson
206-555-0146
mirjam@contoso.com
www.contoso.com
20XX Pitch Deck 22

ETL Test Scenarios

Uploaded by

Copyright:

Available Formats

ETL Test Scenarios

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

ETL Test Scenarios

Uploaded by

Copyright:

Available Formats

ETL TEST

CLOSE THE GAP TARGET AUDIENCE

COST SAVINGS EASY TO USE

20XX Pitch Deck 6

Cool and stylish product

20XX Pitch Deck 7

20XX Pitch Deck 9

$3 BILLION $1 BILLION $2 BILLION

Freedom to invent Opportunity to build Few competitors

20XX Pitch Deck 10

$3B $2B $1B

OPPORTUNITY TO FREEDOM TO INVENT FEW COMPETITORS

20XX Pitch Deck 11

Our product is priced below that of other Company A

20XX Pitch Deck 12

20XX Pitch Deck 13

20XX Pitch Deck 14

KEY METRICS REVENUE BY YEAR

Clients Orders Gross revenue Net revenue $40,000

20XX 10 1100 $10,000 $7,000 $30,000

20XX 20 200 $20,000 $16,000

20XX 30 300 $30,000 $25,000

20XX 40 400 $40,000 $30,000

20XX Pitch Deck 15

DRAFT BLUEPRINTS G AT H E R F E E D B A C K DELIVER TO CLIENT

RUN FOCUS GROUPS TEST DESIGN LAUNCH DESIGN

20XX Pitch Deck 16

Year 1 Year 2 Year 3

20XX Pitch Deck 17

20XX Pitch Deck 18

TA K U M A H AYA S H I M I R J A M N I L S S O N​ F L O R A B E R G G R E N​ RAJESH SANTOSHI

GRAHAM BARNES R O WA N M U R P H Y ELIZABETH MOORE ROBIN KLINE

20XX Pitch Deck 19

$14,000 $12,000 $82,000 $32,000

20XX Pitch Deck 20

At Contoso, we believe in giving 110%. By using our next-

20XX Pitch Deck 21

20XX Pitch Deck 22

You might also like

TA K U M A H AYA S H I M I R J A M N I L S S O N F L O R A B E R G G R E N RAJESH SANTOSHI