Meta Data Engineer interview questions

Typical recruiter screening, followed by phone screen. 3 SQL and 3 python questions. SQL is medium to hard level and python is easy to medium. Practice SQL on Percentages and aggregations

Applied online and started with a recruiter screen - background, past projects, and culture fit. Next was a Technical Phone Screen with a Data Engineer, split into two parts: SQL - where I wrote queries using joins, aggregations, subqueries, and handled NULL values, and Python - which involved simple data manipulation tasks like working with lists, dictionaries, and condition checks. The final onsite round had four back-to-back interviews. The first was SQL/ETL- focusing on optimizing queries, transforming raw data, and designing ETL pipelines. The second was Data Modeling - where I had to design a relational database for an app, define schema, and discuss trade-offs. The third was Product Sense - evaluating how data impacts decision-making and defining key metrics for business scenarios (e.g., retention analysis for a gaming app). Last was Behavioral/Ownership - covering standard "tell me about a time" related to collaboration, problem-solving, and stakeholder management. Prepped with LeetCode, SQL practice (Mode, StrataScratch), and mocks on Prepfully with ex DE. Got the offer :)