In this article, we will see the list of questions asked in Deloitte Company Interview for 3+ year of experience candidate in big data field.

Let’s see the Questions:
1) Briefly Introduce YourSelf?
2) Difference between head() and take() in spark dataframe API?
3) How to convert array columns values into mulitple rows in spark dataframe?
4) How to drop columns from spark dataframe if it has Null value in it?
5) Explain Dynamic partitioning and Error in Dynamic partition pruning?
6) What are the different read and write mode in spark?
7) How AQE (Adaptive Query Execution) in spark works?
8) Difference between Map Reduce and Spark Programming?
9) What is CheckPointing in Spark?
10) What is serializer in spark?
11) Find the missing number in the spark dataframe ID column?
12) What will happen if your Spark job fails at 40% completion?
13) Given a table of Employee with following columns: ‘ID’, ‘Name’, ‘Salary’, and ‘Department’, Write a SQL query to select the 2nd highest salary in the engineering department?
14) Given a two tables, Orders and Products, where Orders table following columns: ‘OrderID’, ‘ProductID’, and ‘OrderDate’, and Products table following columns: ‘ProductID’, ‘ProductName’, and ‘Price’, write a SQL query to find the total revenue generated by each product for the current year?
15) Given a table of banking transactions with following columns: ‘id’, ‘transaction_value’, and ‘created_at’, representing the date and time for each transaction, write a SQL query to get the last transaction for each day.
16) Given a table with following columns : ‘Country’ and ‘Revenue’, write a SQL query to keep one country value always on top? let say US.
17) write a SQL query to find the Number of occurrences of the countries mentioned in Country column ?
18) Given a table with following columns : ‘Name’ and ‘Age’ , write a SQL query for Age bracket?
19) How to convert 3 row result in one column?
20) Given two strings, How would you know if they are anagrams of each other?
21) 2 Sum Problem: Write a code to find the a unique pair(index pair) of numbers whose sum matches the target value (we cannot use the same element twice)?

Ex 1: 
input: nums = [2,7,11,15] , target = 9
output: [0,1] 

22) Describe a challenging data engineering project you handled. How did you manage the complexities and what was the outcome?

This interview was held through Microsoft Teams Video Call.

Check out the given link for knowing about this company: Deloitte
Check out the given link for knowing about this company rating on Glassdoor: Deloitte | Glassdoor

Check out the given link for this company profile on Linkedin: Deloitte | LinkedIn

Thank you for reading this post.