Scenario based sql and python questions
Senior Data Engineer Interview Questions
2,552 senior data engineer interview questions shared by candidates
Describe a project you worked on.
1. Python lambda function and its uses
What's the last most challenging problem you've faced. How did you face it?
1st Interview : - Make Sort class with some method then create BubbleSort class that must inherit Sort class and overwrite its method in python - Use of Lead window function(scenario based question) - Write a query to get employees who don't have any project assigned - hive partitioning vs bucketing - CI/CD - joins in spark 2nd Interview: - write data frame transformation and get the required result(scenario base question) - how to assign unique identifier to each record(Use monotonically_increasing_id()) - How to remove duplicates in dataframe(use df.dropDuplicates() function)
Online technical programming test to be performed on an online platform.
Given and list of python u have to write code SQL query for given two tables followed by a problem statement
Trivia around commands and recall of python keywords
Already described above.
Explain your experience with streaming technologies
Viewing 351 - 360 interview questions