I applied online. The process took 3 weeks. I interviewed at Tickets.com in May 2024
Interview
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.
Interview questions [1]
Question 1
Describe how you would get the median by group in SQL, given that median isn't an aggregate function
I applied through a recruiter. The process took 1 week. I interviewed at Tickets.com in Sept 2023
Interview
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.