Do not bother wasting your time with this company. As others have said - recruiter will ghost you after final round (for me it was for 2 weeks), only to deny you. Waste of time and energy! Do you really want to work for such a company who cannot even give you an update within a week of your interview?
Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela Shipt (New York, NY) em set. de 2024
Entrevista
Initial recruiter screen only--ONLY--asked if I was willing to accept a role with two days a week in-office, and with a hard cap on base salary of $160k. (Despite the salary range in the job posting being $120 - $240k.)
Next round was a SQL tech screen, which was one of the WORST I have encountered in my career thus far. It was a 45 minute whiteboard, with no schemas, no table samples, and the expectation that I would get the solution line-perfect. The questions were fairly clearly specific puzzles they had come up with, based on their production data, and required techniques that would never be appropriate for a production environment. One of the solutions required knowledge about a product_id field that I was never given.
I withdrew from the interview process after this.
Perguntas de entrevista [1]
Pergunta 1
Given a long-formatted dataset, write a query to return the top 10 items most commonly sold together