ETL & Data Warehouse Testing
Test a synthetic nightly orders load into a SQLite star schema: source profiling, mapping-driven tests, count and sum reconciliation, visible rejects, transformation and integrity checks, idempotent reruns and report validation, plus a deliberate paise-truncation defect. Complete Python source; website checkpoints check notes, not Python runs. A practical path from a source profile to reconciliation checks that catch silent data loss and wrong values.
- 24
- Lessons
- 8
- Sections
- 8
- Practice labs
- ~12h
- Of content
Sign in to save progress and earn a verified achievement.
1SELECT SUM(amount_paise)2 FROM fact_order;3-- expected 1344504SELECT COUNT(*) FROM etl_rejects;5-- expected 36
The method
Built like real QA work, not a video playlist.
Learn
24 focused lessons, each a few minutes long.
Practice
8 hands-on labs in a browser workspace.
Test yourself
8 section assessments plus a final exam.
Prove it
A public, verifiable achievement for recruiters.
What you will learn
- ETL and warehouse foundations: Decide what ETL testing must prove, Reconstruct the local reference, Read a star schema like a tester
- Source analysis and mapping: Profile the source before testing, Turn the mapping document into test cases, Write business rules as checkable statements
- Completeness and reconciliation: Reconcile row counts, Reconcile measures, not just counts, Make rejected rows visible and explained
- Transformation and quality checks: Test each transformation rule, Check nulls, formats and ranges, Verify referential integrity
- Loads, reruns and history: Prove reruns do not duplicate data, Test incremental and late-arriving loads, Check slowly changing dimensions
- Automating ETL tests: Automate checks as code, Design synthetic test data deliberately, Run ETL checks in the pipeline
Where you will be at the end
- Complete 8 hands-on practice challenges, one per section (from ETL and warehouse foundations to Mutation, retest and portfolio)
- Pass 8 section assessments
- Pass the ETL & Data Warehouse Testing final assessment and add the result to your Skill Passport
Who this course is for
- Beginners and manual testers starting this skill from scratch
- Working testers who want to apply it on real projects
- Anyone preparing for QA interviews that ask about this skill
- Best if you already have: Basic SQL (SELECT, JOIN, GROUP BY); Python 3.10+ installed; terminal familiarity
Curriculum
9 sections, one clear path.
- Decide what ETL testing must prove
- Knowledge check
- Reconstruct the local reference
- Knowledge check
- Read a star schema like a tester
- Knowledge check
- Contract evidence: ETL and warehouse foundations
- Section assessment
Members-only toolkit
Take the course with you
Made from this course's own lessons, quizzes and labs — ready to revise before interviews or use at work.
Course cheat sheet
Loading…
Interview Q&A pack
Loading…
Lab solutions & hints
Loading…
- Auto-checked labs
- Capstone portfolio project
- Timed final exam
Why paid courses
More than a free course: practice, proof and a portfolio
| What you get | Free | Academy |
|---|---|---|
| Short lessons with examples | ||
| Quick checks and certificate | ||
| Hands-on labs checked automatically | ||
| Section tests and a timed final exam | ||
| Portfolio capstone project with milestones | ||
| Cheat sheet, interview pack and lab answers to download | ||
| Verified skills on your profile and Skill Passport |
What Students Are Saying
Sign in and complete 20% of the course to leave a review.
Share your experience on Trustpilot (optional)
Honest feedback is welcome, whatever your experience. A Trustpilot review is not required for your certificate.
ETL & Data Warehouse Testing: common questions
1.Do I need experience before starting ETL & Data Warehouse Testing?
2.What can I try for free, and what needs payment?
3.How long does the course take?
4.What do I get when I finish?
Finish with proof, not just a certificate PDF.
Pass the final assessment and get a public verification page showing your score, completion date and the skills you demonstrated — ready to share on LinkedIn.
About this ETL & Data Warehouse Testing course
The most damaging data bugs never throw an error. A nightly job quietly drops three rows, truncates paise or loads yesterday's file twice, and the revenue dashboard is wrong for weeks before anyone notices. This course teaches you to catch those failures. A synthetic nightly job reads seven order rows from a CSV, loads valid rows into a fact table and a customer dimension in SQLite and records rejected rows with a reason. Twenty-four lessons in eight sections take that job from source profiling to a mapping document, reconciliation, transformation and integrity checks, rerun safety, automation and report validation. Eight written checkpoints and eight assessments use the existing Academy format.
Early sections explain what ETL testing must prove: the right rows arrive, with the right values, exactly once, and bad rows are handled visibly. You read a small star schema as a tester, checking grain, keys and units, and see why money is stored as integer paise. Source lessons profile the file, uncovering mixed-case ids, lowercase countries, a non-numeric amount, a missing id, an empty country and a negative amount, and turn each finding into a mapping rule and a test case.
Reconciliation lessons cover the checks that catch silent loss: loaded plus rejected must equal source rows, the sum of amounts must match on both sides, and the exact reject list must be correct. Transformation and quality lessons assert each mapping rule, check nulls, formats and ranges, and verify that no fact row is orphaned from its dimension. Load lessons prove reruns are idempotent and explain incremental watermarks and slowly changing dimensions, clearly labelled where they go beyond the runnable project.
The complete source-map lesson contains etl.py, orders.csv, test_etl.py and a README, using only Python and its built-in SQLite. We ran this exact project before publishing: all six tests passed, with four rows loaded, three rejected with reasons and a loaded total of 134450 paise. Setting BREAK_ETL=1 truncated paise; counts still matched but the amount reconciliation failed with 134300 against 134450, and unsetting it restored a clean pass.
Later sections cover automating checks as code, designing synthetic test data, gating reports on results, validating BI figures with direct queries, writing actionable ETL defects and protecting personal data in evidence. The final portfolio contains the mapping, a passing run, the failing mutation run, the restored retest and a short report. Website checkpoints validate a completed written note and do not run Python. The certificate records Academy completion, not an official vendor or ISTQB certification.
Who this course is for
- Manual testers moving into data and BI testing
- SQL-confident QA engineers working on data pipelines
- Analysts who need to prove report numbers are right
What you need
- Basic SQL (SELECT, JOIN, GROUP BY)
- Python 3.10+ installed
- Terminal familiarity
What you will be able to do
- Turn a source-to-target mapping into concrete test cases
- Reconcile counts, sums and rejects between source and warehouse
- Check transformations, referential integrity and rerun safety
- Prove checks fail on a deliberate defect and report the result
