ETL Testing

ETL TESTING COURSE CONTENT DETAILS:

SQL Concepts

  • Introduction to SQL
  • Normalization
  • Types of Normalizations
  • DDL Statements
  • DML Statements
  • DQL Statements
  • DCL Statements
  • SQL Constraints
  • Athematic Operators in SQL
  • Logical Operators in SQL
  • Comparison Operators in SQL
  • SET Operators in SQL
  • Aggregate Functions in SQL
  • Scalar Functions in SQL
  • Different Clauses in SQL
  • String functions in SQL
  • Ranking functions in SQL
  • Merge Function in SQL
  • Date Functions in SQL
  • Conversion Functions in SQL
  • JOINS in SQL
  • Sequences & Indexes in SQL
  • Sub Queries and Correlated Sub Queries
  • Views and Stored Procedures

Data Warehousing Concepts

  • What is Data Warehouse
  • What is Business Intelligence
  • Characteristics of Data Warehouse
  • Data Warehouse Architectures
  • Components of Data Warehouse Architecture
  • Purpose Of Staging Area in Data Warehouse Architecture
  • Data Acquisition Process in Data Warehouse
  • Online Transaction Processing System
  • Online Analytical Processing System
  • OLTP vs OLAP
  • Normalization vs De-Normalization
  • What is ODS

Data Marts

  • What is Data Mart
  • How it is different from a Data Warehouse
  • Types of Data Marts
  • Advantages & Disadvantages of a Data Marts
  • Data Warehouse vs Data Marts

Data Modeling

  • Types of Data Modeling
  • ER Modelling vs Dimensional Modeling
  • Why should tester know data modeling
  • How to build Dimensional modeling
  • Objects in Dimensional Modeling
  • What is Dimensional table
  • What is Fact tables
  • Type of Facts
  • Types of Fact tables
  • Types of Dimensional tables
  • Type of Data base schemas
  • Start Schema vs Snow Flake schema
  • Types of SCD’s
  • Advantage and Disadvantage of each SCD type

ETL vs ELT

  • What is ETL. When we use ETL
  • What is ELT. When we use ELT
  • ETL vs ELT

ETL INTRODUCTION

  • ETL Process
  • Difference between ETL and BI tools
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Different ETL tools
  • Different BI tools

ETL Testing Pre-Requisites

ETL Testing Categories

  • Data Mapping Test
  • Smoke Test
  • Sanity Test
  • System Integration Test
  • Functional Test
  • Performance Test
  • Recovery Test
  • Retesting
  • Regression Test
  • End User Test

ETL Testing Challenges

  • What are the challenges will get in ETL Testing
  • How to resolve the Challenges

ETL Testing Techniques

  • Data Count Check
  • Data Accuracy
  • META Data
  • Data Transformations
  • Data Quality
  • Data Completeness
  • Backup Recovery Test
  • Data Load Test
  • SCD Testing
  • Duplicate Test
  • Migration Test
  • Data Integration Test
  • Scheduling Test
  • Archiving Test
  • Email Notification Test

ETL Testing Process

  • Estimations
  • Planning
  • Test Design
  • Execution
  • Closure
  • Pre-Requisites for ETL Test Design
  • Check List for ETL Test Design
  • List of ETL Test Scenarios
  • How to Prepare ETL Test Plan and Test Cases

ETL Tester Responsibilities

  • What are the ETL Tester Responsibilities
  • How to Create ETL Bugs

Must Know Details for ETL Tester

  • What are the details should know before start ETL Testing activity
  • Who will provide the details
  • How to get the details

ETL Tool : INFORMATICA

  • What is Repository Service in Informatica Admin
  • What is Integration Service
  • Create Repository Service
  • Create Integration Service
  • Different components in Informatica
  • Use of Power center Designed
  • Use of Workflow Manager
  • Use of Workflow Monitor
  • Mapping for Flat File to Flat File
  • Mapping for XML file to Flat File
  • Mapping for Database Table to Flat File
  • Mapping for Database table to Database Table
  • Create Filter Transformation in Informatica
  • Create Source Qualifier Transformation in Informatica
  • Create Aggregate Transformation in Informatica
  • Create Expression Transformation in Informatica
  • Create Router Transformation in Informatica
  • Create Joiner Transformation in Informatica
  • Create Lookup Transformation in Informatica

BI Reports Testing

  • Report Data Accuracy Check
  • Drill Down Check
  • Prompts Check
  • Reports Access Security Check
  • Data Security Check
  • Integrated Security Check
  • Report Format Check

ETL Testing Automation: Query Surge

  • How to Install Query Surge tool
  • Benefits of Query Surge
  • Connect Source and Target data bases using Query Surge
  • Create Users
  • Create Query Pairs
  • Create Test Suite and Regression Suite
  • Execute Query Pairs and Test Suite
  • Email notification configuration
  • Execution Dashboards and Reports

Data Work Flows Execution

  • Execute Work flows using Informatica
  • Execute Work Flows using PMCMD commands
  • Verify PMCMD commands execution logs

ADD on’s :
Resume Preparation
Real time Interview Questions