Pipeline run

15ed8dfe-0e27-4873-9029-25b93664f346

Pipeline LLM cost (USD)

API 1: $0.0027 API 2: $0.0001 API 3: $0.0000 Total: $0.0029

Client output enrichment

v2 Skill cluster · Nature of work · AI index · Tech stack maturity · Evidence · KRA description

SPARSE JD role baseline loaded sources · ai_index: role_baseline · nature_of_work: jd · tech_stack_maturity: jd

Nature of work · Frontend service integration

Build and maintain ASP.NET MVC web applications, implementing server-side .NET logic and SQL Server data access for CRUD flows, form handling, and page-level business features.

"ASP.NET, ASP.NET MVC, SQL server and .NET"

Tech stack maturity

Mainstream Legacy

ASP.NET MVC, .NET, and SQL Server are widely used established enterprise technologies that are mature and commonly found in traditional application stacks.

AI index (0 = no AI use, 5 = totally AI-dependent · v2.1)

1.50 / 5

· Title match

· Has AI skill

· AI skill (primary)

· AI skill (secondary)

· On AI team

· Builds AI products

vocab breakdown (legacy)

Assistants (×1): —

Frameworks (×2): —

Models / concepts (×3): —

Evidence — skills matched in JD (4)

ASP.NET ASP.NET MVC SQL Server .NET

Skill cluster (1 dimension groups, role-scoped)

Cross-cutting / unaligned

ASP.NET ASP.NET MVC SQL Server .NET

Show KRA description ↓

Role : .NET Developer Skills : ASP.NET, MVC & SQL Experience : 3 Plus Years Location : Mumbai & Navi Mumbai CTC : Open Please note that the candidate with immediate - 15 Days notice period will be preferred. ASP.NET, ASP.NET MVC, SQL server and .NET

Signals

Skill dotnet-backend-developer

0.50

Alias dotnet-backend-developer

1.00

KRA java-backend-developer

0.26

Status: completed Created: 2026-05-27T14:38:21.938534Z Updated: 2026-06-12T17:28:20.363897Z API 3 duration: 7780 ms

Flow Current 3-step pipeline

1 POST /skills/extract-from-jd

2 POST /skills/extract-details

3 POST /skills/final-role-output

Role Chosen role & resolution

Web Developer

CASE A

slug: web-developer · id: 25 · source: db

Multi-alias tie (4 roles at 1.0) resolved by TIER_A_KRA: Web Developer

Resolution: in_db — role exists in library; skill↔dim and role↔dim links saved when applicable.

New skills

Skill↔dim saved

Role↔dim saved

Skipped

Job description

KGiSL is Urgently looking for ASP.NET Developers for Mumbai & Navi Mumbai Regions.

Following are the details

Details of the Opening

Role : .NET Developer

Skills : ASP.NET, MVC & SQL

Experience : 3 Plus Years

Location : Mumbai & Navi Mumbai

CTC : Open

Please note that the candidate with immediate - 15 Days notice period will be preferred.

To know more about us log on to www.kgisl.com

Skills:- ASP.NET, ASP.NET MVC, SQL server and .NET

Skills from this JD

Each row merges API 1 extraction, API 2 library match / v3 orchestration (dimensions + locked dims), and API 3 persistence tags.

ASP.NET Primary New / orchestrated API 3: new canonical path (new) New / unmatched skill (orchestrated in API 2)

Skill enrichment (orchestrator / LLM)

No Stage 7 enrichment blob on this skill (orchestrator skipped enrichment).

Derived legacy fields

Category: Web Frameworks
Sub-category: general
Skill nature: TOOL
Volatility: MEDIUM
Typical lifespan: MULTI_YEAR
Version strategy: UNVERSIONED

ASP.NET MVC Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: ASP.NET MVC id=4205 · asp-net-mvc

Aliases — catalog

ASP.NET MVC (CANONICAL) primary

Context tags (catalog)

