# 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":4005,"title":"Software Developer - start your career within the defence software domain","company_name":"Systematic","description":"About the job\n\nNewly graduated Software Developer – start your career in the defence domain\n\nAre you passionate about developing and delivering valuable software solutions that help improve the daily lives of our customers in the defence sector? Then seize this opportunity to get your career off to an exciting start at Systematic as a Software Developer at our Copenhagen office.\n\nThe job we offer\nJoining Systematic as a newly graduated Developer, you will work alongside dedicated colleagues who share your passion for creating the best solutions for our customers. We encourage knowledge sharing and are constantly trying to develop smarter processes. In a working environment characterised by a structured work environment and high levels of responsibility, you can grow and determine your path, either as a Software Specialist, Software Architect or Project Manager.\n\nThis job is for you if you want to work with various technological solutions and methods. It is an advantage, if you are familiar with some of the following technologies, which we use:\n\n\n Java EE, .NET (C#), Scala – here, experience with Java would be a plus\n HTML, CSS, JavaScript (Angular\/AngularJS)\n REST, HTTP\/S\n SQL (MSSQL, MySQL, PostgreSQL)\n Spring Boot\n Docker\n Kubernetes\n\n\n\nYou do not need to have experience with all of it, as long as you bring the foundation and motivation, we can support you in learning much of the rest. \n\nDeveloping excellent software to save lives\nAt Systematic, we believe that software, when built and used properly, can help create a better society for everyone. As a Software Developer within our Defence business area, you will have the opportunity to develop software solutions that simplify complex processes and increase efficiency for our customers.\n\nOur teams value collaboration and a commitment to excellence, which means you will have the chance to work closely with and learn from experienced professionals who are dedicated to delivering high-quality software solutions.\n\nFrom your first day with us, you will receive comprehensive training and ongoing support to ensure your success – and this includes having a mentor. We know that you still have to learn, but what better way to learn than by doing it?\n\nYour Qualifications\nWe are looking for new colleagues with a master's degree in computer science, computer engineering, or something similar. Especially if you are about to graduate and are keen to apply your technological skills. The specific tech stack can differ with the different teams but expect to be working with java, Angular, Docker, Kubernetes and Azure.\n\nNevertheless, it is advantageous if:\n\n\n You are cooperative and strive to make a positive contribution to team dynamics\n You are ambitious and always working to improve yourself as a motivated team player\n You work systematically while paying close attention to detail, and you take pride in understanding complex solutions and customer challenges.\n You are fluent in English, as it is our corporate language used daily in conversations with colleagues worldwide\n\n\n\nPlease note that you must be able to present a clean criminal record and have lived in a NATO\/EU country for the past seven years as we work with security-classified projects. Read more here.\n\nWhat To Expect From Systematic\nSystematic is truly international, proudly Danish and uniquely people-centric. Together, we write intelligent and innovative code to drive progress and improve lives. We develop IT solutions that make a real difference where it matters most. This is why we never stop developing. Here, there is room to be professional and personal. It is not just a place to work but a place to belong.\n\nWelcome to Systematic Copenhagen \nWhen you join us in Copenhagen, you're not just getting a desk at one of the city’s best locations—you’re stepping into a workplace where community matters. Our Employees Club keeps things lively with monthly social events, and our office catering makes sure you’re always well taken care of. Whether you’re into casual games or just good company, you’ll find both at our foosball table or during our relaxed Friday bar gatherings.\n\nStart your career with us\nWe will be assessing applications on an ongoing basis and expect to conduct interviews ongoingly, so apply as soon as possible.\n\nSo click Apply Now and send us your CV today.\n\nIf you have any questions, you are always welcome to contact us on tel. +45 8943 2000 and ask for Kathrine Schlegel Rasmussen, Senior Talent Acquisition Consultant, for more information about the position.\n\nGet in touch\n\nKathrine Schlegel Rasmussen\n\nSenior Talent Acquisition Consultant","brief_summary_of_job":null,"existing_skills_from_job":["CSS","HTML","JavaScript","Scala","Angular","Spring Boot","MySQL","PostgreSQL","Kubernetes","Azure"],"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": 4005,
  "extracted_skills": [
    {
      "skill_name": "Java",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": ["Java", "java"],
      "context": "Mentioned as a technology used in the job description."
    },
    {
      "skill_name": "C#",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": [".NET (C#)", "C#"],
      "context": "Mentioned as part of the .NET technology stack."
    },
    {
      "skill_name": "Scala",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": ["Scala", "scala"],
      "context": "Listed as a technology used in the job description."
    },
    {
      "skill_name": "HTML",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": ["HTML", "html"],
      "context": "Mentioned in the context of front-end development."
    },
    {
      "skill_name": "CSS",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": ["CSS", "css"],
      "context": "Mentioned in the context of front-end development."
    },
    {
      "skill_name": "JavaScript",
      "category": "languages",
      "confidence": 90,
      "mentioned_as": ["JavaScript", "Java script", "javascript", "JS"],
      "context": "Mentioned in the context of front-end development."
    },
    {
      "skill_name": "Angular",
      "category": "frameworks",
      "confidence": 90,
      "mentioned_as": ["Angular", "AngularJS", "angular", "angularjs"],
      "context": "Mentioned as a technology used in the job description."
    },
    {
      "skill_name": "Spring Boot",
      "category": "frameworks",
      "confidence": 90,
      "mentioned_as": ["Spring Boot", "spring boot"],
      "context": "Mentioned as part of the technology stack."
    },
    {
      "skill_name": "MySQL",
      "category": "databases",
      "confidence": 90,
      "mentioned_as": ["MySQL", "mysql"],
      "context": "Mentioned as a database technology used."
    },
    {
      "skill_name": "PostgreSQL",
      "category": "databases",
      "confidence": 90,
      "mentioned_as": ["PostgreSQL", "postgresql"],
      "context": "Mentioned as a database technology used."
    },
    {
      "skill_name": "Docker",
      "category": "tools",
      "confidence": 90,
      "mentioned_as": ["Docker", "docker"],
      "context": "Mentioned as part of the technology stack."
    },
    {
      "skill_name": "Kubernetes",
      "category": "tools",
      "confidence": 90,
      "mentioned_as": ["Kubernetes", "kubernetes"],
      "context": "Mentioned as part of the technology stack."
    },
    {
      "skill_name": "Azure",
      "category": "tools",
      "confidence": 90,
      "mentioned_as": ["Azure", "azure"],
      "context": "Mentioned as part of the technology stack."
    }
  ],
  "reasoning": {
    "total_skills_found": 12,
    "skills_by_category": {
      "languages": ["Java", "C#", "Scala", "HTML", "CSS", "JavaScript"],
      "frameworks": ["Angular", "Spring Boot"],
      "databases": ["MySQL", "PostgreSQL"],
      "tools": ["Docker", "Kubernetes", "Azure"]
    },
    "duplicates_removed": ["JS → JavaScript"],
    "excluded_skills": []
  },
  "confidence": 95
}