SQL Query Writing: **Table A** Columns: col1 col2 **Table B** Columns: col3 col4 There is no common column to implement the JOIN condition and the Required Output is: col1, col2, col3, col4
Senior Data Engineer Interview Questions
2,399 senior data engineer interview questions shared by candidates
SQL Query Writing: **Table EMP** Input Columns: EMPID, DEPID, SAL, DOJ Output Columns: EMPID, DEPID, SAL, DOJ, NEXT_SAL NEXT_SAL can be derived as the salary of immediate next employee in the given records.
Which AWS services you have used (Hands-On)? Tell me one use case and one limitation of AWS Lambda function?
Give an example of design patterns
Describe your background, explain your data engineering expertise and so on.
* Code assessment within code interviewing tool with the aim of showing knowledge of best practices such as unit testing. * Open ended question on system architecture
Signed a NDA so cannot go over the actual details. The interviews were a good mix of algorithms data structures and system designs question. Since I applied for a very specialized role there was more focus on my actual skill set.
SQL and Spark queries that compute aggregates across multiple big tables
Like leetcode code questions
Transaction isolation levels
Viewing 691 - 700 interview questions