State Farm Software Engineer Interview Questions
The questions to prepare for a State Farm Software Engineer interview. Questions from real interview reports rank first. Updated weekly.
Problem Given the root of a binary tree, return True if the tree is height-balanced and False otherwise. A binary tree is height-balanced if, for every no...
State FarmTraverse a graph from a start node using BFS and DFS, returning the visit order for each traversal.
State FarmExplain how to calculate cumulative totals in SQL using window functions, ordering, and optional pre-aggregation.
State FarmTests SQL join skills and correct use of aggregation and grouping.
State FarmUse ROW_NUMBER and a region join to identify the three highest-grossing active policies in each region.
Arthur J. Gallagher &State FarmAggregate posted Arcesium portfolio sales by date, then calculate each active portfolio's cumulative sales with a window function.
Avenue Code
Avnet
Del Rey Systems & TechnologyFind the second highest salary in each department without using aggregate functions.
Credit Genie
Devoteam
Cisco Restaurant + BarSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Define an execution approach for maintaining data consistency across distributed systems while balancing delivery speed, risk, and operational resilience.
State FarmExplain how you would design a scalable application, including trade-offs, risks, stakeholder needs, and how you define success.
State FarmTests system design skills for decomposing services, APIs, data flows, and operational concerns.
State FarmEvaluates ability to read and reason about infrastructure and scripting code.
State Farm