Was contacted via Linked first by an recruiter agent with job description. First phone interview from recruiter, asking about basic common questions like current job situation, sample skills & matching job experiences, expected base salary. (I had to low-ball a bit my base salary expectation to even proceed, it was a VERY TOUGH job market / trade war recession out there).
Next it was online Codility test in Java and SQL with about 4 questions: 2 easy questions about SQL query of table sum summary & basic string character type detection, and 2 hard algorithm design problems about: making the largest integer possible by adding a "5" digit, and detecting word anagrams the number of different characters between 2 strings.
Then few weeks later, more phone interviews with the possible team manager, including more Java test questions and object oriented programming concepts and SQL databases.
About 3 days later, heard back from email about scheduled onsite in-person interview in the company the week after. The onsite interview lasted about 3 hours with 3 rounds. Got asked lots of tricky personality and in-depth about past working experience questions too, The later rounds include pen & paper direct test about Java programming & SQL. Questions including: fibonacci number program design, singleton program design, catch a while infinite loop in the printed code, class inheritance & type casting question, SQL select join statements and sum of prices....etc.
All these rigours interview process for just an entry-level technical support job that estimates to pay only about $50k CAD annually, of course much less after taxes. Extremely tedious and nerve wrecking.