ETL Testing Training


Best ETL testing training in Ameerpet Hyderabad

 

ETL TESTING TRAINING

 

MODULE 1: BASIC KNOWLEDGE ON DWH AND ETL TESTING.

  1.  What is DWH?
  2. DWH Architecture
  3. What is ETL Testing?
  4. How ETL is different from other Testing?
  5. What needed for ETL Testing?

MODULE 2:MANUAL TESTING CONCEPTS

  1.  STLC
  2. Unit Testing, Functional Testing, Integration Testing, System Testing, Re Testing, Regression Testing
  1. Test Strategy, Test Plan, Test Scenario and Test Case
  2. Defect Life Cycle

MODULE 3: DATABASE CONCEPTS

1.Different types of language’s in SQL

a.Data Definition Language (DDL)

i. CREATE

ii. ALTER

1.ADD

2.MODIFY

3.DROP

4.RENAME

iii.   TRUNCATE

iv. DROP

b.Data Manipulation Language (DML)

i. INSERT ii.   UPDATE iii.   DELETE

c.Transaction Control Language (TCL)

i. COMMITT

ii. ROLLBACK

iii.   SAVE POINT

d.Data Control Language (DCL)

i. GRANT

ii. REVOKE

e.Data Query Language (DQL) or Data Retrieval Language (DRL)

2.INTEGRITY CONSTRAINTS

  • UNIQUE KEY
  • NOT NULL
  • CHECK
  • PRIMARY KEY
  • FOREIGN KEY
  • COMPOSITE PRIMARY KEY
  • COMPOSITE UNIQUE KEY
  1. WHERE, GROUP BY, HAVING and ORDER BY clauses and GROUP functions.
  2. Analytical Functions
  3. DECODE and CASE conditional statements
  4. Sub Queries and CO-Related Sub queries
  5. JOINS

a. INNER JOINOR EQUI JOIN

b.OUTER JOIN

i. LEFT OUTER

ii. RIGHT OUTER

iii.   FULL OUTER

c.SELF JOIN

d. CARTESIEN JOIN

8.SET OPERATORS

  • UNION
  • UNION ALL
  •    INTERSECT
  •   MINUS

9.Normalization and De-normalization

10.VIEWS

MODULE 4:Data warehousing Concepts

  1.  What is Data warehouse?
  2. Why DWH?
  3. DWH characteristics
  4. Why Data warehouse and why not database?
  5. DWH Architecture
  6. DWH approaches
  •  TOP DOWN
  •   BOTTOM UP

5.What is Data Mart?

  •   Independent Data Mart
  •   Dependent Data Mart

6.Data Mart Vs DWH

7. Dimension, Fact, Dimension Table, Fact Table
8. What is Surrogate Key?
9. Types of Fact tables
a. Additive
b. Semi additive
c. Non Additive (Fact Less fact table)

1o. DWH schemas

  • STAR schema
  • SNOWFLAKE schema

11.Slowly Changing Dimensions (SCD), and types of SCD’s

  • SCD 1 b.   SCD 2 c.   SCD 3

12. OLTP Vs OLAP

13.What is Business Intelligence?

MODULE 5:ETL Concepts

  1.            What is ETL?
  2.               What is Data Acquisition, whatData Acquisition contains?

a.  Data Extraction

b.    Data Transformation

i. Data Merging ii.   Data Cleansing iii.   Data Scrubbing  iv. Data Aggregation

c.   Data Loading

3.Source System, Staging Area, Target System

4.Types Data Loads

a.Initial Load

b. Incremental Load

d.Full Load

MODULE 6: ETL Testing

  1.  ETL Tester Roles & Responsibilities
  2. Types of Documents
  3. How to deriving Test scenario’s from Functional Specification (FS)
  4. How to derive test cases from FS and TS
  5. How to Prepare the source queries from Mapping document
  6. What we validate in ETL Testing and how we validate, various validation techniques?
  7. Reporting Bugs

MODULE 7: Test Management Tool

  1.  Uploading Requirements
  2. Uploading/Preparing Test Cases and Mapping Test Cases to Requirements
  3. Test Case Execution
  4. Defect Reporting, Mapping Defect to Test Cases
  5. Test Summary Reports

MODULE 8:Informatica – ETL Tool(Freeware-TALEND/Commercial-INFORMATICA)
1. What is Informatica?
2. Informatica Client Components

a. Repository
b. Designer
c. Workflow manager
d. Workflow Monitor
e. Session
f. Mapping

3. Source Analyzer
4. Target Designer
5. Mapping Designer
6. Mapplet Designer
7. Task Designer
8. Workflow Designer
9. Transformations in Informatica.
10. Active and passive transformation
11. Working with RDBMS
12. Working with Flat files

MODULE 8:Informatica – ETL Tool(Freeware-TALEND/Commercial-INFORMATICA)

  1.  What is Informatica?
  2. Informatica Client Components

a. Repository

b.  Designer

c.Workflow Monitor

d.Session

e. Mapping

  1. Source Analyzer
  2. Target Designer
  3. Mapping Designer
  4. Mapplet Designer
  5. Task Designer
  6. Workflow Designer
  7. Transformations in Informatica.
  8. Active and passive transformation
  9. Working with RDBMS
  10. Working with Flat files

MODULE 9: ETL Testing Automation (FITNESSE Tool)

  1.  Tools available for Automating ETL Testing
  2. How to Automate ETL Testing?
  3.  Advantages of Automating ETL Testing against Manual ETL Testing?
  4.  How to validate external file (SOURCE) against Target DB (DWH) using FITNESSE Tool?
  5. How to validate database table (SOURCE) against Target DB (DWH) using FITNESSE Tool?

MODULE 10:Others

  •  CV Preparation Tips
  • Interview Tips & Mock Interviews