Loading page
Mindtickle
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
How do goroutines and channels work? How do you avoid a goroutine leak?
Go
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
How would you find and fix a slow query in Postgres (EXPLAIN ANALYZE)?
PostgreSQL
What are transaction isolation levels, and which problems does each prevent?
MySQL
What causes a component to re-render, and how would you stop unnecessary re-renders?
React
Explain useEffect's dependency array with an example of a bug it can cause.
React
Design a simple, highly available web app on AWS. Which services and why?
AWS
What's the difference between an IAM role and an IAM user?
AWS
Walk me through a project you built: the design, a hard bug and what you'd change.
This kind of role
Reverse a linked list, then explain its time and space complexity.
This kind of role
How would you design a URL shortener?
This kind of role
What do you know about Mindtickle's products and customers?
Mindtickle
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