Solicité el puesto a través de un captador. El proceso duró 1 semana. Acudí a una entrevista en Tangerine Software (Montreal, QC) en feb 2018
Entrevista
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.
Preguntas de entrevista [3]
Pregunta 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