Step 1: Phone interview - HR (Behavioral type)
Step 2: Technical Assessment Test (SQL, SSIS, SSRS, VB.net)
Step 3: In person Interview - Its kind of mix of technical interview and personal. Explain about the previous work , projects type of technologies etc.
Comparatively easy to crack.
Technical Assessment Test will be bit tricky, but if you have enough experience on SQL, then you can crack it.
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso PointClickCare (Mississauga, ON) nel mese di ott 2018
Colloquio
There was a phone interview followed by an onsite interview . The interviewer asked basic SQL question in the phone interview. In the onsite interview was in two parts. First part was a SQL test and the second one was interacting with the hiring manager.
Domande di colloquio [1]
Domanda 1
Write SQL query based on Database diagrams provided and create an SSIS package
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso PointClickCare (Mississauga, ON) nel mese di apr 2017
Colloquio
The interview process was very straightforward and seamless. Be prepared to do a technical phone interview and a written test based on SQL. The written test is a bit tricky but they are looking for how the solve the problems.
Domande di colloquio [1]
Domanda 1
Write two different SQL statements to retrieve data. Knowledge of SQL functions will be tested.