LinkedIn Data Science interview questions

I applied for the role at LinkedIn through LinkedIn only. After few days, I was reached out by the HR for the next steps. Firstly a technical online test was to be cleared. 1 Python question(it was very simple; if you work on Python) and 3 SQL queries were asked. On clearing this, first telephonic interview was setup in which I was asked a problem solving case study and 1 SQL query. After successfully clearing this round, onsite interviews were scheduled. Onsite is supposed to happen at LinkedIn office but since LinkedIn was working from home, so all of them were scheduled virtually on a single day. The onsite rounds started with data manipulation round (basically multiple SQL queries were asked from me which covered concepts of joins, CTE, aggregation etc.). Apart from data manipulation, there was a problem solving case study round, applied statistics round, data storytelling round and the hiring manager round. Each round went for 45mins to 1 hr. After all rounds, after 2 weeks I was communicated with the results. Just after the Interviews, I felt positive for the result since I was able to answer all the questions but, unfortunately the HR told me that due to lack of experience I was rejected. The interview experience was good with the kind & quality of questions which mainly focussed on SQL, stats and indepth case study based problem solving questions but overall i felt that if only I was to be rejected based on lack of experience, I should have been communicated at the start and should not have been shortlisted at the starting only. Felt this gap there within their interview process.

The recruiter contacted me himself via linkedin and showed interest. Then we had a call and he asked in which of their teams I am interested and when I selected the team, he aid we don't have hiring for this team right now and I'll update you soon when they have hiring. I contacted him several times after that and he never responded to my emails.