This is a project that we use to evaluate the technical skills of potential team members.
This repository contains a file called balances.csv with the following colummns:
- FIRST_NAME
- LAST_NAME
- ADDRESS
- CITY
- STATE
- ZIP
- PHONE
- BALANCE
Your application should read balances.csv and generate a file called summary.csv with the following columns:
- STATE
- MIN_BALANCE
- MAX_BALANCE
- MEAN_BALANCE
- TOTAL_BALANCE
Your output should contain one row for each state represented in the input, along with the minimum, maximum, mean (average), and total (sum) of the balances for accounts in that state.
You may use a database if you like, though it's not a requirement. If you choose to use a database, please populate the database programatically from the input file in your application.
The following are the tools our team favors. They are preferred, but not required, for this project.
- Java 8+
- Spring Boot
- PostgreSQL or SQLite
- JUnit, TestNG
Build your own public repo on github and call it whatever you like. Build your solution in your repo, including a README.md file that contains the detailed instructions for running your app. Email the URL for your github repo to your hiring manager once you begin the project so we can review your progress. Once your project is completed, please email your hiring manager.
One of the major goals in this project is to see how you fill in ambiguities in your own creative way. There is no such thing as a perfect project here, just interpretations of the instructions above, so be creative in your approach.
Thank you for your time. We are excited to review your project!