Data Modeler Interview Questions

993 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 61 - 70 interview questions

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