ETL TESTING
ETL testing is a data centric testing process to validate that the data has been tranformed and loaded into the target as expected.
Instructor: Tom Steven
- Lectures: 11
- Quizzes: 3
- Students: 5
- Duration: 10 weeks
ETL test training in Noida. Hardware and software are required to master all the skills set for ETL test training. Our trainers are planning work-oriented ETL test training. is one of the well-equipped ETL test training centers in Noida. We provide training on real-time projects that help students with better understanding. our trainers also help students to get top MNCs placement by preparing different strategies. We designed the ETL test course content and syllabus to achieve their professional goals.
Content
Basics Of DBMS
Basics Of DBMS
Basics Of DBMS
Basics of SQL
DDL
DML
Working with SQL Queries
Basics Of DBMS
Basics of SQL
DDL
DML
Working with SQL Queries
Working with SQL Queries
Working with SQL Queries
Working with SQL Queries
Basics Of Unix
Basic commands used in Unix for ETL Testing
Working with SQL Queries
Basics Of Unix
Basic commands used in Unix for ETL Testing
Basic commands used in Unix for ETL Testing
What is Data Warehouse?
Need of Data Warehouse
Introduction to OLTP, ETL and OLAP Systems
Difference between OLTP and OLAP
Data Warehouse Architecture
Data Marts
ODS [Operational Data Store]
Star Schema and Snowflake Schema
What is fact table
What is Dimension table
Normalization and De-Normalization
Basic commands used in Unix for ETL Testing
What is Data Warehouse?
Need of Data Warehouse
Introduction to OLTP, ETL and OLAP Systems
Difference between OLTP and OLAP
Data Warehouse Architecture
Data Marts
ODS [Operational Data Store]
Star Schema and Snowflake Schema
What is fact table
What is Dimension table
Normalization and De-Normalization
Normalization and De-Normalization
ETL architecture.
What is ETL and importance of ETL testing
How DWH ETL Testing is different from the Application Testing
SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
Challenges in DWH ETL Testing compare to other testing
Incompatible and duplicate data.
Loss of data during ETL process.
Testers have no privileges to execute ETL jobs by their own.
Volume and complexity of data is very huge.
Fault in business process and procedures.
Trouble acquiring and building test data.
ETL Testing Work flow activities involved
Analyze and interpret business requirements/ workflows to Create estimations
Approve requirements and prepare the Test plan for the system testing
Prepare the test cases with the help of design documents provided by the developer team
Execute system testing and integration testing.
Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
How to detect the bugs in the ETL testing
How to co-ordinate with developer team for resolving the defects
Types of ETL Testing
Data completeness.
Data transformation.
Data quality.
Performance and scalability.
Integration testing.
User-acceptance testing.
SQL Queries for ETL Testing
Incremental load testing
Initial Load / Full load testing
Different ETL tools available in the market
Normalization and De-Normalization
ETL architecture.
What is ETL and importance of ETL testing
How DWH ETL Testing is different from the Application Testing
SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
Challenges in DWH ETL Testing compare to other testing
Incompatible and duplicate data.
Loss of data during ETL process.
Testers have no privileges to execute ETL jobs by their own.
Volume and complexity of data is very huge.
Fault in business process and procedures.
Trouble acquiring and building test data.
ETL Testing Work flow activities involved
Analyze and interpret business requirements/ workflows to Create estimations
Approve requirements and prepare the Test plan for the system testing
Prepare the test cases with the help of design documents provided by the developer team
Execute system testing and integration testing.
Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
How to detect the bugs in the ETL testing
How to co-ordinate with developer team for resolving the defects
Types of ETL Testing
Data completeness.
Data transformation.
Data quality.
Performance and scalability.
Integration testing.
User-acceptance testing.
SQL Queries for ETL Testing
Incremental load testing
Initial Load / Full load testing
Different ETL tools available in the market
Different ETL tools available in the market
Different ETL tools available in the market