# Job Skill Enhancement System

## CORE INSTRUCTION:
You are an AI that extracts and identifies coding languages and frameworks from job descriptions. Your goal is to find ALL relevant technical skills mentioned in the job posting, even if they're mentioned in different ways or aliases.

## INPUT DATA:
{
  "job": {"job_id":4009,"title":"Software Development Intern for Digital Agency - Spring 2026","company_name":"Kvalifik","description":"About the job\n\nAre you our next Software Development intern to join a strong team of young professionals?\n\nEvery day we set out to build great digital products for the customers of our agency and we need more great people onboard. We are now looking for software developer interns for Spring 2026\n\nThe start date will be according to your institution.\n\nOUR SERVICES\n\nWe help our customers by building, launching and maintaining top-notch innovative digital products and services. We take their ideas from wireframes to design, through development and to launch – and we need yet another smart brain on board to help our customers fly into the future!\n\nOur Stack Usually Looks Something Like This\n\n\n🕸️ Web: Next.JS + Nest.JS + PostgreSQL + GCP + Vercel\n📱 Mobile: React Native + Expo + Firebase\n\n\nWe, by no means, expect you to know all of these technologies by heart. All we care about is that you are open to learn and ready to deep dive into new technologies!\n\nOur work is project-based with timelines typically between a couple of weeks to half a year. We are follow agile development principles and we love doing stuff in iterations.\n\nOur clients are ambitious companies, who are ready to turn (sometimes crazy) ideas into reality and make digital innovation happen. We work with NGO’s, startups, and big corporations. A few selected brands include Veo, Carlsberg Solar, Danica and Mikkeller. You can find examples of our work on www.kvalifik.dk\n\nSkills And Who You Are\n\n\nYou are currently studying for a degree in programming (Datamatiker, Softwareudvikling, Webudvikling, IT-Tekno).\nYou have some experience with developing full-stack web or mobile applications either from your studies, own projects, and\/or other work experience. \nYou understand the end user’s perspective and can transfer requirements to functionality (in collaboration with the rest of the team).\nYou re ambitious about your work and can produce high-quality code. \nYou are excited to learn, motivated & able to work independently.\nYou are structured, trustworthy, and can communicate with your team.\nYou have some experience with React and Node.js(preferred but not required).\n\n\nAdditional Bonus Points If You\n\n\nHave sufficient knowledge of HTML, CSS, and JS.\nHave experience with Next.js.\nHave experience with NestJS.\nHave experience with relevant JS testing suites.\nHave experience with Git, Github and Docker\n\n\nMore About Who You Are\n\n\nYou are open-minded, have a positive attitude, and you love working in collaborative teams. We are all part of shaping and maintaining an awesome company culture and we therefore value social engagement and taking initiatives for improvements. \nYou can do self-leadership, meaning that you have a high sense of self-awareness, self-honesty, self-knowledge, and self-discipline. We don’t micromanage you, so first and foremost you observe and manage yourself (but of course we guide you).\nYou take responsibility, ask for guidance, and your are happy to assist our full-time full-stack software developers developers when needed. \n\n\nOur Culture And What We Offer\n\n\nA dedicated intern buddy and a structured internship. We want your internship to be a success, so we make sure that you have the support and learning you need to get there.\nA fun, ambitious, and creative work environment with incredibly talented colleagues and a strong sense of camaraderie.\nA chance to work on real life projects, for exciting startups, scale-ups, corporates and NGO's.\nA workplace with an entrepreneurial culture, where the path from idea to action is small and the possibility of responsibility is great.\nA beautiful office in the heart of Copenhagen, offering both quiet spaces for focused work and areas to unwind, whether it’s playing foosball, Smash Bros on our Nintendo Switch, or enjoying a cup of barista-quality coffee.\nDelicious lunches (with vegetarian and vegan options if desired), a well-stocked snack drawer, beverages, and gourmet coffee.\nFriday bars, parties, and social gatherings. We love celebrating a successful project with a bottle of champagne, throwing great parties, and enjoying activities like paddle tennis or ceramics together after work.\n\"KvaliHack\" 6-8 times a year, where we set aside a full day where we don’t work on client projects, but instead hold an \"unconference\", focusing on learning and exploring new tools and technologies together.\n\n\nINTERESTED?\n\nIf you wanna know more, check out www.kvalifik.dk and feel free to write or call.\n\nFYI: This internship is unpaid if you are a part of of a study programme with an unpaid internship period.","brief_summary_of_job":null,"existing_skills_from_job":["CSS","HTML","NestJS","Next.js","Node.js","React","React Native","PostgreSQL","Git","GitHub","GCP"],"existing_skills_from_database":[]},
  "coding_categories": {"languages":["Bash","C","C#","C++","CSS","Clojure","Dart","Elixir","Go","Groovy","Haskell","HTML","Java","JavaScript","Julia","Kotlin","Lua","MATLAB","Objective-C","Perl","PHP","PowerShell","Python","R","Ruby","Rust","Sass","Scala","Swift","TypeScript"],"frameworks":[".NET","Angular","Apache Spark","ASP.NET","Backbone.js","Bootstrap","CodeIgniter","Django","Ember.js","Express","FastAPI","Flask","Flutter","Hadoop","Ionic","jQuery","Laravel","Livewire","Meteor","NestJS","Next.js","Node.js","Nuxt.js","Phoenix","PHPUnit","PyTorch","React","React Native","Ruby on Rails","Spring Boot","Svelte","Symfony","Tailwind CSS","TensorFlow","Vue.js","Xamarin","Alpine.js","Filament","WordPress"],"databases":["MySQL","PostgreSQL","Redis","MongoDB","DynamoDB","MariaDB","NoSQL","Oracle","BigQuery","Elasticsearch","SQL","SQL Server","SQLite","Cassandra","CouchDB","Neo4j","InfluxDB","CockroachDB"],"tools":["Git","GitHub","GitLab","Bitbucket","Docker","Kubernetes","CI\/CD","Jenkins","Kafka","RabbitMQ","Amazon SQS","AMQP","PubSub","REST API","RESTful APIs","GraphQL","AWS","Azure","GCP","Terraform","Ansible","Puppet","Chef","Vagrant","Vault","Consul","Prometheus","Grafana","ELK Stack","Splunk"],"skills":["English","Danish","Communication","Full-stack development","Back-end development","Front-end development","Cloud computing","DevOps","Microsoft Excel","PowerBI","Power Platform","Agile","Scrum","Problem-solving","Team collaboration","Physical presence","Remote work","Hybrid work"],"colors":{"languages":"blue","frameworks":"purple","databases":"orange","tools":"indigo"}},
  "skill_aliases": {"bash":"Bash","c":"C","c plus plus":"C++","C plus plus":"C++","c sharp":"C#","C sharp":"C#","c#":"C#","c++":"C++","clojure":"Clojure","cpp":"C++","dart":"Dart","elixir":"Elixir","go":"Go","golang":"Go","Golang":"Go","groovy":"Groovy","haskell":"Haskell","java":"Java","java script":"JavaScript","Java script":"JavaScript","javascript":"JavaScript","Javascript":"JavaScript","js":"JavaScript","JS":"JavaScript","es5":"JavaScript","ES5":"JavaScript","es6":"JavaScript","ES6":"JavaScript","julia":"Julia","kotlin":"Kotlin","lua":"Lua","matlab":"MATLAB","Matlab":"MATLAB","objective c":"Objective-C","Objective C":"Objective-C","objective-c":"Objective-C","objc":"Objective-C","ObjC":"Objective-C","obj-c":"Objective-C","Obj-C":"Objective-C","perl":"Perl","php":"PHP","Php":"PHP","powershell":"PowerShell","Power Shell":"PowerShell","python":"Python","py":"Python","Py":"Python","phyton":"Python","r":"R","ruby":"Ruby","rust":"Rust","scala":"Scala","swift":"Swift","typescript":"TypeScript","Typescript":"TypeScript","ts":"TypeScript","TS":"TypeScript","mysql":"MySQL","postgresql":"PostgreSQL","postgres":"PostgreSQL","mongodb":"MongoDB","mongo":"MongoDB","redis":"Redis","sqlite":"SQLite","oracle":"Oracle","mssql":"SQL Server","sql server":"SQL Server","dynamodb":"DynamoDB","dynamo db":"DynamoDB","mariadb":"MariaDB","maria db":"MariaDB","nosql":"NoSQL","no sql":"NoSQL","bigquery":"BigQuery","big query":"BigQuery","elasticsearch":"Elasticsearch","elastic search":"Elasticsearch","cassandra":"Cassandra","couchdb":"CouchDB","couch db":"CouchDB","neo4j":"Neo4j","neo 4j":"Neo4j","influxdb":"InfluxDB","influx db":"InfluxDB","cockroachdb":"CockroachDB","cockroach db":"CockroachDB","aws":"AWS","amazon web services":"AWS","azure":"Azure","microsoft azure":"Azure","gcp":"GCP","google cloud platform":"GCP","google cloud":"GCP",".Net":".NET","angular":"Angular","angular js":"Angular","Angular js":"Angular","angularjs":"Angular","AngularJS":"Angular","apache spark":"Apache Spark","asp net":".NET","ASP net":".NET","asp.net":"ASP.NET","ASP.NET":".NET","asp.net core":".NET","ASP.NET Core":".NET","backbone":"Backbone.js","BackboneJS":"Backbone.js","backbone js":"Backbone.js","backbonejs":"Backbone.js","bootstrap":"Bootstrap","Bootstrap framework":"Bootstrap","twitter bootstrap":"Bootstrap","Twitter Bootstrap":"Bootstrap","code igniter":"CodeIgniter","codeigniter":"CodeIgniter","django":"Django","ember":"Ember.js","ember js":"Ember.js","emberjs":"Ember.js","EmberJS":"Ember.js","express":"Express","express.js":"Express","Express.js":"Express","expressjs":"Express","ExpressJS":"Express","fast api":"FastAPI","Fast api":"FastAPI","fastapi":"FastAPI","flask":"Flask","flutter":"Flutter","hadoop":"Hadoop","Hadoop":"Hadoop","ionic":"Ionic","Ionic framework":"Ionic","ionic framework":"Ionic","jquery":"jQuery","JQuery":"jQuery","JQUERY":"jQuery","laravel":"Laravel","meteor":"Meteor","meteor js":"Meteor","meteorjs":"Meteor","MeteorJS":"Meteor","nestjs":"NestJS","nest js":"NestJS","Nest JS":"NestJS","Nestjs":"NestJS","next js":"Next.js","Next js":"Next.js","next.js":"Next.js","nextjs":"Next.js","NextJS":"Next.js","node":"Node.js","Node":"Node.js","node.js":"Node.js","nodejs":"Node.js","NodeJS":"Node.js","nuxt js":"Nuxt.js","Nuxt js":"Nuxt.js","nuxt.js":"Nuxt.js","nuxtjs":"Nuxt.js","NuxtJS":"Nuxt.js","phoenix":"Phoenix","Phoenix framework":"Phoenix","pytorch":"PyTorch","Pytorch":"PyTorch","torch":"PyTorch","Torch":"PyTorch","react":"React","react.js":"React","React.js":"React","reactjs":"React","ReactJS":"React","react native":"React Native","ReactNative":"React Native","reactnative":"React Native","rn":"React Native","RN":"React Native","rails":"Ruby on Rails","Rails":"Ruby on Rails","ror":"Ruby on Rails","ROR":"Ruby on Rails","ruby on rails":"Ruby on Rails","Ruby On Rails":"Ruby on Rails","spark":"Apache Spark","Spark":"Apache Spark","spring":"Spring Boot","Spring":"Spring Boot","spring boot":"Spring Boot","Spring Boot":"Spring Boot","spring framework":"Spring Boot","Spring Framework":"Spring Boot","SpringBoot":"Spring Boot","springboot":"Spring Boot","svelte":"Svelte","symfony":"Symfony","tailwind":"Tailwind CSS","Tailwind":"Tailwind CSS","tailwind css":"Tailwind CSS","Tailwind Css":"Tailwind CSS","tailwindcss":"Tailwind CSS","TailwindCSS":"Tailwind CSS","tensorflow":"TensorFlow","Tensorflow":"TensorFlow","tensor flow":"TensorFlow","Vue":"Vue.js","vue":"Vue.js","vue js":"Vue.js","vue.js":"Vue.js","vuejs":"Vue.js","VueJS":"Vue.js","xamarin":"Xamarin","Xamarin Forms":"Xamarin","Xamarin.forms":"Xamarin","livewire":"Livewire","phpunit":"PHPUnit","alpine":"Alpine.js","alpine js":"Alpine.js","alpinejs":"Alpine.js","filament":"Filament","docker":"Docker","kubernetes":"Kubernetes","k8s":"Kubernetes","github":"GitHub","gitlab":"GitLab","bitbucket":"Bitbucket","terraform":"Terraform","puppet":"Puppet","chef":"Chef","git":"Git","jenkins":"Jenkins","kafka":"Kafka","rabbitmq":"RabbitMQ","amazon sqs":"Amazon SQS","amqp":"AMQP","pubsub":"PubSub","rest api":"REST API","restful api":"RESTful APIs","restful apis":"RESTful APIs","graphql":"GraphQL","ansible":"Ansible","vagrant":"Vagrant","vault":"Vault","consul":"Consul","prometheus":"Prometheus","grafana":"Grafana","elk stack":"ELK Stack","splunk":"Splunk","scrum":"Scrum","agile":"Agile","kanban":"Kanban","devops":"DevOps","ci\/cd":"CI\/CD","tdd":"TDD","bdd":"BDD","linux":"Linux","windows":"Windows","macos":"macOS","ubuntu":"Ubuntu","centos":"CentOS","debian":"Debian","junit":"JUnit","pytest":"PyTest","jest":"Jest","mocha":"Mocha","cypress":"Cypress","selenium":"Selenium","html":"HTML","HTML":"HTML","html5":"HTML","HTML5":"HTML","css":"CSS","CSS":"CSS","css3":"CSS","CSS3":"CSS","sass":"Sass","scss":"Sass","SCSS":"Sass","less":"Less","LESS":"Less","webpack":"Webpack","gulp":"Gulp","npm":"npm","yarn":"Yarn","sql":"SQL","full time":"Fuldtid","full-time":"Fuldtid","fuldtid":"Fuldtid","part time":"Deltid","part-time":"Deltid","deltid":"Deltid","contract":"Kontrakt","kontrakt":"Kontrakt","remote":"Fjernarbejde","fjernarbejde":"Fjernarbejde","hybrid":"Hybridarbejde","hybridarbejde":"Hybridarbejde","on-site":"Fysisk tilstedeværelse","onsite":"Fysisk tilstedeværelse","fysisk tilstedeværelse":"Fysisk tilstedeværelse"}
}

