Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      Wayfair

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Wayfair reviews | Wayfair jobs | Wayfair salaries | Wayfair benefits | Wayfair conversations
      Wayfair interviewsWayfair Data Engineer interviewsWayfair interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Data Engineer Interview

      14 Oct 2021
      Anonymous interview candidate
      No offer
      Negative experience
      Average interview

      Application

      I applied through a recruiter. I interviewed at Wayfair in Sept 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.
      Answer question
      10

      Other Data Engineer interview reviews for Wayfair

      Data Engineer Interview

      11 Nov 2022
      Anonymous employee
      Boston, MA
      Accepted offer
      Positive experience
      Easy interview

      Application

      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 ***

      Interview questions [1]

      Question 1

      Cannot say it, but pretty easy.
      Answer question

      Data Engineer Interview

      18 May 2023
      Anonymous interview candidate
      Boston, MA
      Declined offer
      Positive experience
      Average interview

      Application

      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

      Interview questions [1]

      Question 1

      How to optimize search engines?
      Answer question

      Data Engineer Interview

      7 Dec 2021
      Anonymous interview candidate
      No offer
      Positive experience
      Average interview

      Application

      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 .

      Interview questions [1]

      Question 1

      Increase in loss of the company
      Answer question

      Top companies for "Compensation and Benefits" near you

      avatar
      IKEA
      3.6★Compensation and benefits
      avatar
      Dunelm
      3.5★Compensation and benefits
      Carter & Company
      4.1★Compensation and benefits