sql and then leetcode style questions
Senior Data Engineer Interview Questions
2,606 senior data engineer interview questions shared by candidates
Round 1 Coding Questions: Write a program to count the number of binary 1s in a number. Example: For 7 → Output should be 3. Write a program to check whether the given input contains valid parentheses. SQL Question: List all employees whose salary is greater than the average salary of their respective department. Scala Theory Question: What is implicit in Scala? Spark Questions: How do you copy data from HDFS to the local file system? What is the command for spark-submit? What is the difference between reduceByKey and groupByKey? What happens during a broadcast join in Spark, and how does it reduce shuffling? What happens when we use the collect() action in Spark? How do you define the minimum and maximum number of executors in Spark?
SQL : 1. create Pivot tables, 2. find the sequence gap and aggregate the result python: 1. Tricky python questions like function and their output 2. Normal and basic level of coding Pyspark: 1. Please check this topics of pyspark Windows functions , date_diff, case when , watermark and aggregation
How is Kafka different from MQ
What is data management? and follow-ups from the answer.
Which technologies do you work with?
asked about time complexity and space complexity
Coding questions were not algorithmic puzzles, but real life usage of calling web apis and processing data.
SQL Leet code Medium questions
Design an ETL pipeline that loads data every hour from X system to Y System with consistency and reliability describing edge cases.
Viewing 2051 - 2060 interview questions