Snowflake Software Engineer interview experience

In the coding section, I worked on a problem in the style of a LeetCode task—checking whether the root node is the average of all its subtrees. After that, I was given another coding challenge involving handling input that wasn’t already in increasing order; I considered using a TreeMap, but I didn’t end up running tests.

The system design round caught me off guard because it didn’t feel like a typical software design prompt. Instead, the question was inspired by a past incident at Snowflake and revolved around optimizing offline time while controlling a client that periodically retrieves a