Description
The project involved creating an Annual Talent Trends Report using the data fetched from various Job Portals. This report included job count filtered by cities, industries, functions and experience categories. In addition, the report also showed monthly increase/decrease in job count for various skill buckets filtered by Industries, cities and experience categories.
Challenge
1. Data Formatting- The data fetched from various job portals was not in the required format. Organizations were not mapped to Industries and skills were not mapped to corresponding skill buckets. In addition, the salaries mentioned were also not in a consistent format.
Solution
1. Data Formatting- We wrote python scripts for cleaning the data, fetching correct salary ranges for each job. Also, we created an organization to industry mapping file and a skill to skill bucket mapping file which was used to get the correct Industry and skill bucket for each job.