During this interview, I was asked to complete three tasks: Write a Python script and SQL queries to connect to a database, perform complex joins between four tables (with keys stored in JSONB), debug the code, and store the result in a DataFrame. A conceptual task where I had to read a paragraph and design a database schema based on the explanation. Write a script to connect to the Benchling website to retrieve data from specific tables and store it in a CSV file. All of this was expected to be done within one hour, which does not make sense. The interviewer also told me that he had never conducted an interview before. After that, I never heard back from the team. I followed up, but never received a response. I think this is a bit disrespectful.
