Here’s a revised version of your message:
The recruiters were very nice. However, when I moved on to the interview with the hiring manager, he was rude and kept downgrading my skills and experience. I advanced to the next interview phase, where they asked me to complete a case study and SQL queries. The case study didn’t have any specifics, so the analysis was open to interpretation by the interviewer. I spent time and energy on this, only for the hiring manager to be rude and display a superiority complex.
When I asked current employees about their role in the company they were not able to describe any of the projects. They only answered working on some KPIs dashboards.