The whole process took about one month. There are three round interviews. The first and second ones were all asking technical questions. The third round was behavioral and technical questions.
Preguntas de entrevista [3]
Pregunta 1
1st round:
My query runs slow. What to do?
Window function you used before.
Given two tables:
products -- productid, productname
orders -- orderid, productid, quantity, orderdate
1) Write a SP to find the [product name] based on the [product id] input.
2) Write a SP to find the [order id] based on [part of the product name] as input.
3) Orders placed in the month of Feb this year?
2nd round:
Given a School DB with Professor, Student, Class, Score tables.
1) How many classes does each professor teach?
2) Display AverageScoreForClass and AverageScoreForProfessor.
3) Write a SP to get a student’s score
4) Display StudentName, ClassName, MAX(Score) which got max score for each class.
How to optimize a SSIS package?
How to use Checkpoint?
3rd round:
What’s the most challenging task you’ve done?
What’s the most complicated data cleansing you’ve done?
How big the data input have you deal with before?