Write queries for some database requests for given schema. Interviewer provided a schema and asked to write series of sql queries. Than I was asked about different join statements. Also was given few java code examples and was asked to detect bugs in it.

Contacted by company recruiter. Over 2 months had conversations with the recruiter, hiring manager, 3 engineers (with 2 coding exercises), and executive VP of Engineering. After this, was contacted by the hiring manager with a verbal offer significantly lower than my current total compensation (salary was in line, but significant lower with bonus and yearly RSUs). I was also informed that "We don't negotiate the compensation package." What a waste! I was decently excited about this position!