Build a CSV Parser.
- Java 17
- Node Js v20.10.0
- In this assignment, you will be asked to write, and test your code.
- Make sure you respect clean code guidelines.
- Read the assignment carefully.
You are invited to create a CSV parser using Java/Spring Boot, and build UI to display results using Next.js/React.
-
Write a service in Java that will read and process the attached CSV(comma separated values) file at
data/employees.csv. -
This service should read, extract and process data in a suitable data structure.
-
Process this data to return the list of employees and a summary indicating the average salary for each job title.
Implement a simple user interface that will allow the user to upload the file and display the results of your processing.
Respect the following design flow:
- Interface-1: Contain an upload button.
- Interface-2: The Process button is added when you choose a file.
- Interface-3: 2 Tables showing the processing results.
Table 1: Employee information, displays a paginated list of employees.
Table 2: Jobs summary, displays for each job title, the average salary for employees.
- Write a concise, easy to understand code.
- Use good practices.
- Write unit tests for your java code.
- Append to this README your approach and provide instructions to run your project.
- Implement your own CSV file parser instead of using a library.
- Use design patterns.