What problem does it solve? Preparing for Netflix's hybrid Data Engineering Depth round (Round 1.1) is hard to practice alone because it combines a business-to-implementation design discussion with a live practical SQL exercise under a strict Senior/Staff grading bar. This Skill runs a realistic 60-minute mock interview so candidates can rehearse requirements gathering, implementation design, and production-calibre SQL before the real loop. ## Core Features & Use Cases - Live interviewer role-play: Two personas (Senior DE and Staff DE on the Ads team) run the full 60-minute format — clarifying questions, 20-minute implementation design, trade-off probing, and a 20-minute SQL exercise tied to the design. - Strict calibrated scoring: A v0.4 rubric grades 7 design axes, 5 SQL axes, an Iceberg-literacy axis, and design-SQL coherence, with per-phase micro-feedback and a final coach debrief persisted to a session log. - Ads-domain question bank: Six anchor business prompts (campaign reporting, frequency capping, CAPI attribution, fill-rate matching, reach forecasting, event pipelines) each with a matched SQL exercise, reference solutions, and gotcha probes. - Concept-gap recovery: A 2-strike protocol detects Netflix-stack knowledge gaps (Iceberg, WAP, Psyberg, Maestro) mid-mock and pivots to a worked-example study artifact instead of wasting the session. - Use Case: A candidate says "mock DE depth" the week before their Netflix Ads DSE onsite; the skill checks their knowledge base for open gaps, runs the CAPI attribution prompt in character, critiques their last-touch attribution SQL, and logs a scored debrief with a drill plan. ## Quick Start Ask Claude to start a mock DE depth round, for example by saying "run a mock DE depth interview in exam mode using the CAPI attribution question".
