How did you design data lake what are the three layers. How did you design using what services. why this services over the other Difference between schema in data warehouse Whats the purpose of this service. How you would store some secret keys and how you would secure the data. what are the methods and how you did it. whats the typical project activities dev,test,prod the cycle.
How to generate a uniform06 number using a nonuniform distributed function?
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.
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.
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
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 301 - 310 interview questions