← Back to history

Pipeline run

952d9697-c383-4578-b458-aa1f9dc6eab1

Pipeline LLM cost (USD)
API 1: $0.0098 API 2: $0.0001 API 3: $0.0000 Total: $0.0099

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: role_baseline
Nature of work · Performance and production support
Support and enhance C-Hub/ABD apps by handling production issues, monthly releases, and new SQL Server/Microsoft web features, while coordinating with US teams, reporting status, and tuning modules for performance and standards compliance.
"Work with ABD India Application Support and Business Support team to address production issues and/or to do development work"
Tech stack maturity
Modern Cloud Native
Backend development today is typically built around cloud-hosted services, containers, CI/CD, and distributed systems, but AI is usually only an optional integration rather than the core of the role.
AI index (0 = no AI use, 5 = totally AI-dependent · v2.1)
1.80 / 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 (2)
SQL Server Microsoft Web
Skill cluster (2 dimension groups, role-scoped)
Relational Database Design
SQL Server
Cross-cutting / unaligned
Microsoft Web
Show KRA description ↓
• To work on C-Hub and other ABD applications as required • Work with ABD India Application Support and Business Support team to address production issues and/or to do development work • Work with US ABD team to coordinate the on-going support and monthly release of C-Hub and other ABD Applications Report status to management on project progress • Identify and escalate related issues and risks • Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies • Assess current modules and offer performance improvements techniques • Make sure Database Design Standards/coding standards established by ABD are followed Constant communication with ABD leadership team in US. Problem Solving ability with “Can-do” attitude IT experience in Banking industry is preferred

Signals

Skill backend-engineer
0.50
Alias backend-engineer
1.00
KRA flutter-developer
0.47

Post-classification

Centroidupdated · n=142
Alias collision log
New-role queue
New skills captured1
New KRA captured

Captured for admin review

Microsoft Web primary Backend Developer pending
Status: completed Created: 2026-05-27T13:43:26.396568Z Updated: 2026-05-27T13:44:11.347243Z API 3 duration: 6390 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

Backend Developer

.NET Backend Developer

sub-role · 0.92 domain · Software Engineering CASE DOMAIN

slug: backend-engineer · id: 1 · source: db · sub-role slug: dotnet-backend-developer

Domain=Software Engineering → sub-role dotnet-backend-developer; The JD is for a .NET / SQL Server application support and development role focused on backend business applications, production support, releases, and performance improvements.

Matched skills

.NETSQL ServerMS Web based technologiesDatabase Design Standardscoding standards

Matched dimensions

Backend Application DevelopmentProduction SupportRelease CoordinationDatabase Design and Performance OptimizationCross-team Stakeholder Communication

Matched KRAs

Work on C-Hub and other ABD applicationsAddress production issues and/or do development workCoordinate the on-going support and monthly releaseReport status to management on project progressIdentify and escalate related issues and risksImplement new features of SQL Server/ MS Web based technologiesAssess current modules and offer performance improvements techniquesMake sure Database Design Standards/coding standards are followed

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

0
New skills
0
Skill↔dim saved
0
Role↔dim saved
0
Skipped

Job description

Net Developer: 
Job Requirements: 
Minimum 4-7 years of experience and Bachelor's degree in Engineering, Accounting, Finance, or equivalent with Good communication 
Skills
• Strong background in Microsoft Technologies and SDLC concepts. 
• Should have experience in below technologies: 
• Microsoft .Net (ASP.NET & ASP .NET CORE) 
• C#, JavaScript, CSS, JQuery /Angular 2 +(Angular version 2 or higher), Typescript 
• MVC and WebAPI ü MS SQL Server management Studio (SSMS) to develop database objects such as Stored Procedures, Functions, views, triggers, constraints etc. and look for performance tuning and Exception handling for these components 
Good to have: 
• Understanding of MS Excel VBA /MS-access/ macro codes
Responsibilities:
• To work on C-Hub and other ABD applications as required 
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work 
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub and other ABD Applications Report status to management on project progress 
• Identify and escalate related issues and risks 
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques 
• Make sure Database Design Standards/coding standards established by ABD are followed Constant communication with ABD leadership team in US. Problem Solving ability with “Can-do” attitude IT experience in Banking industry is preferred

