It was a long process, starting with a test based on sql and moving on to multiple interview rounds with the team members, all based on sql, python and logical thinking