Got referred by someone who works there. The process took over 4 weeks. I had to email them 2 weeks after the phone screen to see what stage the process was at. They quickly organized an onsite interview after that.

First stage was a fairly standard HR phone screen. Second stage was an onsite interview with 2 department managers. They went through my past experience, asking questions. Then some technical questions, nothing too difficult, just basic OOP and RDBMS stuff. Finished with a few STAR competency-style questions.

Overall, the interview seemed a bit too laid back, and the interviewers didn't really push me. I got a strong vibe that they had already interviewed somebody that they were much more interested in for the role, and I was just brought in as part of due process or as a backup candidate. Feedback from the recruiter more or less confirmed this.

Difference between TRUNCATE and DELETE in SQL.

Describe the four types of access modifiers in Java.