ASP.NET Core Action Filters Dependency Injection Entity Framework HTML Helpers MVC pattern Model Binding NuGet Razor Routing Scaffolding Tag Helpers Unit Testing ViewBag Web API

Stored enrichment (catalog DB)

Category: Framework
Sub-category: Web Framework
Vendor: Microsoft
License: apache_2
Year introduced: 2009
Confidence: 0.96
Version strategy: NOT_APPLICABLE

Maturity reasoning: Vendor market signal: Microsoft has superseded ASP.NET MVC with ASP.NET Core MVC; new docs and hiring JDs overwhelmingly specify ASP.NET Core/.NET 6+ rather than classic ASP.NET MVC.

Skill profile (library / DB)

Skill nature: FRAMEWORK
Volatility: DEPRECATED
Typical lifespan: EVERGREEN
Category id: 5
Sub-category id: 35
Extractable: True
Also category: False

Dimensions (API 2 worklist)

Application Frameworks & Libraries Catalog dimension db id 451

Library dimension (catalog)

Roles linked in library: Sitecore Dev

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
Application Frameworks & Libraries application-frameworks-libraries	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

SQL Server Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: SQL Server id=18 · sql-server

Aliases — catalog

SQL Server (CANONICAL) primary
SQL Server 2000 (VERSION)
SQL Server 2005 (VERSION)
SQL Server 2008 (VERSION)
SQL Server 2012 (VERSION)
SQL Server 2014 (VERSION)
SQL Server 2016 (VERSION)
SQL Server 2017 (VERSION)
SQL Server 2019 (VERSION)
SQL Server 2022 (VERSION)
SQL Server 6.5 (VERSION)
SQL Server 7.0 (VERSION)

Context tags (catalog)

Always On CLR Integration Clustered Index ETL Execution Plan Linked Servers Query Store Replication SQL Agent SQL Server Agent SQL Server Integration Services SQL Server Management Studio SQL Server Reporting Services SSIS SSMS SSRS Stored Procedures T-SQL TempDB backup and recovery backup and restore clustering data migration data warehousing database design database normalization indexing performance tuning query optimization replication stored procedures transaction log transaction logs

Stored enrichment (catalog DB)

Category: Datastore
Sub-category: Relational Database
Vendor: Microsoft
License: proprietary
Year introduced: 1989
Confidence: 0.99
Version strategy: NOT_APPLICABLE

Maturity reasoning: SQL Server appears in many enterprise job descriptions and remains a major Microsoft-supported RDBMS with active Azure SQL/SQL Server demand; it is a common hiring-pipeline staple, not a sunset technology.

Skill profile (library / DB)

Skill nature: TOOL
Volatility: STABLE
Typical lifespan: EVERGREEN
Category id: 3
Sub-category id: 29
Extractable: True
Also category: False

Dimensions (API 2 worklist)

Relational Database Design Catalog dimension db id 4

Library dimension (catalog)

Roles linked in library: .NET Backend Developer, Backend Developer, Kotlin Backend Developer, Node.js Backend Developer, Python Backend Developer, Ruby Backend Developer, Scala Backend Developer

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
Relational Database Design relational-database-design	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

.NET Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: .NET id=3237 · net

Aliases — catalog

.NET (CANONICAL) primary
.NET 5 (VERSION)
.NET 6 (VERSION)
.NET 7 (VERSION)
.NET 8 (VERSION)
.NET Core (VERSION)

Context tags (catalog)

ADO.NET ASP.NET Azure Blazor C# CLR Entity Framework LINQ MVC Microservices NuGet Visual Studio WPF Web API XAML

Stored enrichment (catalog DB)

Category: Runtime
Sub-category: Runtime Platform
Vendor: Microsoft
License: mit
Year introduced: 2002
Confidence: 0.90
Version strategy: SEPARATE_ENTITY
Version tag: .NET (modern, i.e., .NET 6+)

Maturity reasoning: .NET appears in large volumes of job postings across enterprise, cloud, and backend roles, and Microsoft continues active releases and LTS support, indicating broad hiring-pipeline adoption.

Skill profile (library / DB)

