Quick phone screen with recruiter asking basic questions about programming knowledge, 30 minute straightforward/easy technical questions to describe basics of listed programming knowledge, 2 1/2 hour interview meeting and talking with different teams and hiring manager. Walking through leetcode easy problems, conversation discussing resume, easy web development technical questions (JS/TS, HTML, CSS), walking through 2 simple "riddles" i.e. boxes of fruits/sock drawer, hiring manager assessing critical thinking/process using screenshot of business report, final SQL assessment while various team members converse, 3-4 simple SQL questions (joins/ aggregate).