I don't remember any specifically difficult questions or unexpected questions. I thought the interview was fair and the SQL test was fair based on the practice test provided.
Software Engineer Data Interview Questions
456 software engineer data interview questions shared by candidates
System Design: Design a data processing pipeline and ingest for an Event System to be shared across multiple applications and servers. Algorithm We are reading from 3 files for each platform. These are the csv file with 3 columns one is the player's name, the player 2nd is the post id, and the last is the time is watching. The time is long. Return the top 3 candidates that watched the most.
Analyze a given dataset (small subset of data being really used), perform data manipulation and build couple of metrics used for analytics and dashboards.
Coding question - Print out diagonals of the 2D square matrix. Design - How will you design a storage for Gmail?
Can't remember the exact question anymore, but it was a vague and hypothetical data-related question that required a lot of clarifying questions that were left unanswered.
Kth Largest Element in Binary Search Tree
Given a new dataset, how do you find it provides useful information or not?
1 System Design (standard such as design Netflix or Typeahead suggestion), 1 question on Algorithms and data structures (easy-medium difficulty), 1 question on OOP and coding best practices.
Just the standard kind of questions.
Business case -- they presented me an e-mail and their problems with recommend, and suggested ways I might improve it. Also a 'lightning' round of mathematical, statistical, and programming questions that was a little all over the place (and not tailored to your resume), and done in a binary yes/no fashion.
Viewing 331 - 340 interview questions