Skill nature: RUNTIME
Volatility: STABLE
Typical lifespan: EVERGREEN
Category id: 67
Sub-category id: 2564
Extractable: True
Also category: False

Dimensions (API 2 worklist)

C# and .NET Languages Catalog dimension db id 362

Library dimension (catalog)

Roles linked in library: .NET Backend Developer

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
C# and .NET Languages c-and-net-languages	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

All API 3 persistence rows

Same grid as the skill-extractor “Persistence items” table: one row per (skill × dimension) work item.

Skill	Tag	Dimension	Skill↔dim	Role↔dim	Outcome
ASP.NET MVC	in_db	Application Frameworks & Libraries application-frameworks-libraries	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
SQL Server	in_db	Relational Database Design relational-database-design	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
.NET	in_db	C# and .NET Languages c-and-net-languages	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Library artifacts (this run)

Kind	Detail	DB id
canonical_skill_proposed	ASP.NET \| type=Web Frameworks subtype=general nature=TOOL lifespan=MULTI_YEAR

nano JD Parser — gpt-4.1-nano click to toggle

Role.NET Developer

CompanyKGiSL

Experience3 Plus Years

CTC{'max': None, 'min': None, 'raw': 'Open', 'period': None, 'currency': None}

DomainOther

Location Mumbai, India

JD type pass

Show raw JSON

{
  "JD_type": "pass",
  "about_company": null,
  "certifications": [],
  "company_name": "KGiSL",
  "ctc": {
    "currency": null,
    "max": null,
    "min": null,
    "period": null,
    "raw": "Open"
  },
  "domain": {
    "primary": {
      "aliases": [],
      "domain": "Other"
    },
    "secondary": null
  },
  "education": [],
  "experience": {
    "max": null,
    "min": 3,
    "raw": "3 Plus Years"
  },
  "job_locations": [
    {
      "aliases": [
        "Navi Mumbai"
      ],
      "city": "Mumbai",
      "country": "India",
      "state": null,
      "work_mode": null
    }
  ],
  "role": ".NET Developer",
  "role_aliases": [
    "ASP.NET Developer",
    "Software Developer",
    "Web Developer"
  ],
  "role_archetype": "Engineering",
  "roles_and_responsibilities": [
    {
      "bullet_count": 0,
      "heading": "Details of the Opening",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "Role : .NET Developer",
        "last_5_words": "will be preferred."
      },
      "text": "Role : .NET Developer\n\nSkills : ASP.NET, MVC \u0026 SQL\n\nExperience : 3 Plus Years\n\nLocation : Mumbai \u0026 Navi Mumbai\n\nCTC : Open\n\nPlease note that the candidate with immediate - 15 Days notice period will be preferred.",
      "word_count": 49
    },
    {
      "bullet_count": 0,
      "heading": "Skills",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "ASP.NET, ASP.NET MVC, SQL",
        "last_5_words": "and .NET"
      },
      "text": "ASP.NET, ASP.NET MVC, SQL server and .NET",
      "word_count": 8
    }
  ],
  "urls": [
    {
      "type": "website",
      "url": "http://www.kgisl.com"
    }
  ]
}

API 1 — extract-from-jd click to toggle

