I applied online. The process took 1 week. I interviewed at X in Jun 2019
Interview
Interviewed by hiring manager for role at twitter services....basic SQL question.. ...was given enough time to think through and submit solution....but I happen to reschedule my next interview call for data science interview cos of sm urgent work assignment...never heard back after that...
no further communication.... was disappointed by lack of professionalism on part of twitter...I felt hiring companies feel they have leeway in re-scheduling but if a candidate does same they feel offended.... I feel good that I did not ended up with this team with narrow mindset...and will ask all candidates to be mindful of red flags yu see while interviewing...
I applied through other source. I interviewed at X in May 2021
Interview
Very bad experience since the interviewer did not know how to conduct the interview. Basic things like having the video on while interviewing was missing. It was really awkward since I was the only one with my video on and did not understand how the interviewer was feeling during the process. During the interview, he left and was eating food as I couldn't hear him for a while and then I heard him chewing food. That's not even the worst part. I had a technical interview on SQL, Python and probability. In SQL, he asked me to open an editor and start writing code on a hypothetical table. Other places where I have interviewed, hire companies like hacker rank where there is a legit database and you can check your code in that. I've taken SQL interviews myself for my previous employer and that's not how I do it. It was very weird since I like to visualize my sub queries on the database and then write my code. Fortunately I was able to write all codes correctly. Then I had probability question which he first explained incorrectly and then changed in the middle and then when I started explaining him my thought process for this conditional probability question, he interrupts me and says don't tell me your process, just tell me the final answer. That's a wrong way to interview someone. You want to test their problem solving skills and not the final answer, I could have easily have someone sit next to me and google the answer. Anyway, I tell him the answer then he tells me it's wrong, then he says do you have any questions for me, I ask him what's the answer for that probability question and he says google it. Then a min later he says the answer and the says oh no, that's not the one. it's this(other answer). He did not know the question and answer himself. If I would have asked him to explain it, he wouldn't have been able to answer. Pathetic interview process. I have no respect for twitter. This guy was in India and was interviewing for customer experience team. Very unprofessional. Discomforting. Disrespectful.
Interview questions [1]
Question 1
Basic SQL questions using window functions like rank and some join questions and then same questions in python. probability was pretty standard - I did not expect them to ask me that. They did not tell me what they were going to interview me on.