Build out the architecture to go from a stream of user-level event data on their devices to time-aggregatable metrics in a dashboard.
Data Engineer Interview Questions
20,979 data engineer interview questions shared by candidates
Asked by the interviewer a "Data Engineer" to join 2 tables together to label start/end of a track play , only when I proposed a working solution he diverted me to another solution that he had in mind all along, thinking it was better as it didn't require window functions, but it did require them. He just didn't know they are called window functions. Admittedly, the "Data Engineer" said he hasn't worked on spark in a while, and is quite junior.
Resume Questions
Implement a sampling function with nominal distribution.
Why you are using your pipeline as it is why you are not a decision maker in your organization?
Draw a clock. What is the degree difference between the hour and minute hand if the time is 3:15?
SQL analytical queries. Python basic programming.
Write a query that returns percentage of unsold product_category.
Find common words in 2 sentences
phone screen for SQL: Give data model - solve various SQL questions Python: list and dict manipulation
Viewing 161 - 170 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerPerl DeveloperModeling EngineerDatabase AdministratorData Warehouse DeveloperData Warehouse ArchitectBusiness Intelligence SpecialistData ScientistData MinerBusiness Objects DeveloperData AnalystMachine Learning ScientistDatawarehouse DeveloperData Warehouse ManagerOracle Data IntegratorData ModelerEtl TesterEtl DeveloperDatastage Developer