Level: Junior-Level
Round: Online Assessment · Type: Technical Discussion · Difficulty: 6/10 · Duration: 60 min · Interviewer: Neutral
Topics: Arrays, SQL, Bash Scripting
Location: San Francisco Bay Area
Interview date: 2026-01-24
The online assessment consisted of three parts: an array problem, an SQL problem, and a bash scripting problem.
Question: I was given an array problem, an SQL problem, and a bash scripting problem.
The first question was a LeetCode-like problem: Student Arrangement. I was given a parent array (e.g., par = [-1, 1, 1, 2, 2, 2, 2]).
The second question was an SQL problem that involved converting varchar to numbers and then appending a currency symbol (M, B).
The third question was a bash scripting problem. I had to return the largest file in a directory. This type of question is not very common, so I recommend preparing regular expressions.
LeetCode similar: LeetCode Student Arrangement