I was contacted by a recruiter. We talked about my skillset and what I had been working on and determined that dealertrack might be a good fit. They sent over a hackerrank problem that is pretty easy (it had to do with string manipulation) that you have to complete in three hours. After that, they do a phone screen for 30 minutes, and after that they bring you in for an onsite. They tell you to block out 4 hours, but if at any point you "fail" then you are sent home immediately.
I made it through the first interview which was basically an hour of trivia - what is x, y, and z type stuff related to javascript, OOP, html/css, C#, and more. After that, the 2nd manager came in and started with some more C#/OOP questions then had me code a problem on the whiteboard that was pretty easy - (I didn't use LINQ but I'm sure I could've gotten bonus points if I did).
After that, he went into a database design question where he started me with two tables and said I can modify and control the DB any way that I'd like, and then started asking a series of SQL questions. If the query he asked for couldn't be answered, then you were supposed to alter the DB so it was designed well for the query. This is the part I failed at, and I don't think it was a particularly hard DB problem- I just don't have any experience with DB design.
When I tried my best, the manager told me my design was bad. I told him that I don't have any experience in DB design (and my resume also didn't indicate that I did).
After I told him that I don't have DB design experience, he abruptly ended the interview and then somebody else came and told me that that was all they had wanted to see for the day.
It left a bit of a sour taste in my mouth just because I felt like they hadn't warned me or asked if I had a skill, and it's one that I don't have on my resume, and then they tested me on it, then told me I wasn't what they were looking for. I felt like they wasted a lot of my time since I could have told them up front that if they were looking for that then I wouldn't have been a good fit.
Every company wants to get good developers. Some care more about the high-level problem-solving ability, others focus more on previous experience and a defined skillset. This company felt like it focused on the latter (which can be a good or a bad thing, depending on your perspective).