Candidatei-me online. O processo levou 3 semanas. Fui entrevistado pela Tickets.com em mai. de 2024
Entrevista
Interview process was average, had multiple rounds over which I met with the entire team. First two rounds had a SQL / Python technical assessment. I went into the MLB office in NY for final round, where I met the team VP.
Was told I'd expect a response from HR in 2 days. Did not hear back from HR after this. I followed up a few times, but recruiter kept pushing back her expected timeline for getting an answer. I stopped following up after a couple times and never heard back again.
Perguntas de entrevista [1]
Pergunta 1
Describe how you would get the median by group in SQL, given that median isn't an aggregate function
Candidatei-me por meio de recrutador(a). O processo levou 1 semana. Fui entrevistado pela Tickets.com em set. de 2023
Entrevista
Was initially approached by an HR recruiter, and had a relaxed initial chat. We set up a call with the data engineering team for an introduction/technical assessment.
On the into/tech assessment the panel was rather curt, not even bothering to do full introductions. We dove straight into a SQL test. After reading through the initial problem statement, I began to sketch out my code, and before I could even run anything, the lead guy told me the syntax was wrong and they wouldn't be continuing (it wasn't even anything crazy, the code would work in SQL Server, but not Postgres - oops?).
Two weeks later I was approached by another HR recruiter (both had internal email addresses) which just shows they're not even paying attention.