Thor Tech Assessment - Fix Import Data Challenge

Challenge Overview

 

• Briefing about the application

 
A Large IoT and Power Management Company would like to consolidate all of their employee technical competency into a single tool which can be used to track at multiple levels. The goal is to have an application that allows CoE leaders to define roles with their competency requirements, and actions or trainings which prove each competency level. Managers and Directors will be able to track profiles with roll-ups of competency in specific sections of the workforce.
 

• The basic goal of the challenge

 
The goal of to allow load existing data into the application by updating the import functionality.
 

• Technology and Framework details

 
- Node.Js 8+ or 10+ 
- MSSQL
- Express.Js
- Electron.Js (Front End) 
 

Project Background

 

• The frontend and backend applications were completed but we need to fix the import functionality to allow loading the existing data provided by the client. 
• The changes must be done in Frontend and Backend applications.

 

General Requirements
 

• (Backend) Update the initial database setup script to create the following entries:
  • Competency: Cyber Security Competency
  • Sub-Competency: Cyber Security SubCompetency
  • Sub-Competency Levels: New To Skill, Basic, Intermediate and Advanced
• (Backend and Frontend) Add import functionality for employees and employee/manager relationship - MAJOR.
  • A popup should appear so users can select Competency and Sub-Competency to import the employee data.
  • Then allows users to select the file to import. The new template has Maturity and Expected Maturity.  They will be mapped to the Sub-Competency Level name.
• (Backend and Frontend) Add import functionality for courses. Courses id are mapped to Activity name. - MAJOR.
• (Backend and Frontend) Rename Profile to Roles - MINOR.
• (Backend and Frontend) Add import functionality for static data - MAJOR.
  • Country, Division, SubGroup and Roles.
•  (Backend and Frontend) Update existing import functionality for course status - MAJOR.
•  (Backend and Frontend) No lint errors should be present.
•  Template files will be provided in the forum.

Final Submission Guidelines

Zip file with:

1. The updated frontend and backend applications.
2. Updated Deployment Guide - README.md. 
3. Validation document - Validation.md