Modeling Engineer Interview Questions

4,817 modeling engineer 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 231 - 240 interview questions

Glassdoor has 4,817 interview questions and reports from Modeling engineer interviews. Prepare for your interview. Get hired. Love your job.