ETL Testing

ETL TESTING COURSE CONTENT DETAILS:

Batch Schedule:

Course name: ETL TESTING (COMPLETE REAL TIME TRAINING)

Course start date:

Time:

Course Duration:

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