Three rounds of interviews - the first is a technical assessment followed by a 30-minute interview, and finally, 3-hour interview which consists of technical assessment, technical questions, and behavioral questions.
I applied online. The process took 1 week. I interviewed at Wayfair (Boston, MA) in Jan 2022
Interview
The first round consists of codility SQL test (3 advanced problems to solve at home with a time limit). You just get an online invitation to complete the test in the next couple of days.
Interview questions [1]
Question 1
They show how the output should look like and you need to query the given data to obtain the exact result. Test cases are different than the ones you're trying it on, so it may work on a given data but not necessarily on the new records they test it on.