Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Tangerine Software (Montréal, QC) nel mese di feb 2018
Colloquio
I applied through recruiter, the process took one week. I had a 1:1 interview on site with the team lead about an hour. He asked me about my background and why I am interested in this job.
Then I did a technical test time of the test one hour and it includes 8 SQL quetions, 2 IQ questions and 2 General questions.
They ask me to come another day to meet with the team and the manger.
Domande di colloquio [3]
Domanda 1
Define the following:
- Income statement
- Balance sheet
- Trial Balance
- Cash flow
2- Consider a database with 3 tables (order-invoice-customer)
a. Write a SQL query that lists all orders for a customer whose First Name is John and last name Paul and that exceed a value of $100,000
b. Write a SQL query that lists all custmors who placed an order in 2016. Consider that date column is in the following format: yyy-mm-dd