They asked about AWS cloud
Data Engineer Interview Questions
21,097 data engineer interview questions shared by candidates
SQL: Go throw joins, subquery, group by and window functions Python(any language of your choice): Syntax algorithms data structures big 0 notations System Design: Designed the system in multiple methods and explained the pro and cons of each method.
Basically, we did not agree on the salary so we did not continue the process, she called me within a few days.
Challenging project that I feel proud of.
Tell me a bit about yourself.
During the on-site interview I had a total of 4 rounds of interviews: 1st round is a coding interview for 90 minutes, during which time I was asked to design and implement a transaction supported in-memory database using any programming language of choice. 2nd round is a white-board design interview for 60 minutes, during which time I was asked to design a messaging application on the white-board with a few followup questions in the end 3rd round is an algorithms interview, I was asked a Leetcode medium question. The interviewers helped me when I was stuck 4th round is a general discussion with the hiring manager, who tested me on my knowledge of Data Engineering solutions/software out there in the market.
Parler de votre objectif pour le futur
Talk about a conflict you had at work and how did you resolve it?
There were SQL questions on RANK() Vs ROW_NUMBER() and Order Analytical Function usage such as SUM() OVER(PARTITION BY <> ORDER BY <> ROW UNBOUNDED PRECEDING). Question on how to club the set of Anagrams together from a list of words.
Lots of SQL stuff, describe slowly changing dimension types
Viewing 2051 - 2060 interview questions