Prepare for and practice interview questions from Slalom Consulting across topics like SQL, Algorithms, Python and more.

Slalom Consulting Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Slalom Consulting Interview Guides

<p>The HR department in your organization wants to calculate employees’ earnings.</p>

<p>Write a query to report the sum of regular salaries, overtime pay, and total compensations for each role.</p>

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

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

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

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

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

<tr>
<td><code>job_title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>overtime_hours</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>overtime_rate</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>job_title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>total_salaries</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>total_overtime_payments</code></td>
<td>FLOAT</td>
</tr>

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


HR Salary Reporting

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</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>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Slalom Consulting Interview Questions

Slalom Consulting Interview Guides

Slalom Consulting Interview Questions

Slalom Consulting Salaries by Position