Ten days, 40% input and 60% output. If a day slips, don't let it be Day 4 β
the hands-on diagnostics are the bullet your job description names explicitly.
0 / 0
Say the answer out loud before you reveal. Recognition is not recall, and the
interview tests recall.
β
Loadingβ¦
Click, or press space, to reveal
Session 0Got 0Missed 0β
Draw it, diagnose it, or design it β against a clock, out loud, and recorded.
Four minutes is the honest test of whether you can draw something while being interrupted.
Press Deal
Pick a drill type and deal a prompt.
04:00
ready
The page to read in the car park. Nothing new β only what you most want loaded
when you walk in.
Posture
You are a consultant meeting a client, not a candidate being examined.
Ask before you answer. Decide, then say what it costs. Be the most honest person in the room.
The four frameworks
Design β CLAIM. Context (ask 3β5) β Levers (the 2β3 decisions that decide it) β
Architecture (draw) β Implications (what you gave up) β Measure.
Debug. Symptom β Scope β Evidence β Hypothesis β Test β Fix β Prevent.
Never propose a fix before naming the evidence.
Behavioural β STAR-L. Short S and T, most airtime on A ("I decidedβ¦"),
R has a number, L is honest.
Any design question: "Before I design anything β what's the freshness requirement,
who operates this in a year, and what's the regulatory position?"
Any performance question: "First: what changed? Then: where is the time going?"
Any comparison: concede what's true about the competitor, name the dimension that
decides it for this customer, recommend, offer coexistence.
Anything you don't know: "I don't know that specifically. Here's how I'd reason about
it, and how I'd verify." Then reason well and move on.
Numbers you'll reach for
Skew investigation threshold
max/median β³ 5Γ
Target file size after compaction
~128 MB β 1 GB
Shuffle partition target
low hundreds of MB
Partition a table only if
β³1 TB, parts β³1 GB
Z-order columns
β€ 3β4
Delta log / deleted-file retention
30 d / 7 d
Interactive auto-termination
30β60 min
Typical config-only cost win
15β30%
Say these as heuristics. False precision is worse
than "order of magnitude, roughly X".
Signals of real experience
"Before I tune anything β what changed?"
"Max versus median task time in the slowest stage."
"I'd pin the data with time travel and re-run, to separate a data problem from a code problem."
"Adding nodes to a skewed job makes it more expensive and exactly as slow."
"The fix is one thing; the monitor that catches it next time is the deliverable."
"Governance that can be bypassed isn't governance."
Do not
Design before asking.
List features instead of naming a decision and its trade-off.
Bluff β the only disqualifying failure.
Use old names: DLT, Workflows, online tables.
Defend a wrong answer. Say "you're right, I had that backwards" and move on.
Talk for eleven minutes without a breath.
Currency, one line each
Lakehouse//RT / Reyden β millisecond SQL on governed Delta/Iceberg, no serving-store
copy. Beta, read-only.
Lakebase / LTAP β serverless Postgres on lake storage; operational writes landing
straight in open columnar formats, removing the CDC pipeline. LTAP announced.
Iceberg v3 GA β deletion vectors, row lineage, VARIANT; Delta and Iceberg can share
Parquet files.
Unity AI Gateway β runtime governance of models/agents/tools: hard spend caps,
routing, action policies, guardrails, tracing.
In service of an architecture point. Never recite the list.
Three sentences to have ready
On AI. Everyone has the same models. The differentiator is governed
context and runtime control β a data architecture problem, not a model problem.
On cost. I don't want to make the platform cheaper, I want to make it
attributable. Once spend is tagged to product teams, they optimise without anyone policing them.
On the role. The job is making architecture repeatable across engagements,
so the tenth customer gets the benefit of the first nine β while staying close enough to the
metal to be credible when something is on fire.
Last things
Ask your questions. Having none is a scored failure.
Close with: "Is there anything about my background that gives you pause? I'd rather address it now."