The interview process was very slow. The recruiter did a horrible job coordinating the schedule, and he was very disrespectful and unprofessional throughout the entire process.

Before the first round screening, I submitted my availability and received a confirmation email with a specific time and date for the first-round interview. The recruiter called a day early without any notice, went through my background, and gave me an assessment link as the next step. The assessment consisted of a couple of multiple-choice questions on HackerRank. They were not difficult but tricky in terms of small syntax errors, etc.

After I submitted the assessment, it took over a week for the next round. The recruiter informed me that the next round would be a one-hour technical round, with no further details mentioned in the email. I followed up and tried to get more information regarding the format and languages for the technical screening. The recruiter's response was, "a resume review & overall introduction to some of the great things we are doing here at Chewy!" Very helpful, LOL... This round was quite technical, with lots of Data Warehouse design, performance tuning, SQL syntax, and DW tools questions. There were also some regular behavioral questions at the end.

After the technical round, there was no response from the recruiter regarding the next step. I had to follow up after almost a week, and in the meantime, I received another offer. I informed the recruiter of my status and tried to have him accelerate the process. As usual, it was not a smooth process for scheduling. Finally, the panel interviews were scheduled for the day before I needed to get back to the other company. The panel round was about three and a half hours, with a technical product manager, hiring manager, a senior member of the team, and the director of the team (45 minutes with each person), followed by a 15-minute wrap-up with the recruiter. This round was quite intensive, with a mix of typical DWE technical questions and behavioral questions (lots of questions on how to handle priorities). The team was looking for a much more technical candidate for this role. After all the 45-minute rounds with the team, the recruiter was supposed to wrap up the interview for 15 minutes. Guess what? He did not show up to the Zoom call and did not respond to my emails either. I waited on Zoom for an extra 10 minutes, but it was a no-show in the end.

Obviously, I needed to get back to the other company the next day and was hoping to get some sort of response from Chewy. However, the recruiter did not respond at all, knowing that this was a time-sensitive situation. The day after I accepted the other offer, the recruiter sent a formal rejection email without any apology for the no-show!

To be honest, I like Chewy as a company, but come on! Please hire better people to do the recruiting job! This is literally the worst experience I have ever had with any recruiters. The bare minimum principle: be respectful and professional!

What's slowly changing dimension?

What's the difference between row-based and column-based databases?

How do you diagnose code that's running very slow? What kinds of performance tuning techniques do you know?

Tell me about a time you said no to a customer. What happened, and how did you handle it?