I applied online. I interviewed at Wisconsin Court System in Feb 2021
Interview
Fairly easy process, met with a couple of Data Engineering team members who asked basic behavioral and a few technical (Data Warehousing and SQL) questions.
In the second round, had a small interview with CCAP's head and the role was explained to me, a few more technical and behavioral questions were asked.
This was immediately followed by a coding round on coderpad.io.
There were 5 PL-SQL based questions.
Interview questions [1]
Question 1
Coding Questions:
-- Find employees who have the highest salary in each of the departments?
-- Which project has at least 2 different employees?
-- Find a project which lasted less than a month.
-- Count number of employees who has salary more than the average salary.
-- Get the 8th highest salary from the Employees table.