Product Sense & Data Modelling Interview Scenarios with Archana Goyal

This digital guide is designed for candidates preparing for interviews at top product MNCs like Meta, Netflix, Uber, Atlassian, Airbnb, DoorDash, and Amazon. It goes beyond theory and brings real-world, scenario-based interview questions covering Product Sense, Data Modeling, ETL, and SQL.

Each scenario comes with a step-by-step solution framework that includes:

• Key metrics to define and track
• Structured approach to break down the problem
• Complete data model designs (fact & dimension tables)
• SQL queries to implement metrics
• Edge cases & scaling considerations that interviewers love to ask

The content is drawn from actual interview patterns at major product companies, helping you practice end-to-end product thinking: from defining success metrics, to designing robust data models, to writing performant SQL and ETL solutions.