Technical interview with a software, supervised about tipical test cases in python and SQL. The cultural fit interview was talk about your experience and background.
Sr Data Engineer Interview Questions
2,592 sr data engineer interview questions shared by candidates
Scenario based sql and python questions
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
A lot of behavioural questions, cultural fit type stuff. "Tell me about a time you had to give negative feedback to a co-worker who was underperforming," this sort of thing.
Viewing 361 - 370 interview questions