I applied through a recruiter. I interviewed at Toptal
Interview
Horrible process. Had a phone screen for 30 minutes. It all went great and the recruiter sold the job quite well to me. I really liked it and it aligned well with my skillset.
Then I was told I needed to take a 90 minute skill assessment. The first question I knocked out in about 15 minutes. The second one was a challenge as the code I wrote would not run on their virtual machine. The last question was a question that I had never seen before, and not even relevant to the job. Also it was not even in the job description.
This isn't the first time this company has done this to their candidates. Avoid this place at all costs.
Interview questions [1]
Question 1
2 SQL questions and one python. The job description made zero claim to require python skills. Besides the question at hand was geared towards engineering vs analysis.
The first question required basic aggregation, group by, and maybe a having statement. The big issue is you cannot run dummy code like select * from table to get a feel for the data. The second one was a question that required recursion that kept throwing errors. I was about 99% there but it kept throwing an error that wouldn't clear. Last question was 100% a data engineering question, and nothing around analysis.