Applied on website on 8/15/2023. Recruiter reached out on 9/20/2023 and asked me to fill out a questionnaire (logistics and basic confidence in job requirements questions). After that, recruiter sent a Hackerrank SQL challenge. After completing the SQL challenge, recruiter wanted to have an introductory call. I talked with the recruiter, and she explained the interview process. She told me they will do 2 interviews, one on machine learning and one on statistics (30 mins each). They scheduled the interviews back to back in one single session with 2 different interviews, which was great for me. The first interviewer was different than the one they mentioned in the invite (which is fine, that happens). The interviewer told me that she will conduct both ML and statistics in her session, and the next one will be coding and business case. I was surprised because I specifically asked the recruiter if there is another coding interview or not, and she said no coding. I explained this to the interviewer, and she said "oh, we heard about that, the recruiter is giving the wrong information, and we are trying to fix it." I tried to not let my motivation go down, but I was stressed already because I was not ready to take on an unexpected coding challenge. Also, the interviewer never turned their camera on while mine was on. I guess that's on me because I could have turned it off as well. Anyways, the machine learning session was good, the questions were fundamental stuff, and I'm confident I replied them well (no statistics asked). Next interviewer joined a few mins late. She told me again this is going to be a coding interview (I also explained her that I was not informed about this but she didn't seem to care at all). She asked me about my background first, and we spent another 6-7 mins there. She shared her screen, and copied a SQL question on a doc on her screen. She told me I can either open a word doc and write my solution to it and then copy/paste it into zoom chat or I can just write on the zoom chat. The question was already a difficult one. I normally am confident in my SQL skills but I don't memorize every single corner case, and I just use google to solve problems, which is more important imo. I was a bit stressed because the interview was 30 mins total, she was already late, and the fastest way to write my solution was on zoom chat, where I can't even see more than 3 lines?!?! I told her I have ideas but I would need to check the syntax of the function because I don't exactly remember that. She told me we can move on to the next question just to save time. I said okay, and we moved on to the next question. At that time, we were already past half time. She also told me we have to stop 5 mins before for questions. The next question was also a difficult one but I had a solution in mind. However, it is very difficult to write the whole solution without seeing the lines I'm writing and without the interviewer seeing what I'm doing (I think it's important to show the interviewer my thought process rather than a correct answer, because there is no point in doing it live otherwise). I decided to open a word doc to write my solution and see it at the same time. I asked the interviewer if I can share my screen and show them what I'm doing but she rejected. So, I tried to explain my thought process to the interviewer by copy pasting every CTE I was working on to the zoom chat and explained what I'm doing, because I knew I could not finish it on time and didn't want to show my unfinished work without explaining what I'm thinking. Anyways, the time was up and I could not finish the problem. It was the worst interview experience I had. Also, I don't understand what kind of signals they can get from the candidate in such a poorly designed and thought interview process. I was on the other side of this process as well, and I know how important it is to design the interview in a way that they can understand the approach of the candidate to problems they need to solve.