I applied through a recruiter. I interviewed at Profusion (London, England) in Sep 2021
Interview
- A recruiter approached me for a data engineer opportunity in Profusion.
- I met a Lead and Senior Engineer and was asked a couple of SQL, Python and Cloud questions.
- I was asked to do a technical test in Python (using an existing API for which I would have to read documentation) and to write around 10 SQL queries that solve different issues.
I didn't do great in the first interview, but they still asked me to do the technical test, which I aced. I sent them the results. They never responded or shared feedback. Complete waste of time!
Interview questions [1]
Question 1
Q:
- GROUPBY
- KEYS in SQL
- Advantages and Disadvantages in Serverless
- How do you know you successfully transfered all data?