TransUnion
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.
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
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
How would you deploy and scale a web API on Azure?
Azure
Compare Cloud Run, GKE and App Engine for a new service.
Google Cloud
How do partitions and consumer groups give Kafka its ordering and scaling guarantees?
Kafka
Pick a product you use daily. What would you improve, and how would you measure it?
This kind of role
How do you decide what to build first when everything is urgent?
This kind of role
What do you know about TransUnion's products and customers?
TransUnion
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