Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Citco
Colloquio
I was given situations (technical questions) and would be asked how I would solve it using logic (SQL logic, or whatever programming logic is related) and About Yourself/Experience type of questions.
Domande di colloquio [1]
Domanda 1
*provided with a situation wherein you would have to retrieve data from tables provided to you* explain how you would get the requested data using SQL logic
Ho sostenuto un colloquio presso Citco (Toronto, ON)
Colloquio
3 rounds
First one is basic HR questions with a recruiter
Second one is with a Director of Reporting Team - Spark Shuffling, Databricks related questions.
Third round is with 3 team members, deep dive into technical projects, Delta table optimizations and sql query optimization
Domande di colloquio [1]
Domanda 1
Tell me about a time where you had to optimize a sql query and how did you do it
