ETL Dataware House Testing

ETL Testing Documents

  • IT Professional Training
  • Basic of ETL / Datawarehouse
  • Practical Documentations
  • ETL Tools
  • Projects
  • Additional Knowledge
  • Mock Interviews
  • HR Sessions
  • Resume Preparations
  • Job searching
  • Post Selection

ETL Testing Syllabus

  • IT Professional Structure
  • What is IT Industries
  • IT Company Types
  • Project Teams
  • Project and Products
  • Project Teams
  • IT industry history
  • IT company Structure
  • IT Departments
  • Roles and Responsibilities
  • Basic of SQL
  • What is Data warehouse?
  • Need of Data warehouse?
  • Introduction to OLTP, ETL and OLAP Systems
  • Data warehouse Architecture
  • Data Marts
  • ODS ( Operational Data Store )
  • Dimensional modeling
  • Star schema, snowflake schema
  • What are Fact and Dimensional tables?
  • and fact constellations schema
  • Normalization and De-Normalization
  • Several real time business Scenarios
  • Types of SCD’s
  • Types of ETL Testing

    Data Completeness, Data Transformations, Data Quality, Performance and Scalability, Integration testing

  • Different types of SDLC

    Waterfall Model, V-Shaped Model, Iterative Model Incremental Spiral Model, Big Bang Model, Agile Model

  • Agile Model

    Extreme Programming, Kanban, Lean Development, Scrum, Crystal, FDD.

  • Requirements documents - SRS, FRS, BRS, DBR, CR, HLR, LLR
  • Project plan
  • ER Diagram
  • Data Flow Diagram
  • Use Cases
  • User manual
  • SQL Server
  • Defect tracking tool
  • SSIS Tool
  • SSRS Tool
  • BI Tool
  • Informatica Power Center
  • Project Requirements understanding
  • Projects plan
  • ER Diagram
  • Use cases
  • Data Flow Diagram
  • Domain knowledge
  • Unix Concepts knowledge
  • Latest updates of SQL Development
  • Basic Level Mock
  • Advance Level Mock
  • Real Conditions Mock
  • All Basic Concepts for HR Interview
  • Advance HR discussion Practices
  • Salary Related Negotiation Skills
  • Resume preparation as per Experience Level
  • All Techniques for job searching
  • After Selection Training