Prepare for and practice interview questions from Nestlé.

Nestlé Interview Questions

Nestlé Interview Guides

Machine Learning

PCA and K-Means

Restaurant Recommender

Area Under the ROC Curve

Write a query to select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Employee Salaries

Cumulative Distribution

Given a users table, write a query to get the cumulative number of new users added by the day, with the total reset every month. 

Cumulative Reset

Statistics

What are the assumptions of linear regression?

Assumptions of Linear Regression

Analytics

Strategically resolving misaligned expectations with stakeholders for a successful project outcome

Stakeholder Communication

Product Sense & Metrics

WhatsApp Metrics

<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

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

Your Strengths and Weaknesses

Brainteasers

<p>What are the assumptions of linear regression?</p>


Which assumption of the residuals of the standard linear regression model can not be overcome by increasing the sample size?

Regression assumptions

<p>Talk about a time when you had trouble communicating with stakeholders. How were you able to overcome it?</p>


<p>What do you think are the most important metrics for WhatsApp?</p>


<p>What is the optimal strategy for reducing customer churn rate in a messaging platform like WhatsApp?</p>


What is the optimal strategy for reducing customer churn rate in a messaging platform like WhatsApp?

<p>What’s the relationship between PCA and K-means clustering?</p>


<p>What does the variable “k” in k-means clustering refer to?</p>


What does the variable "k" in k-means clustering refer to?

Input of K-means

<p>Given a <code>employees</code> and <code>departments</code> table, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.</p>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>departments</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>percentage_over_100k</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>department_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>number_of_employees</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


<p>Let’s say that you’re working at a global trading company and you’re analyzing the price of a particular asset over time. This dataset is super noisy, volatile, and you’re not guaranteed completely accurate data.</p>

<p>How would you analyze this data to ensure there aren’t any discrepancies?</p>


Time Series Discrepancies

Forecasting & Time Series

<p>How would you build a restaurant recommender on Facebook?</p>

<p>Start with how you would go about getting this data, then talk about how you would build it.</p>

<p>What are some downfalls or worries about adding this feature to Facebook?</p>


<p>Given the two tables, write a SQL query that creates a cumulative distribution of the number of comments per user. Assume bin buckets class intervals of one.</p>

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

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

<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>neighborhood_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>sex</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><code>comments</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>body</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>frequency</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>cum_total</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


<p>Given a <code>users</code> table, write a query to get the cumulative number of new users added by the day, with the total reset every month. </p>

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

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

<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>DATE</th>
<th>INTEGER</th>
</tr>
</thead>

<tbody>
<tr>
<td>2020-01-01</td>
<td>5</td>
</tr>

<tr>
<td>2020-01-02</td>
<td>12</td>
</tr>

<tr>
<td>…</td>
<td>…</td>
</tr>

<tr>
<td>2020-02-01</td>
<td>8</td>
</tr>

<tr>
<td>2020-02-02</td>
<td>17</td>
</tr>

<tr>
<td>2020-02-03</td>
<td>23</td>
</tr>
</tbody>
</table>


<p>Suppose you are given three models for a binary classification problem. Each model gives you a probability of an input belonging to class 1.</p>

<p>You are asked to build an area under the ROC curve metric to evaluate the model performance. Briefly explain how you will do that.</p>

<p>After you make the metric and make sure it works correctly, you apply it on three models and get the following results:</p>

<ul>
<li>Model 1: 0.1</li>
<li>Model 2: 0.5</li>
<li>Model 3: 0.8</li>
</ul>

<p>Briefly explain your evaluation of these models and choose one to use for the classifier.</p>


Challenge

Nestlé Salaries by Position

