Models Interview Questions

3,576 models interview questions shared by candidates

given two tables, how does left join work when there are duplicates of the index on which we are joining in the first table (rank, aggregation)+ if there are multiple entries of the same type of an index in an table (lets say id), how would we get the max value of another column (‘age’) for each unique ‘id’ How to one hot encoding without the library difference b/w linear and logistic regression Roc-auc precision, recall - where is it used in case of imbalance dataset, which metric is suitable if we make the dataset balanced, can we still use those metrics? Which is a better metric - roc or f-score Python classes
avatar

Model Risk Manager

Interviewed at Société Générale

3.7
Jul 24, 2024

given two tables, how does left join work when there are duplicates of the index on which we are joining in the first table (rank, aggregation)+ if there are multiple entries of the same type of an index in an table (lets say id), how would we get the max value of another column (‘age’) for each unique ‘id’ How to one hot encoding without the library difference b/w linear and logistic regression Roc-auc precision, recall - where is it used in case of imbalance dataset, which metric is suitable if we make the dataset balanced, can we still use those metrics? Which is a better metric - roc or f-score Python classes

Your stakeholder is getting the wrong numbers out of a report. How do you solve this? The report is generated by a process you don't have visibility into and there is no documentation of. After some probing: you've isolated the problem to a particular upstream process, but you don't have access to it and the manager in charge will not give you access or documentation. You need to unblock your stakeholder within two days. How do you do it?
avatar

Data Modeler

Interviewed at Fidelity Investments

4.1
Aug 12, 2025

Your stakeholder is getting the wrong numbers out of a report. How do you solve this? The report is generated by a process you don't have visibility into and there is no documentation of. After some probing: you've isolated the problem to a particular upstream process, but you don't have access to it and the manager in charge will not give you access or documentation. You need to unblock your stakeholder within two days. How do you do it?

Tell me about your background Can you give me an example where you've worked on a large business case type project? Can you give me an example where youve engaged with senior stakeholders across the business and how would you approach them? Why do you think you are a fit for the role?
avatar

Financial Modeler

Interviewed at Royal Mail

3
Nov 21, 2025

Tell me about your background Can you give me an example where you've worked on a large business case type project? Can you give me an example where youve engaged with senior stakeholders across the business and how would you approach them? Why do you think you are a fit for the role?

Viewing 1921 - 1930 interview questions

Glassdoor has 3,576 interview questions and reports from Models interviews. Prepare for your interview. Get hired. Love your job.