Help with Interview Prep - Stakeholder Management/Partnership, and Data Pipeline Design
I have a followup interview for a Senior role that consists of two 1-hour interviews. I haven't been through one of these before and wanted to ask the community for guidance on how best to prepare and what sort of questions to expect. The interviews will be:
- Stakeholder Management and Partnership
- High level case study about creating self-service analytics for stakeholders (PMs, SWEs, DS)
- How to be attentive to and address stakeholder needs?
- Prioritizing tasks with time/resource constraints.
- Tradeoffs between avoiding tech debt, product stability, and delivering user value quickly.
- Anti-Patterns to avoid.
2) Data Pipeline Design - Whiteboard style
- Given a set of data and SQL queries, design a pipeline. Thought process on why you would set it up that way.
- How to explain to stakeholders how they would use the pipeline? How analytically useful is it for them?
- How to assess how production quality the pipeline is - how to set it up to run, where are the bottlenecks, how to ensure data quality?
- How would you gather requirements?
I plan on going through Designing Data-Intensive Applications for the 2nd one. I'm starting to scour the internet for info regarding the 1st one, as well as reflecting on my own experience.
I'm super psyched for this company, so thank you in advance for your advice!
comments