I applied through college or university. The process took 3 weeks. I interviewed at Wayfair (Boston, MA) in Apr 2022
Interview
There were three rounds, these included Online assessment, Tech interview and human resources round. The rounds were spaced far apart. The interviews in all rounds were taken by people in the DE team. Questions based on Structured Query Language and Case Studies were asked
I applied online. The process took 4 weeks. I interviewed at Wayfair
Interview
0th round = phone screen with HR
1st round = video interview with a DE = business case study + easy live SQL coding interview
2nd round = on-site with three interviews in one day = 1) one-hour take-home database design assignment presentation and live coding that uses the database you designed, 2) 30-min interpret an actual SQL script with emphasis on business meanings, 3) 30-min behavioral interview up to 5 questions
The interview lasted for 35 mins with online live coding in SQL and case analysis. The overall process was so smooth and the interviewers were very supportive throughout the interview
