Help with Interview Prep - Stakeholder Management/Partnership, and Data Pipeline Design

Charter
bkAA88

Go to company page Charter

bkAA88
Dec 4, 2021 4 Comments

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

Want to comment? LOG IN or SIGN UP
TOP 4 Comments
  • New
    dandalf

    New

    dandalf
    There are some coaches on prepfully who can help I guess, they will simulate these interview types for you
    Dec 5, 2021 0
  • New
    shard1

    New

    shard1
    Ddia wont help you with second one all that much. Look at system design videos on yt specifically for data pipeline. Understand batch and streaming and kappa architecture
    Dec 4, 2021 1
    • New
      XrDQ43

      New

      XrDQ43
      Do you mind if I DM you . Have a specific question and would love to hear your opinion
      Dec 30, 2021
  • New
    XrDQ43

    New

    XrDQ43
    Would love to chat for a few minutes if you are interested about the second part. I am going through the same process !
    Dec 30, 2021 0