I applied online. The process took 2 weeks. I interviewed at Paramount (New York, NY) in Nov 2021
Interview
3 part interview, first behavioral/get to know you and your experience and skills then take home assignment SQL and databases and file types final round is going over the assignment if you make it that far and reviewing it with the hiring manager/team
Interview questions [1]
Question 1
30 minute "get to know you" your background, experience, skills mostly just talking and questions back and forth to see if the skillset aligns, and if you can communicate your projects/experience well. Then a take home assignment, involving combining different file types from various sources and combining it into a single queryable dataset. Then questions/queries answering about that dataset. Took a long time and didn't get the offer 8hours+ but I really wanted the role Last part of the process is 30 minutes going over it with the hiring manager and possibly team.