Question d’entretien chez Wayfair

Phone Interview - Round 1 30 mins design qns Mostly about Streaming architecture and GCP analytics stack 30 mins python and sql sql based on group by and join. Medium level 3 qns python 3 qns leetcode medium easy level 1) given a string, break it to length k. Make sure you dont cut words and your sentence should not end with space. Virtual onsite - 1 Interview - 1 1) What is a MPP database and why is it faster? 2) What kind of queries are slower on MPP 3) Explain Hive 4) You have a log records with 3 fields id, timestamp,status. lots of recs. 1000 per sec. How will you store and model the data. Explain full architecture and choice of ETL. 5) What kind of data quality checks woud you perform for above 6) Explain a good design that you worked on recenty and why you are proud of it? 7) Draw on board and explain in detail Interview - 2 Behavioral. 1) Why wayfair? 2) Explain a scenario where you had to convince someone to make a decision 3) How do you keep yourself updated? 4) Explain your most satisfying project Interview - 3 1) Tell your most challenging project/problem you solved and are proud of in last 6 months. 2) When I told about GCP - POC, tell us why you chose BQ? 3) What challenges did you guys face? OLTP data model wayflix (Similar to Netflix) Write some sql All movies acted and directed by a given actor few more sqls involving join, set operations At the end, convince me why I should say yes to your selection. Interview - 4 Homework 1) Design choices and qns about the homework 2) How would you handle Batch and Streaming data coming in at once 3) How woud you merge streaming data in near real time 4) Some more qns about homework and data model chosen.