Technology Interview Resources
Be sure to review the general interview tips on the Interview Success tip sheet as well – that guidance will still apply to technical interviews!
Use Biginterview!
- Choose the Competency (like Analytical Skills and Tech-general) and the Industry areas (like Technology) to build a Practice Set of interview questions.
Common Platforms for Tech Interview Skill Preparation
Essential Practice
- Neetcode: Most common questions from Leetcode with video explanations
- Hackerrank Kits: A great way to learn about Hackerrank question structure
- Leetcode 75: 75 essential interview question covering all basic interview topics and concepts
- Leetcode 150: Most common medium difficulty questions covering main topics in coding interviews, good for 2-3 month practice timeline
UMPIRE Strategy to solve a coding challenge
U: Understand the problem
M: Match the problem with the interviewer
P: Plan your approach and solution
I: Implement your solution
R: Review your solution
E: Evaluate your solution
Software Systems Design Interviews
Open-ended interview questions asking candidates to come up with a design/architecture for an app or a service. Topics may include API design, database design, microservices/components design, and high- level systems concepts.
Sample Questions:
Design a YouTube-like service.
Design a TinyURL.
Data Science Case Interviews
Open-ended interview questions asking candidates to develop an answer to the problem using data analysis and quantitative/statistical tests. Consider data limitations, possible analyses, and other external data sources that might be helpful when answering a question.
Sample Question:
Imagine that Facebook is building a product around high schools, starting with about 300 million users who have filled out a field with the name of their current high school. How would you find out how much of this data is real?
Databases & SQL Interviews
Topics may include: data warehousing, database partitioning, B-trees, Entity-Relationship Diagram (ERD), data normalization (first, second, third normal forms – know properties), writing SQL queries, creating views, relational databases/NoSQL databases, database security and data integrity.
Know basic SQL commands (select, sum/average/count, join on, order by, group by)
Other important concepts:
Join (full, left, right, inner, outer, implicit), usage of SQL flavors (MySQL/MariaDB, PostgreSQL, T-SQL, Oracle), set operations (e.g. union), SQL subqueries, recursive relationships, keys (primary, foreign, composite), entity relationships(e.g. one-to-one, one-to-many, many-to-many).