It's worth noting that this paragraph is an edit, just to say that my experiences overall echo the other dev-based interview on here, which I wish I'd read before I bothered with the whole ordeal.
Three parts. Firstly a chat with a lead dev + CIO for an hour. This was fine.
Fairly lengthy coding test for the second part, a mixture of C# & SQL. Once again this was fine, if not a little lengthy and frustrating (cannot use external libraries which made a two-minute task take considerably longer).
Final round was another hour interview, covering some technical questions and a live SQL coding challenge with the head of software dev.
The final stage is where the wheels came off for both them and me. The connection was so bad on Zoom, which got blamed on me, until it got so bad he got chucked off, and admitted the vpn his side had also gone...
Had to answer questions in this environment, hearing about 50% of what was being asked between freezing webcams and jumbled sound.
Eventually we gave up, and carried on the next day. The live SQL challenge was a bloodbath. I had to take control over Zoom, and RDC into another computer from his, which meant each character took over a second to appear on screen. I got questioned on my touch typing ability whilst this was going on.
I also couldn’t use any special characters due to the keyboard layout on his computer, which meant I had to ask for !”£$%^&*() to be typed for me every time. It was a shambles. The interview was like being hit with a blunt object repeatedly and was ended in about three seconds.
Naturally, I didn’t get the job. As expected I had to chase the recruiter myself over two weeks after the final interview. To his defence, he gave me a cookie-cutter response which is more than you get from most.
Wouldn’t have accepted the job either way, but it’s a shame the last stage was such a farce.