Preliminary phone screens and conversations where great. This was followed by an assignment emailed by the company that I had to complete.
Unfortunately, the in-person didn't go very well. Two rounds into the interview, it was evident that some of the interviewers weren't prepared. A few of them didn't know what roll I would fit in. And some of the questions that the interviewers were hovering on were college-grad level SQL syntax.
No serious project issues were discussed. If they were, it was unclear.
By the third round, it was clear that I was being measured up for aN Application support engineer and that is to address lot of locking and query tuning issues on the fly.
I decided not to pursue this position.