Meta Data Engineer I interview questions

The recruiter reached me on linkedIn , we set up a phone screen which was more about the position. Then I had technical coding interview on coder pad with an other data engineer, Its not hard at all, all basics question around string,list, dictionaries. i answered 5 Sql and 5 python questions total of 1 hour. Finally, I had my on site interview. for some reason the recruiter called the question full stack questions but there is no css or JS coding involved. All on site questions are regarding DW design, table design, Schema design and etc. The interviewers ask sql questions based on the DW that I designed for them. The onsite questions are no match with coder pad interview. You need to have a good understanding of system architecture and system design. I personally could not finish a python question . The question was about updating metrics (I defined the metrics to answer earlier question) for a fb module as stream of new data is coming in. As interviewer point out I was on right track having a session id and user id to de-dup same user activity, but it was not enough i guess. My impression was they want someone who answers quickly and smoothly in all questions. I literally just missed 25 % of a python question and I got rejection. Also I got the feedback that I have good product sense and coding experience which made me fee like they expect you answer all of their questions. One last note: They ask questions to make sure that you are not using data engineer position to switch some other questions like data scientist or etc , i heard a friend aced the technical but was rejected because of that in the last round.