about d8loop

Most practice tests what you remember.D8LooP tests what you’d decide.

Most data engineering practice teaches you to recall. The job asks you to decide.

You can memorise every join type and every partitioning strategy and still freeze when someone asks why this grain and not that one. Recall is testable, so that’s what practice sites test. But nobody gets stuck at work because they forgot a syntax rule. They get stuck because a table has one mutable status column and the question on the table is what the status was last Tuesday.

D8LooP exists for that second thing. You design something, it gets picked apart, and you have to defend the choice you made.

why it exists

Nobody gets hired for reciting a definition. Turn any one of these over.

how practice works here

Three beats, every scenario — and each one runs on its own here.

Build

Design the pipeline or the schema. You get the business problem — never the table names.

Review

Scored on structure, requirements, and how it fails. Not against one blessed answer.

Defend

Then the probes. What if it arrives twice? What was this value last Tuesday?

who it's for
  • Interviewing soon

    You can write the query. You have never been asked to justify the schema under it.

  • Two years in

    Everything you have built started from a table someone else designed.

  • Senior, out of practice

    You make these calls weekly. Saying why, in nine minutes, is the rusty part.

who's behind it

Vijay Singh

  1. 2019 — 2026AmazonData Engineer
  2. 2026 — nowDunnhumbySenior Big Data Engineer

I have been 7 years at Amazon, on both sides of the interview table. I built the thing I kept wishing candidates had.