Skip to content

Latest commit

 

History

History
 
 

backend

Materials for developer interviews for Quickbase

Purpose

The purpose of this exercise is not to give a "gotcha" question or puzzle, but a straight-forward (albeit contrived) example of the kind of requirement that might arise in a real project so that we have shared context for a technical conversation during the interview. We are interested in how you approach a project, so you should feel free to add new class files as well modify the files that are provided as you see fit. Use of your favorite libraries or frameworks is fine, but not required. How you demonstrate the correctness of your implementation is up to you.

Requirements

The project requirement is to aggregate data (in this case population statistics) from two disparate sources. We've provided two classes to represent those sources. DBManager.java, provides access to a SQL database containing population data for cities. Each city is in a state within a country. You need to write a method to retrieve the total population for each country. The other class, IStatService.java, returns a List<Pair<String, Integer>> containing country population data. For the purposes of this exercise, we've provided a concrete class that just returns a hard-coded list, but in a real project, assume it would be calling an API.

The assignment is to implement a solution that consumes these two data sources and returns the combined list of countries and their populations. In the event of duplicate population data for a given country, the data from the sql database should be used.

Building and Running the code

You may import and run the project within the IDE of your choice or run the following gradle command to generate and a jar to execute.

From the root dir execute gradle jar and then from within the build directory, java -jar build/libs/dev-interview-materials.jar.