ETL Testing Syllabus

• 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]
• Dimensional Modelling
• Difference between relation and dimensional modelling
• Star Schema and Snowflake Schema
• What is fact table
• What is Dimension table
• 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 report 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