J'ai postulé via un recruteur. Le processus a pris 2 mois. J'ai passé un entretien chez Google (Londres, Angleterre) en oct. 2020
Entretien
Coding live exercise - this is your algorithms and data structures stuff. Expect it to be of intermediate / hard difficulty on something like hacker rank
SQL live exercise - Given this scenario, create some tables and write these queries.
Architecture chat - Questions like - how would you design a video streaming service architecture?
Customer scenario chat - A customer says x, what would you do?
Questions d'entretien [1]
Question 1
What type of technology would you need to build YouTube?
Simple and non technical. No technical questions at all in the initial screening. 3 more interviews after that. Not terrible. All stuff you’ve probably seen before. Some experience and personal questions
J'ai passé un entretien chez Google (Mountain View, CA)
Entretien
recruiter > tech screen on coderpad with advanced sql and some python data manipulation. the onsite was a 5 round loop: data modeling, pipeline design, python coding, advanced sql, and a googleyness/behavioral chat. the pipeline design round is the absolute filter imo - they throw a massive ques at you, like designing a real-time analytics pipeline for ad-click tracking system, and you have to map out the batch vs streaming architecture, idempotency, and how to handle late-arriving data from scratch. the modeling round was all about star schemas, handling slowly changing dimensions (SCDs), and optimizing tables. it felt very practical; it’s more about how you structure data at a massive scale and handle edge cases. for prep, i focused on kimball methodology and practicing streaming architectures. i did a few mocks on Prepfully with google DEs specifically for the pipeline design round and that helped me lot. Skimmed through DataLemur for ques and practice and yeah ofcourse blind/reddit for recent experiences
Questions d'entretien [1]
Question 1
design a data pipeline to process clickstream events from millions of users in real time
J'ai passé un entretien chez Google (Cupertino, CA)
Entretien
Many rounds very The interview process included an initial screening, technical assessment, and behavioral interview focused on communication, problem-solving, teamwork, and adaptability. Final candidates met with leadership to discuss role expectations and organizational fit.