I applied online. The process took 5 days. I interviewed at UsefulBI
Interview
two rounds. First with project manager and then with the technical engineer. Interviewer was a bit experienced in multiple aws services and data pipelines. Asked the test cases related to real time data.
Interview questions [1]
Question 1
python -- remove duplicates from list, convert pandas to spark dataframe and vice versa, basic python data structures related questions
SQL -- write sql query for 7th highest salary from employee table , sql queries for rank , dense rank functions
AWS -- case study for developing pipelines using AWS.