There was a mix of behaviorial, system design and coding questions. Cannot reveal specifics due to NDA, but most technical questions were in the LeetCode-medium category. If you're proficient with LeetCode-medium and some LeetCode-hard problems and prepare for general system design interview questions, you're likely to do well.
When was the last time you made a mistake?
All questions around multithreading.
if you have a big text file on unix, how would you parse it if it has a predefined table format... how would you get data from a particular column?
New grads gave normal algo questions. Their communication was good, which I was a fan of. Design was with a principal engineer, pretty basic discussion.
What does HTTP response code 404 mean?
Difference between Varchar and Varchar2? Difference between string and string buffer? How many joins are there? What are they? Where will you see why SQL query is executing slow?
They asked solve few moderate level coding problems and sql problems
Q: Why do you want to work at Blizzard.
I can`t remember the exact problem but it was somewhat related to Sorting an array in a specific way. Take home exercise was to find the number of persons from the given coordinates ranging upto 100 kms.
Viewing 271 - 280 interview questions