Prepare for and practice interview questions from Wood Mackenzie across topics like Presentation, SQL, Product Metrics and more.

Wood Mackenzie Interview Questions

Wood Mackenzie Interview Guides

Brainteasers

How would you answer when an Interviewer asks why you applied to their company?

Why Do You Want to Work With Us

What do you tell an interviewer when they ask you what your strengths and weaknesses are?

Your Strengths and Weaknesses

Data Structures & Algorithms

Transform a dataframe containing a list of user IDs and their full names into one that contains only the user ids and the first name of each user.

First Names Only

<p>When an interviewer asks a question along the lines of:</p>

<ul>
<li>What would your current manager say about you? What constructive criticisms might he give?</li>
<li>What are your three biggest strengths and weaknesses you have identified in yourself?</li>
</ul>

<p>How would you respond?</p>


<p>When asked about your strengths in an interview, what is an effective way to respond?</p>

When asked about your strengths in an interview, what is an effective way to respond?

Your Strengths and Weaknesses I

<p>Which of the following is an acceptable strategy when discussing weaknesses in an interview?</p>

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Your Strengths and Weaknesses II

<p>When an interviewer asks you a question along the lines of:</p>

<ul>
<li>Why did you apply to our company?</li>
<li>What are you looking for in your next job?</li>
<li>What makes you a good fit for our company?</li>
</ul>

<p>How should you respond?</p>


<p>When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?</p>

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

Why Do You Want to Work With Us I

<p>How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'</p>

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

Why Do You Want to Work With Us II

<p>When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?</p>

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

Why Do You Want to Work With Us III

<p>You’re given a dataframe containing a list of user IDs and their full names (e.g. ‘James Emerson’).</p>

<p>Transform this dataframe into a dataframe that contains the user ids and only the first name of each user.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<table>
<thead>
<tr>
<th><strong>user_id</strong></th>
<th><strong>name</strong></th>
</tr>
</thead>

<tbody>
<tr>
<td>1034</td>
<td>James Emerson</td>
</tr>

<tr>
<td>9430</td>
<td>Fiona Woodward</td>
</tr>

<tr>
<td>7281</td>
<td>Alvin Gross</td>
</tr>

<tr>
<td>5264</td>
<td>Deborah Handler</td>
</tr>

<tr>
<td>8995</td>
<td>Leah Xue</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th><strong>user_id</strong></th>
<th><strong>name</strong></th>
</tr>
</thead>

<tbody>
<tr>
<td>1034</td>
<td>James</td>
</tr>

<tr>
<td>9430</td>
<td>Fiona</td>
</tr>

<tr>
<td>7281</td>
<td>Alvin</td>
</tr>

<tr>
<td>5264</td>
<td>Deborah</td>
</tr>

<tr>
<td>8995</td>
<td>Leah</td>
</tr>
</tbody>
</table>


Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

Wood Mackenzie Interview Questions

Wood Mackenzie Interview Guides

Wood Mackenzie Interview Questions

Challenge

Wood Mackenzie Salaries by Position

Discussion & Interview Experiences

Discussion & Interview Experiences