PolSource interview questions

Very strange interview experience. There were no questions on my experience or background or the project that I am currently working on. The interviewer straight away started asking questions on sql joins, union etc. I expected questions on my current role and my experience with Talend. Overall not a good experience. However the interviewer was friendly and made me feel comfortable. I should have prepared better.

Initial call and then two, 1 hour video interviews with current PolSource employees (very pleasant conversations). Final interview was a 4-person panel presentation for a case study presented. However, after the final interview, I was not given a final offer. The reason that the recruiter gave me was that I did not have enough Salesforce experience and they did not want to "put me in a position to fail." I clearly laid out in every interview that I had less than 1 year of SF experience. I spent 8 hours total with this interview process that ended up being a waste of time. Please think through this for future candidates as this was the worst experience I've ever had interviewing for a company.