Got a direct call from coinSwitch HR for the Data engineer position. she told there will be 2 technical interviews followed by one hiring manger and then finally HR round.

1. tech interview 1 :

started with introduction and some questions around project. some questions on aws could and spark.

1st SQL question :

Input:

Date Payments
15-02-2022 100
16-02-2022 500
17-02-2022 900
18-02-2022 300
19-02-2022 400
20-02-2022 120
21-02-2022 1000

output :

Date Payments variance_flag
15-02-2022 100 null
16-02-2022 500 1
17-02-2022 900 1
18-02-2022 300 -1
19-02-2022 400 1
20-02-2022 100 -1
21-02-2022 1000 1

2nd sql question :
input
Payments:

Customer_id Payments Amount
1 Pending 2700 $2Pending700$
2 paid 200 $2Pending1600$
3 Pending 1400 $3Pending1700$
4 Pending 600 $4Pending600$

Customer:

Customer_id Customer_name Customer_location
1 Person_A Bengaluru
2 Person_B Delhi
3 Person_C Mumbai
4 Person_D Kolkata
5 Person_E Hyderabad

Calculate pending payments greater than 2000 $

O/p:
Customer_name Customer_location Pending Payment
Person_A Bengaluru 2700
Person_B Hyderabad 2300 (1600+700)
Person_C Mumbai 3100 (1400+1700)

Coding question

input
[1,5,1,3,'a',9,8,'c',4,'b']

o/p:
[1,5,1,3,9,8,4,'a','c',b']