I applied through a recruiter. The process took 2 weeks. I interviewed at Meta in Nov 2024
Interview
I was contacted by a recruiter for a 12-month contract position as a Data Engineer. The process started with an initial discussion about my experience and expectations, followed by a coding round.
Coding Round:
This round lasted one hour and involved:
SQL: Questions based on a schema with four tables, focusing on aggregation and joins.
Python: A problem to identify uncommon elements between two lists using only a brute-force method. The emphasis was on logical thinking and problem-solving. The interviewer was very helpful, encouraging discussions about my approach when I got stuck.
Other Rounds:
Cultural Fit: Questions based on high-impact scenarios from past experience.
Data Model Design and SQL: Designing a data model for a food delivery service and solving SQL questions based on it, e.g., identifying customers who didn’t order from a specific restaurant or at all.
Python Problem-Solving: Tasks included concatenating elements from lists in a dictionary and formatting concatenated items and values in a given structure.
Throughout the interview process, the focus was on problem-solving and discussion rather than just coding. The recruiter and interviewers were supportive, making it a positive and satisfactory experience.
Interview questions [1]
Question 1
1. Idenfy the uncommon elements between 2 list. You have to use only bruteforce method while solving it, You are not allowed to use set or anything. This is to test mostly your logical thinking.
2. Given a dictionary of 2 items if the values are lists then concatnte all the element from list1 with list 3 from the values.
3. Given a dictionary concatenate the item and values in certain format.
4. Design a data model for food delivery service.
5. Which of the customers did not order from a particula resturant (Lets assume the resturant id is 3).
6. How many customers did not order at all.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.