{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "ASP.NET"
    },
    {
      "is_primary": true,
      "skill_name": "ASP.NET MVC"
    },
    {
      "is_primary": true,
      "skill_name": "SQL Server"
    },
    {
      "is_primary": true,
      "skill_name": ".NET"
    }
  ],
  "jd_role": {
    "display_name": ".NET Developer",
    "rationale": null,
    "role_aliases": [
      "ASP.NET Developer",
      "Software Developer",
      "Web Developer"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": null,
    "certifications": [],
    "company_name": "KGiSL",
    "ctc": {
      "currency": null,
      "max": null,
      "min": null,
      "period": null,
      "raw": "Open"
    },
    "domain": {
      "primary": {
        "aliases": [],
        "domain": "Other"
      },
      "secondary": null
    },
    "education": [],
    "experience": {
      "max": null,
      "min": 3,
      "raw": "3 Plus Years"
    },
    "job_locations": [
      {
        "aliases": [
          "Navi Mumbai"
        ],
        "city": "Mumbai",
        "country": "India",
        "state": null,
        "work_mode": null
      }
    ],
    "role": ".NET Developer",
    "role_aliases": [
      "ASP.NET Developer",
      "Software Developer",
      "Web Developer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 0,
        "heading": "Details of the Opening",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Role : .NET Developer",
          "last_5_words": "will be preferred."
        },
        "text": "Role : .NET Developer\n\nSkills : ASP.NET, MVC \u0026 SQL\n\nExperience : 3 Plus Years\n\nLocation : Mumbai \u0026 Navi Mumbai\n\nCTC : Open\n\nPlease note that the candidate with immediate - 15 Days notice period will be preferred.",
        "word_count": 49
      },
      {
        "bullet_count": 0,
        "heading": "Skills",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "ASP.NET, ASP.NET MVC, SQL",
          "last_5_words": "and .NET"
        },
        "text": "ASP.NET, ASP.NET MVC, SQL server and .NET",
        "word_count": 8
      }
    ],
    "urls": [
      {
        "type": "website",
        "url": "http://www.kgisl.com"
      }
    ]
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "15ed8dfe-0e27-4873-9029-25b93664f346",
  "stage3_signals": {
    "alias_found": true,
    "alias_match_roles": [
      {
        "display_name": ".NET Backend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 83,
        "score": 1.0,
        "slug": "dotnet-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 1,
        "score": 1.0,
        "slug": "backend-engineer",
        "total_count": null
      },
      {
        "display_name": "Frontend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 7,
        "score": 1.0,
        "slug": "frontend-engineer",
        "total_count": null
      },
      {
        "display_name": "Web Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 25,
        "score": 1.0,
        "slug": "web-developer",
        "total_count": null
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "Java Backend Developer",
        "kra_matches": [
          {
            "kra_text": "asynchronous job processing",
            "sentence": "Please note that the candidate with immediate - 15 Days notice period will be preferred.",
            "similarity": 0.2574
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 79,
        "score": 0.2574,
        "slug": "java-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Node.js Backend Developer",
        "kra_matches": [
          {
            "kra_text": "asynchronous job processing",
            "sentence": "Please note that the candidate with immediate - 15 Days notice period will be preferred.",
            "similarity": 0.2574
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 82,
        "score": 0.2574,
        "slug": "node-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Ionic Developer",
        "kra_matches": [
          {
            "kra_text": "offline-aware workflow handling",
            "sentence": "Please note that the candidate with immediate - 15 Days notice period will be preferred.",
            "similarity": 0.2491
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 434,
        "score": 0.2491,
        "slug": "ionic-developer",
        "total_count": null
      },
      {
        "display_name": "Go Backend Developer",
        "kra_matches": [
          {
            "kra_text": "background job processing",
            "sentence": "Please note that the candidate with immediate - 15 Days notice period will be preferred.",
            "similarity": 0.2454
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 81,
        "score": 0.2454,
        "slug": "go-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Web Developer",
        "kra_matches": [
          {
            "kra_text": "apply accessibility requirements",
            "sentence": "Please note that the candidate with immediate - 15 Days notice period will be preferred.",
            "similarity": 0.2232
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 25,
        "score": 0.2232,
        "slug": "web-developer",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": ".NET Backend Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          ".NET",
          "SQL Server"
        ],
        "role_id": 83,
        "score": 0.5,
        "slug": "dotnet-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "Python Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 80,
        "score": 0.25,
        "slug": "python-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "Node.js Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 82,
        "score": 0.25,
        "slug": "node-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "Kotlin Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 84,
        "score": 0.25,
        "slug": "kotlin-server-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "Ruby Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 85,
        "score": 0.25,
        "slug": "ruby-backend-developer",
        "total_count": 4
      }
    ]
  },
  "stage4_decision": {
    "alias_collision_detected": true,
    "case": "A",
    "chosen_role": {
      "display_name": "Web Developer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 25,
      "score": 1.0,
      "slug": "web-developer",
      "total_count": null
    },
    "confidence": 0.95,
    "is_new_role": false,
    "llm2_fired": false,
    "llm2_reasoning": null,
    "matched_dimensions": [],
    "matched_kras": [],
    "matched_skills": [],
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "Multi-alias tie (4 roles at 1.0) resolved by TIER_A_KRA: Web Developer",
    "sub_role": null
  },
  "stage5_updates": null
}

API 2 — extract-details

{
  "alias_matches": [
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 5928,
      "existing_alias_text": "ASP.NET MVC",
      "input_term": "ASP.NET MVC",
      "matched_canonical": {
        "category_id": 5,
        "display_name": "ASP.NET MVC",
        "id": 4205,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "FRAMEWORK",
        "slug": "asp-net-mvc",
        "sub_category_id": 35,
        "typical_lifespan": "EVERGREEN",
        "volatility": "DEPRECATED"
      },
      "matched_via": "alias"
    },
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 135,
      "existing_alias_text": "SQL Server",
      "input_term": "SQL Server",
      "matched_canonical": {
        "category_id": 3,
        "display_name": "SQL Server",
        "id": 18,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "TOOL",
        "slug": "sql-server",
        "sub_category_id": 29,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    },
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 4766,
      "existing_alias_text": ".NET",
      "input_term": ".NET",
      "matched_canonical": {
        "category_id": 67,
        "display_name": ".NET",
        "id": 3237,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "RUNTIME",
        "slug": "net",
        "sub_category_id": 2564,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    }
  ],
  "candidate_roles": [
    {
      "display_name": "Sitecore Dev",
      "id": 233,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "sitecore-dev",
      "source": "db"
    },
    {
      "display_name": ".NET Backend Developer",
      "id": 83,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "dotnet-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Backend Developer",
      "id": 1,
      "rationale": null,
      "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
      "slug": "backend-engineer",
      "source": "db"
    },
    {
      "display_name": "Kotlin Backend Developer",
      "id": 84,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "kotlin-server-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Node.js Backend Developer",
      "id": 82,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "node-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Python Backend Developer",
      "id": 80,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "python-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Ruby Backend Developer",
      "id": 85,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "ruby-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Scala Backend Developer",
      "id": 87,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "scala-backend-developer",
      "source": "db"
    }
  ],
  "chosen_role": {
    "display_name": "Web Developer",
    "id": 25,
    "rationale": "Multi-alias tie (4 roles at 1.0) resolved by TIER_A_KRA: Web Developer",
    "role_archetype": null,
    "slug": "web-developer",
    "source": "db"
  },
  "dimensions": [
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Application Frameworks \u0026 Libraries",
        "id": 451,
        "rationale": "Covers the primary software frameworks and libraries often used alongside Sitecore for building and enhancing site experiences.",
        "slug": "application-frameworks-libraries",
        "source": "db"
      },
      "input_skill": "ASP.NET MVC",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Sitecore Dev",
          "id": 233,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "sitecore-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Relational Database Design",
        "id": 4,
        "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
        "slug": "relational-database-design",
        "source": "db"
      },
      "input_skill": "SQL Server",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": ".NET Backend Developer",
          "id": 83,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "dotnet-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Backend Developer",
          "id": 1,
          "rationale": null,
          "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
          "slug": "backend-engineer",
          "source": "db"
        },
        {
          "display_name": "Kotlin Backend Developer",
          "id": 84,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "kotlin-server-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Node.js Backend Developer",
          "id": 82,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "node-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Python Backend Developer",
          "id": 80,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "python-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Ruby Backend Developer",
          "id": 85,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "ruby-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Scala Backend Developer",
          "id": 87,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "scala-backend-developer",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "C# and .NET Languages",
        "id": 362,
        "rationale": "Primary implementation languages and runtime features used to build backend service logic in the .NET ecosystem. This is the core coding surface for request handling, domain logic, and service internals.",
        "slug": "c-and-net-languages",
        "source": "db"
      },
      "input_skill": ".NET",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": ".NET Backend Developer",
          "id": 83,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "dotnet-backend-developer",
          "source": "db"
        }
      ]
    }
  ],
  "input_final_skills": [
    "ASP.NET",
    "ASP.NET MVC",
    "SQL Server",
    ".NET"
  ],
  "input_llm_skills": [
    "ASP.NET",
    "ASP.NET MVC",
    "SQL Server",
    ".NET"
  ],
  "new_aliases_persisted": 0,
  "run_id": "15ed8dfe-0e27-4873-9029-25b93664f346",
  "skills_detail": [
    {
      "aliases_in_db": [],
      "canonical": null,
      "dimensions": [],
      "input_skill": "ASP.NET",
      "matched_via": null,
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": {
        "derived": {
          "category": "Web Frameworks",
          "skill_nature": "TOOL",
          "sub_category": "general",
          "typical_lifespan": "MULTI_YEAR",
          "version_strategy": "UNVERSIONED",
          "volatility": "MEDIUM"
        },
        "enrichment": null,
        "keep_log": [],
        "locked_dimensions": [],
        "merge_log": [],
        "placed": null,
        "relationships": null,
        "skill_id": "asp-net",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [
        {
          "alias_text": "ASP.NET MVC",
          "alias_type": "CANONICAL",
          "id": 5928,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 5,
        "display_name": "ASP.NET MVC",
        "id": 4205,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "FRAMEWORK",
        "slug": "asp-net-mvc",
        "sub_category_id": 35,
        "typical_lifespan": "EVERGREEN",
        "volatility": "DEPRECATED"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Application Frameworks \u0026 Libraries",
            "id": 451,
            "rationale": "Covers the primary software frameworks and libraries often used alongside Sitecore for building and enhancing site experiences.",
            "slug": "application-frameworks-libraries",
            "source": "db"
          },
          "input_skill": "ASP.NET MVC",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Sitecore Dev",
              "id": 233,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "sitecore-dev",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "ASP.NET MVC",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [
        {
          "alias_text": "SQL Server",
          "alias_type": "CANONICAL",
          "id": 135,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2000",
          "alias_type": "VERSION",
          "id": 138,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2005",
          "alias_type": "VERSION",
          "id": 139,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2008",
          "alias_type": "VERSION",
          "id": 140,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2012",
          "alias_type": "VERSION",
          "id": 141,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2014",
          "alias_type": "VERSION",
          "id": 142,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2016",
          "alias_type": "VERSION",
          "id": 143,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2017",
          "alias_type": "VERSION",
          "id": 144,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2019",
          "alias_type": "VERSION",
          "id": 145,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 2022",
          "alias_type": "VERSION",
          "id": 146,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 6.5",
          "alias_type": "VERSION",
          "id": 136,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "SQL Server 7.0",
          "alias_type": "VERSION",
          "id": 137,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 3,
        "display_name": "SQL Server",
        "id": 18,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "TOOL",
        "slug": "sql-server",
        "sub_category_id": 29,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Relational Database Design",
            "id": 4,
            "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
            "slug": "relational-database-design",
            "source": "db"
          },
          "input_skill": "SQL Server",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": ".NET Backend Developer",
              "id": 83,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "dotnet-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Backend Developer",
              "id": 1,
              "rationale": null,
              "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
              "slug": "backend-engineer",
              "source": "db"
            },
            {
              "display_name": "Kotlin Backend Developer",
              "id": 84,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "kotlin-server-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Node.js Backend Developer",
              "id": 82,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "node-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Python Backend Developer",
              "id": 80,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "python-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Ruby Backend Developer",
              "id": 85,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "ruby-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Scala Backend Developer",
              "id": 87,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "scala-backend-developer",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "SQL Server",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [
        {
          "alias_text": ".NET",
          "alias_type": "CANONICAL",
          "id": 4766,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": ".NET 5",
          "alias_type": "VERSION",
          "id": 4767,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": ".NET 6",
          "alias_type": "VERSION",
          "id": 4768,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": ".NET 7",
          "alias_type": "VERSION",
          "id": 4769,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": ".NET 8",
          "alias_type": "VERSION",
          "id": 4770,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": ".NET Core",
          "alias_type": "VERSION",
          "id": 4771,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 67,
        "display_name": ".NET",
        "id": 3237,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "RUNTIME",
        "slug": "net",
        "sub_category_id": 2564,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "C# and .NET Languages",
            "id": 362,
            "rationale": "Primary implementation languages and runtime features used to build backend service logic in the .NET ecosystem. This is the core coding surface for request handling, domain logic, and service internals.",
            "slug": "c-and-net-languages",
            "source": "db"
          },
          "input_skill": ".NET",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": ".NET Backend Developer",
              "id": 83,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "dotnet-backend-developer",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": ".NET",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    }
  ],
  "unmatched_skills": [
    "ASP.NET"
  ]
}

API 3 — final-role-output

{
  "chosen_role": {
    "display_name": "Web Developer",
    "id": 25,
    "rationale": "Multi-alias tie (4 roles at 1.0) resolved by TIER_A_KRA: Web Developer",
    "role_archetype": null,
    "slug": "web-developer",
    "source": "db"
  },
  "chosen_role_resolution": "in_db",
  "final_input_skills": [
    {
      "skill": "ASP.NET",
      "tag": "new"
    },
    {
      "skill": "ASP.NET MVC",
      "tag": "in_db"
    },
    {
      "skill": "SQL Server",
      "tag": "in_db"
    },
    {
      "skill": ".NET",
      "tag": "in_db"
    }
  ],
  "llm_cost_api1_usd": null,
  "llm_cost_api2_usd": null,
  "llm_cost_api3_usd": null,
  "llm_cost_total_usd": null,
  "persistence": {
    "items": [
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Application Frameworks \u0026 Libraries",
          "id": 451,
          "rationale": "Covers the primary software frameworks and libraries often used alongside Sitecore for building and enhancing site experiences.",
          "slug": "application-frameworks-libraries",
          "source": "db"
        },
        "dimension_id": 451,
        "input_skill": "ASP.NET MVC",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Sitecore Dev",
            "id": 233,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "sitecore-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 4205,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Relational Database Design",
          "id": 4,
          "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
          "slug": "relational-database-design",
          "source": "db"
        },
        "dimension_id": 4,
        "input_skill": "SQL Server",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": ".NET Backend Developer",
            "id": 83,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "dotnet-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Backend Developer",
            "id": 1,
            "rationale": null,
            "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
            "slug": "backend-engineer",
            "source": "db"
          },
          {
            "display_name": "Kotlin Backend Developer",
            "id": 84,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "kotlin-server-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Node.js Backend Developer",
            "id": 82,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "node-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Python Backend Developer",
            "id": 80,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "python-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Ruby Backend Developer",
            "id": 85,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "ruby-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Scala Backend Developer",
            "id": 87,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "scala-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 18,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "C# and .NET Languages",
          "id": 362,
          "rationale": "Primary implementation languages and runtime features used to build backend service logic in the .NET ecosystem. This is the core coding surface for request handling, domain logic, and service internals.",
          "slug": "c-and-net-languages",
          "source": "db"
        },
        "dimension_id": 362,
        "input_skill": ".NET",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": ".NET Backend Developer",
            "id": 83,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "dotnet-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 3237,
        "skill_tag": "in_db",
        "skipped_reason": null
      }
    ],
    "new_skills_created": 0,
    "role_dimension_saved": 0,
    "skill_dimension_saved": 0,
    "skipped": 0
  },
  "planner_output": null,
  "run_id": "15ed8dfe-0e27-4873-9029-25b93664f346"
}

LLM Calls

Every model call made for this run, in pipeline order. Click a card to see the model's response.

Loading…