Made it as far as the Online Assessment. Two questions only, so pretty fair in that regard, but it meant that 50% of my assessment was contingent on my knowing a lot of SQL queries, which I don't really use past DDL since everything is usually done through the ORM apart from sanity checks, but this SQL question was much more involved than that. I'll also add that SQL wasn't mentioned in the job description I applied for. In the coding question, I couldn't figure out what they actually wanted. I keep reading how other people had questions that were easy or at least straight forward, but the one I had didn't make sense even in the examples they gave and was written rather obtusely. So I was left trying to figure things out from the context of the input arguments and tests. I think I would have figured it out given more time, but 50 minutes and under pressure... Anyway, it was HackerRank, so always remember to hit "submit" whenever you make progress, I forgot to do that after making significant progress on the SQL question. Maybe brush up on your SQL as far as filtering and grouping, calculations and decimal places.

Asked various theoretical questions, mostly focusing on things to do with data. Asked questions about efficiency and how you would ensure it, as well as asking what experience I had with testing