Top 27
Prep plan
Updated weekly · Last refresh Aug 30

Berkshire Hathaway Homestate Companies Software Engineer Interview Questions

The questions to prepare for a Berkshire Hathaway Homestate Companies Software Engineer interview. Questions from real interview reports rank first. Updated weekly.

27questions
~4htotal time
Track your progressSign up free to work through all 27 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 1 drill · ~73 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsBerkshire Hathaway Homestate Companies
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingBerkshire Hathaway Homestate Companies
Clustered vs Non-Clustered IndexesMedium

Explain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.

JoinsData WranglingBerkshire Hathaway Homestate Companies
Optimize Query to Avoid Table ScansHard

Tests performance tuning skills using execution plans and indexing strategies.

JoinsRankingData WranglingBerkshire Hathaway Homestate Companies
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
More SQL & Data Manipulation questions with a free account
2
Coding17 questions · ~154 min
Difference Between Interface and Abstract Class in JavaMedium

Explain the differences between interfaces and abstract classes in Java and when to use each.

Hash TablesArraysStringsBerkshire Hathaway Homestate Companies
Generational GC Promotion MechanismHard

Tests deep knowledge of GC internals and object lifetime management.

StackQueueBerkshire Hathaway Homestate Companies
Logic Puzzle Under ConstraintsMedium

Tests ability to reason from constraints and derive correct conclusions.

MathGreedyBerkshire Hathaway Homestate Companies
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership3 questions · ~27 min
Closing the Interview LoopEasy

Assesses your professionalism and ability to manage interview boundaries appropriately.

Self-AwarenessBerkshire Hathaway Homestate Companies
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 27 questions plus 1 hands-on drill to finish this plan.