Meta Data Engineer interview questions

A recruiter reached on linkedin and set up an initial call to discuss about background. Next was two phone screens - 1) SQL 2) Any preferred language (I picked Python) Each phone screen is 45 minutes and you are asked about 6-7 questions. The questions are relatively straightforward if you are comfortable with basics. In coding interview, they are trying to see if you can approach the same program in two different ways - one using inbuilt methods and one without using in built methods

The interview process was pretty streamlined. First, I received an email from the HR asking for an informal discussion. After I set up a time, we had almost a 50 minutes discussion about what I have worked in past and what are my skill sets. Also, the HR explained me about the job profile in detail. After a couple of weeks, the HR confirmed to me about the telephonic rounds. There were two back to back telephonic rounds, coding followed by an SQL round. For the first round, I was called around 5 minutes late for the interview. The interviewer asked me about my previous work experience and then asked to start coding. The questions were pretty simple and I could answer all of them. There was one that required little thinking but I eventually solved it. I already had my next round of interview scheduled so the interviewer said that he could not ask me further questions. It was a very abrupt end to my interview although I solved all the questions. The second round was on SQL queries and this was really easy to crack. The queries were complex but I knew the concept and so could form them correctly. Only the last question asked for little complex related to cross join. I managed to answer but could not get the correct answer. This interview lasted longer than 45 minutes. The interviewer was very friendly and communicated very professionally. After both the rounds, I was very confident that I had cracked the interview as I could solve all the questions asked. But unfortunately, I got an email after a week saying that I have not cleared the round. This was very surprising to me as I kept wondering where I went wrong. I asked the recruiter about a feedback but she refused to give any. I don't know if it's their mistake or what but I still wonder what went wrong.