Phone Screen 1: 1 hour interview (Technical)

30 mins project discussion and the current technologies from the project

SQL :

1. https://leetcode.com/problems/employees-earning-more-than-their-managers/

2. given table:
   

   resultant table:
   

3. dont remember the exact question but it was to get the results using LEAD/LAG functions

python:

nums = [100, 999, 2, 3, 8, 9, 21, 33]
target = 4
O/P = {2,3}
find closest 2 numbers to the target (variation of twoSum)

d = {}
for key, val in enumerate(nums):
m = abs(target - val)
d[m] = val
print(d)

print(sorted(value for key, value in d.items())[:2])

Phone Screen 2: 1 hour interview (DB scaling + LP)

1. Suddenly if ETL is getting slower with account_id join, how would you address the issue ?
2. How to enforce integrity constraints in S3 or Data Lake ?
3. Data Lake/ S3 has OLTP or OLAP structures ?
4. what is Data Skew in Spark ?
5. tell me a time where you had a different goal until 70% project was done