Short 40 min call with hiring manager with 0 technical questions. Afterwards a timed 90 minutes case study without using google or any outside tools. The case study had two parts. SQL part which was easy, some group by and a pandas part which was easy if you work frequently with pandas and sklearn. It wasn't possible to use PySpark or any other relevant library.