ETL Testing Course
Module 1:Introduction to Data & ETL
● hat is Data? Types of Data
W
● Introduction to Data Warehousing
● ETL Architecture Overview
● Extract Layer
● Transform Layer
● Load Layer
Module 2:Data Warehousing Concepts
● ata Warehouse vs Data Mart
D
● Star Schema & Snowflake Schema
● Dimensions & Fact Tables
● Slowly Changing Dimensions
● OLTP vs OLAP
● ETL vs ELT
Module 3:ETL Tools Overview
S
● SIS Overview
● ETL Tool Components: Source, Target, Transformations
● EDW_ETLRefresh_job (Hot run the job and load data in TGT)
Module 4:ETL Testing Fundamentals
● hat is ETL Testing?
W
● ETL Testing vs Database Testing
● Types of ETL Testing
● ETL Testing Life Cycle
● ETL Test Artifacts (User story subtasks, Mapping Docs, Test Cases, Test Scripts)
Module 5:ETL Testing Types
● ata Completeness Testing
D
● Data Transformation Testing
● Data Quality Testing
● Data Integrity Testing
● Metadata Testing
● Regression Testing
● Incremental Load Testing
● Performance Testing -BI reports
📍
2nd Floor, Nagasuri Plaza, Opp. Mythri vihar, Ameerpet, Hyderabad, Telangana 500016.
+91 9154 11 22 33📥info@[Link] 🌐[Link]
📳
Module 6:SQL for ETL Testing
● QL Basics
S
● Joins, Subqueries, Grouping
● Analytical Functions
● Data Validation Queries
● Writing Test SQL scripts for ETL Scenarios-from Real time project
Module 7:ETL Test Case Preparation
● nderstanding Mapping Documents/User stories
U
● Creating Test Plan documents based on User story.
● Creating ETL Test Scenarios
● Writing Test Cases
● Creating Test Scripts
● Test Data Preparation (in Real time Tool)
● Test case and Test scripts Review
● Test Execution & Logging Defects (Jira)
Module 8:Defect Reporting & Bug Life Cycle
● TL Defect lifecycle (New → Assign → Fixed → Retest → Closed)
E
● How to write ETL defects with proof (SQL evidence)
● High priority vs high severity in ETL
● Real-time ETL bug examples
● Defect Density
● What is Defect Leakage
Module 09:BI-Report Testing
● abular Reports, Pie charts, Bar graphs.
T
● Aggregate Reports
● Dashboards (Visual Reports)
● Drill-Down / Drill-Through Reports
● Export / PDF / Excel Reports
Module 10:Agile methodology useful topics
● hat is Agile
W
● Agile Roles in ETL Projects
● Product Owner
● Scrum Master
● ETL Development Team & QA Team
● Agile Artifacts Used in ETL Projects
📍
2nd Floor, Nagasuri Plaza, Opp. Mythri vihar, Ameerpet, Hyderabad, Telangana 500016.
+91 9154 11 22 33📥info@[Link] 🌐[Link]
📳
● roduct Backlog &Sprint Backlog
P
● User Story
● Acceptance Criteria
● Definition of Done
Module 11:Real-Time Project Scenarios
● nd-to-End ETL Flow till BI-Reports
E
● What is a Computed concept how to validate in ETL testing
● What is SBR and how to validate SBR.
● Data Migration Testing/Historical data load Validation
● What is Aggregation and how to validate Aggregated tables in real time.
● Real time Project Walkthrough
Module 12:Common Real-Time Challenges You Will Face
● ccess issues
A
● Incomplete requirements
● Mapping mismatches
● NULL/duplicate data
● Wrong incremental loads
● Job failures
● Missing source records
● Huge volume data comparison
Module 13:Real time Environments
● eveloper Environment (ETL Developers, Data engineers)
D
● QA Environment (Stage, UAT,Release&Production)
● UAT Environment
● PROD Environment
Module 14:Agile Ceremonies As a ETL Testers shouldAttend
● aily Standup and Scrum call(Mandatory – Every Day)
D
● Sprint Planning (Mandatory)
● Backlog Grooming
● Sprint Retrospective
● Defect Triage Meeting
Module 15:Challenges to Start the Trails to get job
L
● ack of Real-Time Project Knowledge (We are here to help)
● Difficulty Explaining Daily Activities (We are here to help)
📍
2nd Floor, Nagasuri Plaza, Opp. Mythri vihar, Ameerpet, Hyderabad, Telangana 500016.
+91 9154 11 22 33📥info@[Link] 🌐[Link]
📳
F
● ear of Technical Questions to explain (We are here to help)
● Not Able to Explain Defects (We are here to help give more defects explanation)
● Not Having a Strong Resume (We are here to help to prepare Strong Resume and conduct
multiple Mock interviews)
● Difficulty facing TAT&HR calls Lack of real time experience.
Module 16:Start With Onboarding
● R formalities
H
● Laptop setup
● VPN & corporate email
● Access to tools (Jira, Confluence, Git, SQL clients)
● Team(Dev,BA,QA team, Scrum master)&Project introduction.
Module 17:Knowledge Transfer (KT) Sessions
● hat are the source systems
W
● What is the staging area
● What transformations happen
● What types of loads (Full / Incremental )
● Business logic
● Domain knowledge (Based on the Account)
Module 18:Access Setup
● ev / QA Databases
D
● Test Client Access
● Jira Access
● Dashboard Access
Module 19:Daily Work Routine in a Real-Time ETL TestingJob
● ttend Daily Scrum (30 min) with Scrum team. (onshore)
A
● Attend the Sprint Planning and user story creation call.
● Atten the Daily Standup call(offshore).
● Different Status Reports preparation (DSR, WSR&MSR)
● How to fill and where to fill the weekly Project Timesheet for invoice generation.
Module 20:Channels Will Use for communication inReal-time
M
● icrosoft Teams (Fast communication, discussions, doubts)
● Outlook (Formal communication, status, access requests)
● Confluence / SharePoint (documentation, updating project artifacts, Managing Releases)
📍
2nd Floor, Nagasuri Plaza, Opp. Mythri vihar, Ameerpet, Hyderabad, Telangana 500016.
+91 9154 11 22 33📥info@[Link] 🌐[Link]
📳
📍
2nd Floor, Nagasuri Plaza, Opp. Mythri vihar, Ameerpet, Hyderabad, Telangana 500016.
+91 9154 11 22 33📥info@[Link] 🌐[Link]
📳