I applied through a recruiter. I interviewed at Wayfair in Sep 2021
Interview
Recruiter called first, got details about my current role and after deciding I was a good fit, he forwarded me for a codility test.
Virtual Coditlity:-
1 Hr:-
Interviewer was friendly. 30 mins he asked about my expeerience, qns about MPP, Big data and pipelines.
25 mins, I was given 3 Sql and 3 Python qns. I completed 2 completely in each Sql and Python. Third one in each I only had time to explain my logic.
Feedback:- Was good.
Recruiter calls again to setup 4 hour virtual loop interview. Here is where the frustrating part begins.
I got zero emails/details about what is the format of the interview. The invite had one interview with a Sr manager to go over homework assignment. I emailed twice to help understand what the homework was. Nope, no comment, no reply.
Day of interview is when they realized that they didnt send me Homework assignment. So that 1 hour interview from the 4 hour loop interview was cancelled.
The other 3 interviews were ETL Design, Behavior and Data Modeling each. I had a fairly good experience of the interviews. I have no complains.
In the evening after the loop interview , I was given a document containing details explaining the format of the 4 hour interview (after I finished 3 of those) and the homework assignment.
I emailed the recruiter that its disappointing because it was unfair of them to not give me details of the interview before hand. He commented that I did well and requested 1 hour of my time for homework assignment.
I spent some time of my weekend to finish the homework, finish the homework assignment evaluation.
Even this was a good experience and I liked the homework assignment.
And then the recruiter tells me after a few days that he expects to hear about my feedback soon.
Its been more than 2 weeks since my loop interview and I still havent heard from the recruiter. He is now ghosting me on Linkedin.
Its such a disappointing experience because I feel first they havent given me a fair opportunity as others and its just even more sad the entire ghosting episode.
Interview questions [1]
Question 1
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.
I applied online. The process took 3 weeks. I interviewed at Wayfair (Boston, MA) in Nov 2022
Interview
The first round runs 60 mins. A SQL question and a case. The interviewer will turn off the camera and you can enjoy coding by yourself. Then there is a case in which you need to find out what's wrong with ***
I applied online. I interviewed at Wayfair (Boston, MA) in Feb 2022
Interview
total 5 rounds 1st: 1 coding test 2nd: live coding - SQL and Python 3rd: Case study 4th and 5th will be combined 4th: Project- 1 week 5th: last round of Behavioral and technical
I applied through university. I interviewed at Wayfair
Interview
First round interview with 30 minutes live coding and business case. The interviewer was helping out and everything went in a planned manner. Got a reject for the final round interview though .