ETL TESTING

What is Data warehouse?

Need of Data warehouse?

Introduction to OLTP, ETL and OLAP Systems

Data warehouse Architecture

Data Marts

ODS ( Operational Data Store )

Dimensional modeling

Difference between relational and dimensional modeling

Star schema, snowflake schema and fact constellations schema

What are Fact and Dimensional tables?

Normalization and De-Normalization

Several real time business Scenarios

Types of SCD’s

ETL Testing ( Data warehouse testing )

ETL Architecture

What is ETL and Importance of ETL testing

How DWH testing is different from manual and automation testing

SDLC / STLC

Challenges in DWH testing compared to other testing

Incompatible and duplicate data

Loss of Data during ETL process

Volume and Complexity of data

ETL testing Workflow activities

Analyze and interpret business requirements / workflows to create estimations

Prepare the test cases with the help of design documents provided by the development team

Execute system testing and integration testing

How to detect the bugs in the ETL testing

How to report the bugs in the ETL testing

Types of ETL Testing

Data Completeness

Data Transformations

Data Quality

Performance and Scalability

Integration testing

SQL Queries for ETL testing

Incremental load testing

Initial load / full load testing

Different ETL tools available in the market

Informatica, Abinitio, Datastage

Power center components

Designer

Repository Manager

Workflow Manager

Workflow Monitor

Mapping document

Preparation of test cases

Execution of test cases

Mapplet, Worklet

Data Validation in Source and Target

Regression Testing

Test Case template

SQL

Detailed SQL Foundation for beginners

Select, Insert, Update, Delete, drop, truncate, filter, Where, Group By, having, order by commands.

Arithmetic , comparison, logical and Range operators

IN / NOT IN, Set Operators

Union, Union all, Intersect

Cross Join

Simple Queries

Constraints

Aggregate functions

Alias Joins

Simple Join, Equi join, Self Join, Inner Join, Outer Join, Left outer Join, Right Outer Join, Full Outer Join, Subqueries, Nested Subqueries

Rank and Dense Rank