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
