Data Modeler Interview Questions

3,696 data modeler interview questions shared by candidates

What is the difference between conceptual, logical, and physical data models? Explain normalization vs denormalization with examples. Types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs) in dimensional modeling? Star schema vs snowflake schema. What is a surrogate key vs natural key?
avatar

Data Modeler

Interviewed at Capgemini

4.1
Jul 1, 2025

What is the difference between conceptual, logical, and physical data models? Explain normalization vs denormalization with examples. Types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs) in dimensional modeling? Star schema vs snowflake schema. What is a surrogate key vs natural key?

Viewing 191 - 200 interview questions

Glassdoor has 3,696 interview questions and reports from Data modeler interviews. Prepare for your interview. Get hired. Love your job.