How to Prep When the Format Is Mid-Transition
You're interviewing into a format that's actively changing. Your next company might ban AI entirely, allow it in parts, or require it. Here's how to not get caught flat-footed.
SQL fluency is still the highest-leverage prep. Joins, window functions, CTEs, aggregations, deduplication, query tuning. These carry across every format: take-home, live coding, pair programming, whiteboard. The format changes; the SQL doesn't. If you're weak on any of those, drill them until they're automatic.
Practice live debugging, not just building. As companies migrate to pair programming, interviews increasingly test incremental refinement rather than architecture from scratch. You'll be handed a schema or pipeline with one bug, and the round tests how fast you iterate. Practice reading EXPLAIN plans, rewriting queries for performance, and identifying cost-driving joins. The complete interview prep guide covers the full spectrum of what you'll face.
Learn to narrate your thinking. In a pair session, the interviewer is evaluating how you decompose problems, where you push back on AI suggestions, and how you verify output. Practice solving problems out loud. Say "I'm starting with the grain of this table because..." not just typing in silence. 60-90 minutes of reasoning out loud is how senior DEs actually work; take-homes hide this entirely.
Get comfortable using AI transparently. If the interview allows AI, the most successful candidates use it strategically for well-defined subtasks while maintaining control of the overall solution. They don't prompt and accept whatever it generates. They prompt, read, question, correct, and explain why. That meta-skill, knowing when to trust the AI and when to override it, is now a first-class interview signal.
Push back on scope. If a company sends you a 15-hour take-home in 2026, you're within your rights to ask for a 90-minute pairing session instead, or at minimum, compensation. The candidates they're losing to competing offers are the ones who refuse to do free consulting. Don't be the one who spends a weekend on a submission that gets ghosted.