Practice for the Slalom Consulting interview with these recently asked interview questions.
| Question | Topic | Difficulty |
|---|---|---|
Query Optimization | Medium | |
Let’s say you’re a data engineer at Fidelity Investments, and you’re running a SQL query on a cloud-based data warehouse. All cluster resources and network health metrics look normal, but the query is still taking over 10 minutes to complete. How would you go about diagnosing and improving the performance of this query? | ||
SQL | Medium | |
Product Sense & Metrics | Easy | |
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at Slalom Consulting?
Most data science positions fall under different position titles depending on the actual role.
From the graph we can see that on average the ML Engineer role pays the most with a $220,000 base salary while the Business Intelligence role on average pays the least with a $86,257 base salary.
Discussion & Interview Experiences