General questions from Fragma Data Systems data engineering interviews.
These general questions are sourced from Fragma Data Systems data engineering interviews. Each includes an expert-level answer. This set leans toward fundamentals — 3 easy, 2 medium, and 1 hard questions. Recurring themes are join, partition, and sql — these patterns appear most often in real interviews and reward the deepest preparation. Many of these questions also surface at Aarete and Dunnhumby, so the preparation transfers across companies. Average answer is around 1 minute of reading — plan roughly 1 hour to work through the full set thoughtfully.
This collection contains 6 curated questions: 3 easy, 2 medium, and 1 hard. There's a strong foundation of fundamentals-focused questions — ideal for building confidence before tackling advanced topics.
The most frequently tested areas in this set are join (2), partition (2), sql (2), bigquery (1), etl (1), and snowflake (1). Focusing on these topics will give you the highest return on your preparation time.
Start with the easy questions to warm up and solidify fundamentals. Medium-difficulty questions form the bulk of real interviews — spend the most time here and practice explaining your reasoning out loud. Hard questions often appear in senior and staff-level rounds; attempt them after you're comfortable with the basics. For each question, try answering before revealing the solution. Use our AI Mock Interview to simulate real interview conditions and get instant feedback on your responses.
What is the difference between OLTP and OLAP?
What is the difference between SQL and NoSQL databases?
Are you open to learning new tools and technologies?
Describe your approach to managing data deduplication.
How would you incorporate data security and access control?
Walk me through your resume.
Get full access to 1,800+ expert answers, AI mock interviews, and personalized progress tracking.