Medidata Solutions interview questions

Applied through a referral and recruiter reached out and sent me a simple SQL test. Then, - 30 min screening with hiring manager. - After that, another 90 min SQL test with an engineer -I was asked to write SQL queries and a stored procedure. - After clearing SQL tests, 4 rounds of 30 min interviews with engineers and a director, where we discussed about past experience and some projects on my resume, some technical questions and some behavioral questions Cleared all rounds and had positive experience. Everybody in the team liked me and they asked for salary expectations. Recruiter was almost certain about offer but in the end, they ghosted me. No offer, no explanation about why there was no offer. The whole process took about 2 months.

recruiter approached me online , they said that my profile looks match for their job description and sent me an SQL test and again contacted me hiring manager interview it was ok, after one week I contacted them to get the update and they said i was not the candidate they're looking for. after one week they approached me again and wanted to do some complex sql, so I spent some time finishing it and they said wanted to do the peers interview, which was with three team members different interviews, one to one, again they ghosted me for a week and tried to reach them but the reply was surprised, they said the team was happy but they wanted to change the job requirements, and they said I was not selected, then one week passed, again I saw the same job description on their LinkedIn page without any single character missing.