I am currently hiring a new developer and since these opportunity are far and between nowadays, I want to make sure I pick the best one for our environment. I am already doing all of the basics: recruiter interviews, phone interviews, in person interviews, each with increasingly more in-depth technical questions. But, I wanted to add an additional step of a practical interview. Basically, come up with a development request, with as little information as possible, so that I could see where these people go from there.
Here is the example:
Development Request:
We need an end-to-end solution that will display the results of data collected from a set of field vendors. We need the data available in the report as soon as the upload is complete.
This is the information that we will be collecting:
- Name
- Age
- Gender
- Favorite Color
We need a report that will display this information in the following ways:
- Percent of Favorite Color broken down by Gender/Age (age broken at 25 into Under/Over)
- This report should allow us to filter on Vendor.
What questions do you have?
What technologies will you use to facilitate this request?
Pretty simple, right? It’s actually a more complete request that I usually get, so I think it’s more than fair and something that shouldn’t take more than 1 hour to whip out.
Since we are primarily a Microsoft tech stack shop, I was looking for the person to answer the question, “What technologies will you use to facilitate this request?” with:
- SQL Server 2008
- SQL Server Integration Services
- SQL Server Reporting Services
- Visual Studio 2008 (.NET 3.5) in C#
Here is how I went about the project:
- Open SQL Server Management Studio 2008
- Create a new database called ApplicationX Read More…