Meta Data Engineer interview questions

A recruiter from the US reached out to me on LinkedIn. After a very friendly and informative chat on the phone where the role and interview process were laid out to me, I was scheduled for a one-hour phone screen with a team in the US, which I thought was very helpful as it meant I didn't need to take any time off work (I'm based in London). Phone screen was 4 SQL questions based off a fairly generic retail chain schema, and then 4 Python algorithms to solve. I answered all four SQL questions but only 3 on Python as we ran out of time. Overall the phone screen was a good experience and the interviewer was pleasant to talk to and responsive as I talked through the problems with her. Less than 24h later, I got a response from my recruiter who congratulated me on passing the phone screen. I was then passed on to a London-based recruiter who contacted me a couple of days later and walked me through what to expect on the onsite and gave me some preparation material (which I suggest you have a thorough read through and practice in your own time - honestly this was essential to my success) and a date was set for two weeks time. When I arrived onsite I was greeted by one of the talent coordinators and taken to a room with a giant whiteboard. My first interview was a behavioural screen, and unfortunately this is the one part of the process that I really wasn't impressed by. I was asked fairly generic questions by an interviewer who was clearly reading them verbatim from a laptop screen. There was no follow up to any questions and no real discussion to be had which felt a bit deflating - it was almost as if the interviewer was not invested in the process or in me as a candidate, but from reading online this is fairly standard so I didn't take it personally. This was followed by three technical rounds assessing my product sense (what metrics would be good to capture for x scenario) and then writing SQL and Python code. In one of them I also had to design an OLAP schema for a product and write queries on it. It was challenging but fair. All three interviewers were incredibly engaging and I genuinely felt that they wanted to get the best out of me and see me succeed. In many ways it felt more like a brainstorming session rather than an interview which made it a really fun process. Halfway I was also given an office tour by an engineer who wasn't interviewing me and had a short break in the cafe. It was a good chance to get a feel for the office culture. After it was all over, it took three working days to receive feedback and get an offer sent through. Again, the recruiter here was fantastic and took the time to talk through the package and all of the benefits. I accepted. Overall, the recruitment and interview process at Facebook was one of the best professional experiences I've ever had. The preparation I did beforehand and the onsite itself really sharpened my skills and made me push myself and discover what I'm capable of. The whole process was also managed incredibly well by both the interviewers and the recruitment team. I now can't wait to get started!

I was contacted by a facebook recruiter in April for a data engineering position in their Menlopark location. I scheduled my phone screen in May and got past the phone screen. It mainly consisted of SQL questions mentioned in other posts here. The next ppart was Coding in python which was fairly simple too. By the time i got result of my phone screen, the position I was interviewing for got filled. The recruiter contacted me again when they had an opening in the NYC office. I was invited to Menlopark for the onsite. There were 3 rounds of technical interview, one ownership interview and one lunch meeting. The questions were fairly easy, they just want you to be comfortable in SQL and basic data structures.