Click here to watch the video!
1. Understanding the Upload Template
There are two spreadsheets in the Competency V2 upload template: Positions and Matrix.
2. Understanding the Positions Sheet
The Positions sheet contains the following fields: Team Name, Track, Position, Position Label, and Position Level.
-
In the Team Name column, enter the department or team to which the position belongs.
-
In the Track column, enter the relevant career track. You can refer to the sample image shown, which includes example tracks such as Individual Contributor (IC) and Manager. You can also define your own tracks based on your organization’s requirements.
-
In the Position column, enter the job title or designation of the role. In the Position Label column, enter the alias or short name for the position. This is also customizable as per your organization’s needs.
-
In the Position Level column, enter the appropriate level associated with the position. You can also refer to the attached image for sample values. These are only examples, and you can customize teams, tracks, positions, labels, and levels based on your organization’s requirements.
3. Understanding the Matrix Sheet
The Matrix sheet contains the following fields: Competency Theme, Competency, Competency Description, Position, Position Description, and Weightage.
-
In the Competency Theme column, enter the broader category under which the competency falls.
-
In the Competency column, enter the name of the competency.
-
In the Competency Description column, provide a brief description of the competency.
-
In the Position column, enter the relevant job position to which the competency is mapped. This should match one of the positions defined in the Positions sheet. Below Position enter a description of the position.
-
In the Weightage column, define the weightage assigned to each competency for that position. Please note that this field is optional.
You can refer to the sample image for example values. These are provided for reference only, and you can customize the competencies, positions, descriptions, and weightages based on your organization's requirements.
4. Understanding the Matrix Sheet
Let us understand what each row in the Matrix sheet represents using a simple example:
-
In the sample sheet, you will see a Competency Theme such as Functional Skills. Under this theme, there are Competencies like Coding Skills.
-
Each competency is also supported by a Competency Description, which explains what the competency means in practical terms.
-
These competencies are then mapped to a specific Position, for example, Software Engineer. This indicates that all the listed competencies are expected for that role.
-
For each position, there is also a Position Description, which defines the role in detail and explains what is generally expected from someone in that position.
-
Finally, each competency is assigned a Weightage, which represents its importance for that specific position. For example, for a Software Engineer role, Coding Skills may have a higher weightage compared to other competencies, indicating it is a higher priority skill for that role.
