Data modeler interview questions shared by candidates
They ask me to draw a diagram on 3rd. NF based on a file with a certain format he provided on the board that included fields like "Physician name", "date of service", "Physician type" , etc. I modeled and it was great then he ask me to do it on star schema based on reports he wanted to produce. The scenarios requested were nor clearly defined ( Again no clear direction or any specifics ) bottom line the interviewer was looking for an answer he didn't provide much information and made things really confusing to me to design. At the end I designed what I best understand with the information I had he told me he wanted me to build bridge tables as a solution . Which industry standard dictates that are obsolete and causes performance issues. So it was not the best solution after all.
Its based on data modeling experience every one should have one.
See Interview Questions for Similar Jobs
- Medical Assistant
- Pharmacy Technician
- Sales Associate
- Pharmaceutical Sales
- Dental Assistant
- Registered Nurse
- Mechanical Engineer