## TASK:
1. **Extract ALL coding languages and frameworks** mentioned in the job description
2. **Use the skill_aliases mapping** to normalize skill names (e.g., "JS" → "JavaScript", "React.js" → "React")
3. **Only include skills from the coding_categories** (languages and frameworks)
4. **Avoid duplicates** - if "JavaScript" and "JS" are both mentioned, only include "JavaScript"
5. **Be thorough** - look for skills mentioned in:
   - Job title
   - Job description
   - Brief summary
   - Requirements sections
   - Nice-to-have sections

## SKILL CATEGORIES TO EXTRACT:
- **Languages**: Programming languages (PHP, Python, JavaScript, Java, C#, Go, Rust, etc.)
- **Frameworks**: Web frameworks and libraries (Laravel, React, Vue.js, Angular, Django, Spring Boot, etc.)
- **Databases**: Database systems and data stores (MySQL, PostgreSQL, Redis, MongoDB, DynamoDB, etc.)
- **Tools**: Development tools and infrastructure (Git, Docker, AWS, CI/CD, Jenkins, Kafka, etc.)

## EXCLUSION RULES:
- Do NOT extract general skills (communication, languages like English, etc.)
- Do NOT extract business skills (Excel, PowerBI for non-technical roles)
- Do NOT extract work arrangements (remote, physical presence)
- Do NOT include methodologies (Agile, Scrum, etc.) unless specifically technical
- Do NOT include skills already in existing_skills_from_database

## OUTPUT FORMAT:
Return ONLY valid JSON in this exact structure:
{
  "job_id": <integer>,
  "extracted_skills": [
    {
      "skill_name": "<normalized_skill_name>",
      "category": "<languages|frameworks|databases|tools>",
      "confidence": <integer 0-100>,
      "mentioned_as": ["<original_mention_1>", "<original_mention_2>"],
      "context": "<brief_context_where_found>"
    }
  ],
  "reasoning": {
    "total_skills_found": <integer>,
    "skills_by_category": {
      "languages": ["<skill1>", "<skill2>"],
      "frameworks": ["<skill1>", "<skill2>"],
      "databases": ["<skill1>", "<skill2>"],
      "tools": ["<skill1>", "<skill2>"]
    },
    "duplicates_removed": ["<original_mention> → <normalized_name>"],
    "excluded_skills": ["<skill>", "<reason>"]
  },
  "confidence": <integer 0-100>
}

Return nothing outside the JSON object.

{
  "job_id": 4009,
  "extracted_skills": [
    {
      "skill_name": "PostgreSQL",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["PostgreSQL"],
      "context": "Our Stack Usually Looks Something Like This"
    },
    {
      "skill_name": "Next.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Next.JS", "Next.js"],
      "context": "Our Stack Usually Looks Something Like This"
    },
    {
      "skill_name": "NestJS",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Nest.JS", "NestJS"],
      "context": "Our Stack Usually Looks Something Like This"
    },
    {
      "skill_name": "React Native",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["React Native"],
      "context": "Our Stack Usually Looks Something Like This"
    },
    {
      "skill_name": "React",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["React"],
      "context": "You have some experience with React and Node.js(preferred but not required)."
    },
    {
      "skill_name": "Node.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Node.js"],
      "context": "You have some experience with React and Node.js(preferred but not required)."
    },
    {
      "skill_name": "Git",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Git"],
      "context": "Have experience with Git, Github and Docker"
    },
    {
      "skill_name": "GitHub",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["GitHub"],
      "context": "Have experience with Git, Github and Docker"
    },
    {
      "skill_name": "Docker",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Docker"],
      "context": "Have experience with Git, Github and Docker"
    },
    {
      "skill_name": "GCP",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["GCP"],
      "context": "Our Stack Usually Looks Something Like This"
    }
  ],
  "reasoning": {
    "total_skills_found": 9,
    "skills_by_category": {
      "languages": [],
      "frameworks": ["Next.js", "NestJS", "React Native", "React", "Node.js"],
      "databases": ["PostgreSQL"],
      "tools": ["Git", "GitHub", "Docker", "GCP"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}