Senior Data Engineer — Streaming & Reliability

What this session covers

• Streaming
• Exactly-once
• Replay
• Observability
• Cost

Questions you'll face

1. 1. Take me through how you'd model a warehouse layer for an e-commerce business whose analysts constantly ask new questions.

   ~3 min

   Checks modelling fundamentals and consumer empathy.

2. 2. A daily pipeline silently produced 30% fewer rows for a week before anyone noticed. How do you prevent the next one?

   ~3 min

   Data-quality and observability thinking.

3. 3. When would you choose streaming over batch, and when is streaming the wrong answer?

   ~3 min

   Tests honest trade-off reasoning instead of hype.

4. 4. A key query on a 4-billion-row table takes nine minutes. What do you look at?

   ~3 min

   Warehouse performance depth.

How the time is spent

1. 1

   Warm-up & context · 5 min

   Interviewer intro, your background, how the session runs.

2. 2

   Core questions · 27 min

   Role-specific questions with live follow-ups based on your answers.

3. 3

   Deep dive · 9 min

   One topic explored to the edge of your experience.

4. 4

   Your questions & wrap · 5 min

   Close the loop and hand over to feedback generation.