I applied through a staffing agency. The process took 3 weeks. I interviewed at Farrow (Mississauga, ON) in Aug 2025
Interview
I applied through Indeed and the head hunter followed through application process after screening my profile. Two technical panel rounds, one virtual and second on-site. The role location was in Mississauga, ON with hybrid job type. Interview questions were based on .NET and SQL.
Interview questions [2]
Question 1
1st virtual technical panel round was with Director, Team Lead/Manager and Senior Engineer. Initially, a brief intro from both ends and technical questions revolved around ASP.NET and SQL. RESTful API and its merits-demerits over SOAP. MVC application page life cycle. What ORM have you used and why. When to use ADO.NET over ORM, some use-cases. What are CTEs in SQL, its scope and benefits. What are functions in SQL. Difference between Delete and Truncate.
2nd on-site technical panel round was with Director, Team Lead and 2 SSEs. Just a brief info about the 2 tasks to complete in 1hr 30minutes (45m each).
First task, a C# Leetcode easy question like: Reverse string or reverse string order or highest integer from arrays or sum of a number or find differences between 2 integer arrays. The task was waived off for time & space complexities, hence could use built-in methods (LINQ).
Second was SQL task, create a parameterized stored procedure with optional filters and paginations. They provided 3 tables with relations and bridge entities. Need to find the sum of GST amount and sum of duties paid per shipments using provided columns.
You could access browser for any syntax or related references.