Capco
Practice questions for the skills this job lists, plus common questions for any interview. These are for practice: we don’t know the employer’s actual questions.
What is the difference between a list and a tuple, and when would you use each?
Python
How do generators work, and why would you use one over a list?
Python
Write a query for the second-highest salary in each department.
SQL
Explain the difference between INNER, LEFT and FULL joins with an example.
SQL
When would you use XLOOKUP or INDEX/MATCH, and how do pivot tables help summarise data?
Excel
What happens, step by step, when you type a URL into a browser?
Networking
Explain the difference between TCP and UDP and where each is used.
Networking
Walk me through the three financial statements and how they connect.
This kind of role
How would you build a simple budget versus actuals analysis?
This kind of role
What do you know about Capco's products and customers?
Capco
Tell me about yourself in two minutes, focused on this role.
About you
Why this company, and why this role?
About you
Tell me about a time you disagreed with a teammate. What happened?
About you
Describe a time you failed or missed a deadline, and what you changed afterwards.
About you