Datacom Systems Intermediate Software Developer interview questions

1) HR asked questions in LinkedIn text message about visa status, expiration date and past experience. 2) Coding exercises on specialised web-platform: implement a function doing A, refactor code, write SQL query fetching specific data (with JOIN, ORDER BY, etc). It took 1.5 hours. 3) Conversation with a Technical Leader, he asked all kinds of questions about past experience, C# (garbage collector, structs, inheritance, etc) and SQL (how to optimise SQL query, what is indexes, etc). Questions was very hard, but very interesting. 4) Take home task - C#, ASP.NET Core, unit tests. Task was unclear, and you have to make some assumptions by yourself. 5) Two stage interview: Code Review + Conversation with Managers. On code review they ask about data validation, why used MVC, how to improve unit tests. On conversation with managers they asked about past experience and all kinds of behavioural questions, like how do you act in a conflict situation. Cool guys, it was fun. After that HR said in a phone call they decided to give me an offer and started background and reference checks (2 people). After a week HR called and said that my visa is shorter than a year and they can't hire me. 2 months and 5 stages of interviews, tonns of wasted time (my, Datacom employees, my referees) and all was to check my visa length at offer stage. Not at the start of interview process. Not to mention how HR ignored my questions and never confirmed that she received my code project. She was unprofessional from start to the very end. My personal verdict: HR is terribly unprofessional, but technical specialists are good. Salary is low though, but after 2 month of interview you are ready to accept any salary.