My current job as a data engineer at a law firm. Phone interview on a Monday, second interview Thursday, offer letter Friday morning. The main technical question was describing the three main kinds of sql joins (left, inner, outer), besides that mainly talked about my schooling, projects, etc. Nothing super intense, just making sure I wasn't completely bullshitting about my experience and skills.

The SQL question was apparently a really good metric because a lot of people were applying for the job and couldn't do it, and the previous person was fired after a couple months when it became clear they had never used sql and weren't that good at programming in general (lots of lying on their resume). I found some of the garbage they made and it's... Really rough.

Been here a year and a half now as my first job out of college, chill remote job, good pay, and I love my coworkers