I gave my onsite interview last week , today recruiter called me and informed, in debrief the commitee rejected me and I can re apply after 1 year but there was no specific feedback, this was my first meta interview.

4*45 minutes rounds

1st interviewer - Coding - Python , SQL
a) read file contents and print 3 column from file
b) simulate real time feed
c) find 2nd highest salary
d) find number of unique combinations between rows in a table ( a,b b,c c,a)
e) EDW slowly changing dimensions handling in real time feed
f) What challenges you faced in data pipelines

This round was fairly easy , answered all questions

2nd round - Coding Python and SQL
a) Find customers making maximum purchases
b) Given a data frame perform .. sum and groupby
c) Questions around Complex ETL jobs and scheduling
d) How do you design datapipeline for twitter news feed so that spam are filtered out every time job executed
e) SQL LC easy- medium

Answered all questions but the interviewer wasn't agreeing on the assumptions and asked alternatives

3rd round Analytics manager - Behavioural - conflict resolution, tell me about a time for prioritisation, time commitment

this round was very easy I did answer all questions

4th round - Hiring manager

He was only typing my answers in this round and I kept talking.

Overall good experience but not sure what's the candidate hiring criteria given all the problems were solved.