<strong>POSITION SNAPSHOT <br><br></strong>Location: Rayong<br><br>Company: Nestlé<br><br>Business Unit/Division: Technical and Production<br><br>Full Time<br><br>3-7 years of working experience in Electrical Engineering, Experience in design, calculation, testing, commissioning and maintenance in low voltage and medium voltage installations.<br><br> <br><br><strong>A DAY IN THE LIFE… <br><br></strong><ul><li>Ensure that all projects are sustainable and result in a positive impact on the company ROIC. </li><li>Prepare and manage the approval process in accordance with the Guidelines for Capital Investment thoroughly challenging the supporting documentation. </li><li>Design Phase: Ensure that all assets are well designed and meet the business requirements through applying new technologies, proven principles, thorough design reviews and basic science. </li><li>Collaboration with different stakeholders (like designer, suppliers, project team, factory maintenance, safety and production team) involved in his current project. </li><li>Ensure that the design is directed towards an optimum cost, highly efficient, reliable, and flexible operation and compliant to existing regulations. </li><li>Support Value Engineering Analysis (VEA) <br><br></li></ul> <br><br><strong>ARE YOU A FIT? <br><br></strong><ul><li>Degree in engineering, preferably Electrical with updated MV/HV license </li><li>In-depth knowledge of electricity (design, calculation, testing, commissioning and maintenance) in low voltage, medium voltage and high voltage installations. </li><li>With proven experience in handling such electrical installations, industrial utilities, building facilities (such as Lightings, CCTV, FDAS, Security Systems). </li><li>Good knowledge of local electrical code and standards. </li><li>Knowledge of Instrumentation, Process Control Systems. </li><li>Knowledge of MES (Manufacturing Execution System) , Automation and Digitalization. </li><li>Knowledge of food processing operations and technology. </li><li>Knowledge of manufacturing IT.</li></ul>

<strong>POSITION SNAPSHOT<br><br></strong>Location: Rayong<br><br>Company: Nestlé<br><br>Business Unit/Division: Project<br><br>Full time<br><br>3 years of experience in Project Management with knowledge of CAPEX management<br><br><strong>A DAY IN THE LIFE...<br><br></strong><ul><li>Involve in the planning and execution of projects related to Filler, Loader and Unloader machine.</li><li>Ensure that the installation of machinery complies with local laws and Nestlé standards.</li><li>Coordinate and led the planning, design, and execution of CAPEX projects across multiple teams, both locally and globally.</li><li>Oversee project scope, timelines, budgets, standards, and adherence to local laws and regulations.</li><li>Supervise project construction, contractor safety, equipment installation, commissioning, and handover processes.</li><li>Collaborate with local and global teams, consultants, vendors, and suppliers.<br><br></li></ul><strong>ARE YOU A FIT?<br><br></strong><ul><li>Bachelor’s degree in Engineering (Mechanical, Mechatronic, Automation, Electrical) or a related field.</li><li>A minimum of 3 years of experience in plant manufacturing or engineering, with experience in the FMCG sector being an advantage.</li><li>At least 3 years of experience in Project Management, with a strong understanding of CAPEX management.</li><li>Proven experience in third-party management and working with cross-cultural and cross-functional teams.</li><li>Strong negotiation, influencing, and conflict management skills.</li><li>Excellent reading, writing, and verbal communication skills in both Thai and English</li><li>Flexibility in working hours, as adjustments may be required due to different time zones of project teams.</li><li>Ability to work independently in stressful situations as well as collaboratively as part of a team.</li><li>Proficient in AutoCAD, SAP, and MS Project.</li></ul>

<strong>POSITION SNAPSHOT<br><br></strong>Location: Rayong<br><br>Company: Nestlé<br><br>Business Unit/Division: Project<br><br>Full time<br><br>3 years of experience in Project Management with knowledge of CAPEX management<br><br><strong>A DAY IN THE LIFE...<br><br></strong><ul><li>Involve in planning and executing of the project in secondary and tertiary packaging parts focus on flexible and rigid packaging</li><li>Coordinate and lead the planning, design and execution of CAPEX Project across multiple teams locally and globally</li><li>Oversee project scope, timeline, budget, standards, local laws and regulations</li><li>Supervise project construction, contractor safety, equipment installation, commissioning and hand over</li><li>Collaborate with local and global teams, consultancy, vendors and suppliers<br><br></li></ul><strong>ARE YOU A FIT?<br><br></strong><ul><li>Bachelor’s degree in Engineering (Electrical, Mechanical, Mechatronic, Automation) or a related field.</li><li>A minimum of 3 years of experience in plant manufacturing or engineering, with experience in the FMCG sector being an advantage.</li><li>At least 3 years of experience in Project Management, with a strong understanding of CAPEX management.</li><li>Proven experience in third-party management and working with cross-cultural and cross-functional teams.</li><li>Strong negotiation, influencing, and conflict management skills.</li><li>Excellent reading, writing, and verbal communication skills in both Thai and English</li><li>Flexibility in working hours, as adjustments may be required due to different time zones of project teams.</li><li>Proficient in AutoCAD, SAP, and MS Project.</li></ul>

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

Nestlé Interview Questions

Nestlé Interview Guides