In this post, we will see the list of questions asked with 3+ YOE candidate in Impetus Company Interview for Data Engineer profile.

Let’s see the Questions:

1) Brief introduction and overview of your project work.

2) Tech stack used in recent and past projects.

3) Explanation and differences between Star Schema and Snowflake Schema.

4) Recent implementation highlights from your current project.

5) What is SCD (Slowly Changing Dimension)? How many types exist? How do you implement SCD Type 2 using Databricks?

6) Given two tables A and B, demonstrate the result of different types of joins:

a) Inner Join

b) Left Join

c) Right Join

d) Full Outer Join

e) Cross Join

Sample Data:
A B
1 1
1 1
1 2
2 4
3 NULL
NULL NULL

7) From the given employment data, find the employee id and companies where the person has worked at both Microsoft and Impetus, but only after leaving Google.
Sample Input:
id company start_date end_date
1 Microsoft 01/01/2024 06/01/2024
1 Google 06/02/2024 07/01/2024
1 Impetus 07/02/2024 NULL
2 Microsoft 01/01/2024 06/01/2024
2 Impetus 06/02/2024 NULL

8) Identify customers who have purchased all the products listed in the product table.
Customer Table:
customer_id | product_key
————|————-
1 | 7
1 | 8
2 | 8
3 | 7
3 | 8
Product Table:

product_key
————
7
8
Expected Output:

customer_id
————
1
3

9) You are given two tables: transactions and users. Determine if users prefer to ship orders to their primary (home) address versus other addresses. Return the percentage of transactions that went to the users’ home address, labeled as home_address_percent.
Tables Provided:
Transactions Table
id | user_id | shipping_address
Users Table
id | name | address
Expected Output:
home_address_percent
———————
0.76

10) Sort the array arr1 = [6, 1, 4, 1, 7, 2] without using in-built functions.

11) Write a function to find the second-highest number in a list.

12)  Calculate the sum of digits for each number in a list without using built-in functions.
   Example: 
      Input: [12, 67, 98, 34]
      Output: [3, 13, 17, 7]

I hope these questions assist anyone preparing for their interviews. Thank you for reading this post.