Skills from this JD

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

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 saved
Microsoft Web 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

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 Notes
SQL Server in_db
Relational Database Design
relational-database-design
Existing dimension (library) · Role↔dimension saved

Library artifacts (this run)

Kind Detail DB id
canonical_skill_proposed Microsoft Web | type=Web Frameworks subtype=general nature=TOOL lifespan=MULTI_YEAR
nano JD Parser — gpt-4.1-nano click to toggle
RoleNet Developer
ExperienceMinimum 4-7 years of experience
DomainOther
JD type pass
Show raw JSON
{
  "JD_type": "pass",
  "about_company": null,
  "certifications": [],
  "company_name": null,
  "ctc": null,
  "domain": {
    "primary": {
      "aliases": [],
      "domain": "Other"
    },
    "secondary": null
  },
  "education": [
    {
      "level": "Bachelor\u0027s",
      "qualification": "BTECH/BE - Engineering / Accounting / Finance (or equivalent)",
      "raw": "Bachelor\u0027s degree in Engineering, Accounting, Finance, or equivalent",
      "requirement": "required"
    }
  ],
  "experience": {
    "max": 7,
    "min": 4,
    "raw": "Minimum 4-7 years of experience"
  },
  "job_locations": [],
  "role": "Net Developer",
  "role_aliases": [
    ".NET Developer",
    "Software Developer",
    "C# Developer"
  ],
  "role_archetype": "Engineering",
  "roles_and_responsibilities": [
    {
      "bullet_count": 7,
      "heading": "Responsibilities",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "\u2022 To work on C-Hub",
        "last_5_words": "in Banking industry is preferred"
      },
      "text": "\u2022 To work on C-Hub and other ABD applications as required \n\u2022 Work with ABD India Application Support and Business Support team to address production issues and/or to do development work \n\u2022 Work with US ABD team to coordinate the on-going support and monthly release of C-Hub and other ABD Applications Report status to management on project progress \n\u2022 Identify and escalate related issues and risks \n\u2022 Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies \n\u2022 Assess current modules and offer performance improvements techniques \n\u2022 Make sure Database Design Standards/coding standards established by ABD are followed Constant communication with ABD leadership team in US. Problem Solving ability with \u201cCan-do\u201d attitude IT experience in Banking industry is preferred",
      "word_count": 108
    }
  ],
  "urls": []
}
API 1 — extract-from-jd click to toggle
{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "SQL Server"
    },
    {
      "is_primary": true,
      "skill_name": "Microsoft Web"
    }
  ],
  "jd_role": {
    "display_name": "Net Developer",
    "rationale": null,
    "role_aliases": [
      ".NET Developer",
      "Software Developer",
      "C# Developer"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": null,
    "certifications": [],
    "company_name": null,
    "ctc": null,
    "domain": {
      "primary": {
        "aliases": [],
        "domain": "Other"
      },
      "secondary": null
    },
    "education": [
      {
        "level": "Bachelor\u0027s",
        "qualification": "BTECH/BE - Engineering / Accounting / Finance (or equivalent)",
        "raw": "Bachelor\u0027s degree in Engineering, Accounting, Finance, or equivalent",
        "requirement": "required"
      }
    ],
    "experience": {
      "max": 7,
      "min": 4,
      "raw": "Minimum 4-7 years of experience"
    },
    "job_locations": [],
    "role": "Net Developer",
    "role_aliases": [
      ".NET Developer",
      "Software Developer",
      "C# Developer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 7,
        "heading": "Responsibilities",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "\u2022 To work on C-Hub",
          "last_5_words": "in Banking industry is preferred"
        },
        "text": "\u2022 To work on C-Hub and other ABD applications as required \n\u2022 Work with ABD India Application Support and Business Support team to address production issues and/or to do development work \n\u2022 Work with US ABD team to coordinate the on-going support and monthly release of C-Hub and other ABD Applications Report status to management on project progress \n\u2022 Identify and escalate related issues and risks \n\u2022 Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies \n\u2022 Assess current modules and offer performance improvements techniques \n\u2022 Make sure Database Design Standards/coding standards established by ABD are followed Constant communication with ABD leadership team in US. Problem Solving ability with \u201cCan-do\u201d attitude IT experience in Banking industry is preferred",
        "word_count": 108
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "952d9697-c383-4578-b458-aa1f9dc6eab1",
  "stage3_signals": {
    "alias_found": true,
    "alias_match_roles": [
      {
        "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": ".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
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "Flutter Developer",
        "kra_matches": [
          {
            "kra_text": "optimize responsiveness and performance",
            "sentence": "Assess current modules and offer performance improvements techniques",
            "similarity": 0.503
          },
          {
            "kra_text": "collaborate with design, product, and backend teams",
            "sentence": "Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies",
            "similarity": 0.486
          },
          {
            "kra_text": "collaborate with design, product, and backend teams",
            "sentence": "Make sure Database Design Standards/coding standards established by ABD are followed Constant communication with ABD leadership team in US.",
            "similarity": 0.4133
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 74,
        "score": 0.4674,
        "slug": "flutter-developer",
        "total_count": null
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": [
          {
            "kra_text": "Investigates and resolves production incidents, API bugs, and service degradation through root cause analysis, hotfixes, and post-mortems.",
            "sentence": "Work with ABD India Application Support and Business Support team to address production issues and/or to do development work",
            "similarity": 0.4774
          },
          {
            "kra_text": "Investigates and resolves production incidents, API bugs, and service degradation through root cause analysis, hotfixes, and post-mortems.",
            "sentence": "Identify and escalate related issues and risks",
            "similarity": 0.4736
          },
          {
            "kra_text": "Identifies and resolves backend performance bottlenecks through query optimization, indexing strategies, connection pooling, and distributed caching with Redis.",
            "sentence": "Assess current modules and offer performance improvements techniques",
            "similarity": 0.439
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 1,
        "score": 0.4633,
        "slug": "backend-engineer",
        "total_count": null
      },
      {
        "display_name": "Ruby Backend Developer",
        "kra_matches": [
          {
            "kra_text": "performance and reliability improvements",
            "sentence": "Assess current modules and offer performance improvements techniques",
            "similarity": 0.4879
          },
          {
            "kra_text": "backend defect diagnosis and fixes",
            "sentence": "Work with ABD India Application Support and Business Support team to address production issues and/or to do development work",
            "similarity": 0.4621
          },
          {
            "kra_text": "Server-side feature implementation",
            "sentence": "Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies",
            "similarity": 0.4379
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 85,
        "score": 0.4626,
        "slug": "ruby-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Scala Backend Developer",
        "kra_matches": [
          {
            "kra_text": "performance and reliability tuning",
            "sentence": "Assess current modules and offer performance improvements techniques",
            "similarity": 0.5511
          },
          {
            "kra_text": "Server-side feature implementation",
            "sentence": "Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies",
            "similarity": 0.4379
          },
          {
            "kra_text": "defect investigation and fixes",
            "sentence": "Work with ABD India Application Support and Business Support team to address production issues and/or to do development work",
            "similarity": 0.3904
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 87,
        "score": 0.4598,
        "slug": "scala-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Java Backend Developer",
        "kra_matches": [
          {
            "kra_text": "backend performance tuning",
            "sentence": "Assess current modules and offer performance improvements techniques",
            "similarity": 0.5588
          },
          {
            "kra_text": "code refactoring and defect fixes",
            "sentence": "To work on C-Hub and other ABD applications as required",
            "similarity": 0.398
          },
          {
            "kra_text": "service endpoint development",
            "sentence": "Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies",
            "similarity": 0.3964
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 79,
        "score": 0.4511,
        "slug": "java-backend-developer",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 1,
        "score": 0.5,
        "slug": "backend-engineer",
        "total_count": 2
      },
      {
        "display_name": "Python Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 80,
        "score": 0.5,
        "slug": "python-backend-developer",
        "total_count": 2
      },
      {
        "display_name": "Node.js Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 82,
        "score": 0.5,
        "slug": "node-backend-developer",
        "total_count": 2
      },
      {
        "display_name": ".NET Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 83,
        "score": 0.5,
        "slug": "dotnet-backend-developer",
        "total_count": 2
      },
      {
        "display_name": "Kotlin Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "SQL Server"
        ],
        "role_id": 84,
        "score": 0.5,
        "slug": "kotlin-server-backend-developer",
        "total_count": 2
      }
    ]
  },
  "stage4_decision": {
    "alias_collision_detected": false,
    "case": "DOMAIN",
    "chosen_role": {
      "display_name": "Backend Developer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 1,
      "score": 0.98,
      "slug": "backend-engineer",
      "total_count": null
    },
    "confidence": 0.98,
    "is_new_role": false,
    "llm2_fired": false,
    "llm2_reasoning": null,
    "matched_dimensions": [
      "Backend Application Development",
      "Production Support",
      "Release Coordination",
      "Database Design and Performance Optimization",
      "Cross-team Stakeholder Communication"
    ],
    "matched_kras": [
      "Work on C-Hub and other ABD applications",
      "Address production issues and/or do development work",
      "Coordinate the on-going support and monthly release",
      "Report status to management on project progress",
      "Identify and escalate related issues and risks",
      "Implement new features of SQL Server/ MS Web based technologies",
      "Assess current modules and offer performance improvements techniques",
      "Make sure Database Design Standards/coding standards are followed"
    ],
    "matched_skills": [
      ".NET",
      "SQL Server",
      "MS Web based technologies",
      "Database Design Standards",
      "coding standards"
    ],
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "Domain=Software Engineering \u2192 sub-role dotnet-backend-developer; The JD is for a .NET / SQL Server application support and development role focused on backend business applications, production support, releases, and performance improvements.",
    "sub_role": {
      "confidence": 0.92,
      "display_name": ".NET Backend Developer",
      "reasoning": "The JD explicitly mentions .NET/Web-based technologies and SQL Server, which strongly points to a .NET backend role.",
      "role_id": 83,
      "slug": "dotnet-backend-developer"
    }
  },
  "stage5_updates": {
    "centroid_n_after": 142,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": null,
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 4440,
        "role_display_name": "Backend Developer",
        "role_slug": "backend-engineer",
        "skill_name": "Microsoft Web",
        "status": "pending"
      }
    ],
    "queue_entry_id": null,
    "v3_pipeline_triggered": false,
    "v3_role_slug": null,
    "v3_run_id": 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": 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"
    }
  ],
  "candidate_roles": [
    {
      "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": "Backend Developer",
    "id": 1,
    "rationale": "Domain=Software Engineering \u2192 sub-role dotnet-backend-developer; The JD is for a .NET / SQL Server application support and development role focused on backend business applications, production support, releases, and performance improvements.",
    "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"
  },
  "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_final_skills": [
    "SQL Server",
    "Microsoft Web"
  ],
  "input_llm_skills": [
    "SQL Server",
    "Microsoft Web"
  ],
  "new_aliases_persisted": 0,
  "run_id": "952d9697-c383-4578-b458-aa1f9dc6eab1",
  "skills_detail": [
    {
      "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": [],
      "canonical": null,
      "dimensions": [],
      "input_skill": "Microsoft Web",
      "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": "microsoft-web",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    }
  ],
  "unmatched_skills": [
    "Microsoft Web"
  ]
}
API 3 — final-role-output
{
  "chosen_role": {
    "display_name": "Backend Developer",
    "id": 1,
    "rationale": "Domain=Software Engineering \u2192 sub-role dotnet-backend-developer; The JD is for a .NET / SQL Server application support and development role focused on backend business applications, production support, releases, and performance improvements.",
    "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"
  },
  "chosen_role_resolution": "in_db",
  "final_input_skills": [
    {
      "skill": "SQL Server",
      "tag": "in_db"
    },
    {
      "skill": "Microsoft Web",
      "tag": "new"
    }
  ],
  "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": 1,
        "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": true,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension saved",
        "role_dimension_saved": true,
        "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
      }
    ],
    "new_skills_created": 0,
    "role_dimension_saved": 0,
    "skill_dimension_saved": 0,
    "skipped": 0
  },
  "planner_output": null,
  "run_id": "952d9697-c383-4578-b458-aa1f9dc6eab1"
}

LLM Calls

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

Loading…