Plenty of projects in multiple industries.
Not a well-defined career path.
Thank you for the opportunity to interview for the Data Modeler position at Capgemini. I appreciated the chance to meet with the team and learn more about your products, data strategy, and culture.
What is the difference between conceptual, logical, and physical data models? Explain normalization vs. denormalization with examples. Discuss types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs)
It was good. The questions were related to Oracle snapshots, Erwin, PL/SQL-like rollback, the difference between RANK and DENSE_RANK, error handling mechanisms, types of dimensions, SCD, and types of data models.
Thank you for the opportunity to interview for the Data Modeler position at Capgemini. I appreciated the chance to meet with the team and learn more about your products, data strategy, and culture.
What is the difference between conceptual, logical, and physical data models? Explain normalization vs. denormalization with examples. Discuss types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs)
It was good. The questions were related to Oracle snapshots, Erwin, PL/SQL-like rollback, the difference between RANK and DENSE_RANK, error handling mechanisms, types of dimensions, SCD, and types of data models.