How do you join two tables with all the information on the left one unchanged?
Data Engineer Interview Questions
20,235 data engineer interview questions shared by candidates
Given the root of a binary tree, return an array of the largest value in each row of the tree.
Tell me about yourself - professional background and projects you've worked on.
A lot of object-oriented questions around data structure and database design. There was a take-home exercise that you were expected to complete (at least in my case) in one day.
Tell me about a time you encountered a challenge?
SQL: count the number of items in a certain range (use SUM(CASE WHEN x < 100 then 1 else 0 end) as under_100, etc Python: join 2 lists and sort (This just involves one line of code, so I was surprised) Python: remove items with a certain key Python: dynamically format SQL depending on the parameters passed
SQL on books, authors and sales. Questions involving JOIN, GROUP BY etc etc. Python involves mostly around usage of dictionaries
How many years of data engineering experience?
5 SQL Questions and 5 Python Questions
asked me some Python questions
Viewing 1081 - 1090 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerAnalytics EngineerPerl DeveloperDatawarehouse DeveloperEtl DeveloperData ModelerDatastage DeveloperEtl TesterData AnalystOracle Data IntegratorMachine Learning ScientistData ScientistData MinerBusiness Objects DeveloperDatabase AdministratorData Warehouse DeveloperData Warehouse ManagerData Warehouse ArchitectBusiness Intelligence Specialist