I applied through an employee referral. The process took 2 weeks.

The SQL questions are typically medium difficulty, involving joins, aggregations, window functions, and CTEs, often tied to real business scenarios like retention or funnel analysis. The coding questions (mostly in Python) lean toward easy to medium difficulty and cover arrays, strings, hashmaps, and 2-pointer techniques. Focus your prep on Meta-tagged LeetCode and StrataScratch problems, especially in SQL and data-heavy logic, and practice writing clean, performant queries.

There were SQL questions, Python questions, and data modeling.

Facts:

• Discuss different types of facts and their grain.
• Explain the pros and cons of your fact design.
• Don't be afraid to give more than one fact table.
• Identify primary keys, foreign keys, and relationships (1 to 1, 1 to M).
• Pay attention to the grain you defined.

Dimensions:

• Give attributes.
• Discuss bridge tables, SCD Type 2, and role-playing dimensions.
• Explain the pros and cons of each type in terms of performance.