The purpose of this exercise is to understand an applicants ability to problem solve, think critically, and write software with existing RIMdev team members. While there is no expected answer, we do expect the production of a working sample. That means the work must compile, transpile, or interpret and above all else run with no immediate exceptions.
While accomplishing this exercise is permitted before interviewing at Ritter Insurance Marketing, it may also be completed in collaboration with the interviewers.
You, as the interviewee, are encouraged to:
- Ask Questions
- Search the internet
- Discuss your technical choices with interviewers
NOTE: The desired outcome is a pull request to this repository that builds and can be run by interviewer with minimal effort.
We also do not expect to see build artifacts in your pull request.
We expect the task to take anywhere between 45
to 90
minutes.
- GitHub account (personal or anonymous is fine)
- Please inform team members which PR is yours in the case an anonymous account is utilized
- Import
data.json
into memory - Submit an application that answers the following questions about the data set:
- What is the count of individuals over the age of
50
? - Who is last individual that
registered
who is stillactive
? - What are the counts of each
favorite fruit
? - What is the most common
eye color
? - What is the
total balance
of all individuals combined? - What is the
full name
of the individual with the id of5aabbca3e58dc67745d720b1
in the format oflastname, firstname
?
- What is the count of individuals over the age of
- Persist the result set to a database (of your choice)
- Include documentation for your technical choices
- documentation may be in the form of comments or a markdown file
- Credit any packages and sources that helped you solve