← Back to history

Pipeline run

5b76bc31-3165-46c4-95ee-7f4c0f359bea

Pipeline LLM cost (USD)
API 1: $0.0101 API 2: $0.0000 API 3: $0.0000 Total: $0.0101

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 · Performance and production support
Build and maintain .NET apps backed by Microsoft SQL Server, writing clean code, unit tests, and fixes across the SDLC. Day to day they’ll collaborate on feature design, troubleshoot bugs, and improve app performance and responsiveness.
"Work on bug fixing and improving application performance"
Tech stack maturity
Mainstream Modern
Backend development with .NET and unit testing is characteristic of a widely adopted, actively maintained modern enterprise stack rather than legacy or bleeding-edge technology.
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 (3)
.NET Microsoft SQL Server Unit Testing
Skill cluster (1 dimension groups, role-scoped)
Cross-cutting / unaligned
.NET Microsoft SQL Server Unit Testing
Show KRA description ↓
• Develop and maintain software applications using the .NET framework and Microsoft SQL Server • Participate in all phases of the software development life cycle • Collaborate with cross-functional teams to define, design, and ship new features • Write clean, scalable, and maintainable code • Perform unit testing and troubleshooting of applications • Ensure the performance, quality, and responsiveness of applications • Work on bug fixing and improving application performance • Stay up-to-date with new technologies and industry trends

Signals

Skill dotnet-backend-developer
0.33
Alias dotnet-backend-developer
1.00
KRA flutter-developer
0.63

Post-classification

Centroidupdated · n=205
Alias collision log
New-role queue
New skills captured1
New KRA capturedyes

Captured for admin review

Microsoft SQL Server primary Backend Developer pending
R&R fragment (sim 0.00) Backend Developer pending

• Develop and maintain software applications using the .NET framework and Microsoft SQL Server • Participate in all phases of the software development life cycle • Collaborate with cross-functional te…

Status: completed Created: 2026-05-27T13:51:24.041422Z Updated: 2026-05-27T13:52:02.048909Z API 3 duration: 12452 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.99 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 clearly for a .NET backend/application developer working with Microsoft SQL Server, testing, and application maintenance.

Matched skills

.NET frameworkMicrosoft SQL Serversoftware development life cyclecross-functional teamsunit testingtroubleshootingperformancequalityresponsivenessbug fixing

Matched dimensions

Backend Application DevelopmentDatabase-Driven Software DevelopmentSoftware Testing and DebuggingApplication Performance OptimizationCross-Functional Feature Delivery

Matched KRAs

Develop and maintain software applications using the .NET frameworkParticipate in all phases of the software development life cycleCollaborate with cross-functional teams to define, design, and ship new featuresWrite clean, scalable, and maintainable codePerform unit testing and troubleshooting of applicationsEnsure the performance, quality, and responsiveness of applicationsWork on bug fixing and improving application performance

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
1
Skipped

Job description

Skills:
• NET Framework, Microsoft SQL Server, Test Automation, MySQL, Software Development, Agile Development, JavaScript, Computer Science,


Company Overview

CN Solutions is a leading IT services and IT consulting company that works in partnership with clients to provide first-class solutions for their manpower requirements. We have a dedicated team of professionals with expertise in various technologies, including web technologies, databases, software testing, CRM, ERP, data warehousing, middleware, and business analysis. Our range of services includes staffing solutions, leadership hiring, RPO, and general staffing. With a strong focus on SAP hiring, we are pioneers in the industry. CN Solutions has 11-50 employees and is headquartered in Hyderabad. To learn more about us, please visit our website: http://www.cnsolutions.in

Job Overview

We are currently seeking a skilled and enthusiastic Dotnet Developer to join our team. As a Dotnet Developer, you will be responsible for developing and maintaining software applications using the .NET framework and Microsoft SQL Server. The ideal candidate should have 1 to 3 years of experience in software development, with knowledge of test automation, MySQL, and agile development methodologies. This is a full-time position based in Bangalore, Karnataka, India.

Qualifications And Skills

• 1-3 years of experience in software development using the .NET framework
• Proficiency in Microsoft SQL Server and MySQL
• Experience with test automation frameworks
• Strong knowledge of software development principles and agile methodologies
• Good understanding of web technologies, including JavaScript
• Bachelor's degree in Computer Science or a related field


Roles And Responsibilities

• Develop and maintain software applications using the .NET framework and Microsoft SQL Server
• Participate in all phases of the software development life cycle
• Collaborate with cross-functional teams to define, design, and ship new features
• Write clean, scalable, and maintainable code
• Perform unit testing and troubleshooting of applications
• Ensure the performance, quality, and responsiveness of applications
• Work on bug fixing and improving application performance
• Stay up-to-date with new technologies and industry trends

Skills from this JD

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

.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)
Microsoft 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
Skipped — no persistable v3 meta for new skill
skill_not_in_db_v3_proposed
Unit Testing Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)
Canonical: Unit Testing id=517 · unit-testing

Aliases — catalog

  • Unit Testing (CANONICAL)

Context tags (catalog)

JUnit NUnit TDD arrange-act-assert assertions code coverage fixtures mocking pytest regression stubs test cases test doubles test runner xUnit

Stored enrichment (catalog DB)

Category
Methodology
Sub-category
Testing Methodology
Confidence
0.98
Version strategy
NOT_APPLICABLE

Maturity reasoning: Unit testing is a standard hiring requirement across software JDs and appears in mainstream frameworks/docs; GitHub and Stack Overflow usage remain consistently high, with no successor replacing it.

Skill profile (library / DB)

Skill nature
METHODOLOGY
Volatility
STABLE
Typical lifespan
EVERGREEN
Category id
8
Sub-category id
44
Extractable
True
Also category
False

Dimensions (API 2 worklist)

  • React Frontend Development Catalog dimension db id 96

    Library dimension (catalog)

API 3 link attempts (this skill)

Dimension Skill↔dim Role↔dim Outcome
React Frontend Development
d_init_01
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 Notes
.NET in_db
C# and .NET Languages
c-and-net-languages
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Microsoft SQL Server new
Relational Database Design
relational-database-design
Skipped — no persistable v3 meta for new skill skill_not_in_db_v3_proposed
Unit Testing in_db
React Frontend Development
d_init_01
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Library artifacts (this run)

Kind Detail DB id
dimension_skill_link_proposed Microsoft SQL Server ↔ Relational Database Design
role_dimension_link_proposed Backend Developer ↔ Relational Database Design
nano JD Parser — gpt-4.1-nano click to toggle
RoleDotnet Developer
CompanyCN Solutions
Experience1-3 years of experience in software development using the .NET framework
DomainIT Services & Consulting
Location Bangalore, India (onsite)
JD type pass
Show raw JSON
{
  "JD_type": "pass",
  "about_company": {
    "source_marker": {
      "first_5_words": "CN Solutions is a leading",
      "last_5_words": "and is headquartered in Hyderabad."
    },
    "text": "CN Solutions is a leading IT services and IT consulting company that works in partnership with clients to provide first-class solutions for their manpower requirements. We have a dedicated team of professionals with expertise in various technologies, including web technologies, databases, software testing, CRM, ERP, data warehousing, middleware, and business analysis. Our range of services includes staffing solutions, leadership hiring, RPO, and general staffing. With a strong focus on SAP hiring, we are pioneers in the industry. CN Solutions has 11-50 employees and is headquartered in Hyderabad.",
    "word_count": 84
  },
  "certifications": [],
  "company_name": "CN Solutions",
  "ctc": null,
  "domain": {
    "primary": {
      "aliases": [
        "IT Consulting",
        "Technology Services"
      ],
      "domain": "IT Services \u0026 Consulting"
    },
    "secondary": null
  },
  "education": [
    {
      "level": "Bachelor\u0027s",
      "qualification": "BTECH/BE/BSC - Computer Science (or related)",
      "raw": "Bachelor\u0027s degree in Computer Science or a related field",
      "requirement": "required"
    }
  ],
  "experience": {
    "max": 3,
    "min": 1,
    "raw": "1-3 years of experience in software development using the .NET framework"
  },
  "job_locations": [
    {
      "aliases": [
        "Bengaluru"
      ],
      "city": "Bangalore",
      "country": "India",
      "state": "Karnataka",
      "work_mode": "onsite"
    }
  ],
  "role": "Dotnet Developer",
  "role_aliases": [
    ".NET Developer",
    "Software Developer",
    "Dotnet Engineer"
  ],
  "role_archetype": "Engineering",
  "roles_and_responsibilities": [
    {
      "bullet_count": 8,
      "heading": "Roles And Responsibilities",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "\u2022 Develop and maintain software",
        "last_5_words": "new technologies and industry trends"
      },
      "text": "\u2022 Develop and maintain software applications using the .NET framework and Microsoft SQL Server\n\u2022 Participate in all phases of the software development life cycle\n\u2022 Collaborate with cross-functional teams to define, design, and ship new features\n\u2022 Write clean, scalable, and maintainable code\n\u2022 Perform unit testing and troubleshooting of applications\n\u2022 Ensure the performance, quality, and responsiveness of applications\n\u2022 Work on bug fixing and improving application performance\n\u2022 Stay up-to-date with new technologies and industry trends",
      "word_count": 66
    }
  ],
  "urls": [
    {
      "type": "website",
      "url": "http://www.cnsolutions.in"
    }
  ]
}
API 1 — extract-from-jd click to toggle
{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": ".NET"
    },
    {
      "is_primary": true,
      "skill_name": "Microsoft SQL Server"
    },
    {
      "is_primary": true,
      "skill_name": "Unit Testing"
    }
  ],
  "jd_role": {
    "display_name": "Dotnet Developer",
    "rationale": null,
    "role_aliases": [
      ".NET Developer",
      "Software Developer",
      "Dotnet Engineer"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": {
      "source_marker": {
        "first_5_words": "CN Solutions is a leading",
        "last_5_words": "and is headquartered in Hyderabad."
      },
      "text": "CN Solutions is a leading IT services and IT consulting company that works in partnership with clients to provide first-class solutions for their manpower requirements. We have a dedicated team of professionals with expertise in various technologies, including web technologies, databases, software testing, CRM, ERP, data warehousing, middleware, and business analysis. Our range of services includes staffing solutions, leadership hiring, RPO, and general staffing. With a strong focus on SAP hiring, we are pioneers in the industry. CN Solutions has 11-50 employees and is headquartered in Hyderabad.",
      "word_count": 84
    },
    "certifications": [],
    "company_name": "CN Solutions",
    "ctc": null,
    "domain": {
      "primary": {
        "aliases": [
          "IT Consulting",
          "Technology Services"
        ],
        "domain": "IT Services \u0026 Consulting"
      },
      "secondary": null
    },
    "education": [
      {
        "level": "Bachelor\u0027s",
        "qualification": "BTECH/BE/BSC - Computer Science (or related)",
        "raw": "Bachelor\u0027s degree in Computer Science or a related field",
        "requirement": "required"
      }
    ],
    "experience": {
      "max": 3,
      "min": 1,
      "raw": "1-3 years of experience in software development using the .NET framework"
    },
    "job_locations": [
      {
        "aliases": [
          "Bengaluru"
        ],
        "city": "Bangalore",
        "country": "India",
        "state": "Karnataka",
        "work_mode": "onsite"
      }
    ],
    "role": "Dotnet Developer",
    "role_aliases": [
      ".NET Developer",
      "Software Developer",
      "Dotnet Engineer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 8,
        "heading": "Roles And Responsibilities",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "\u2022 Develop and maintain software",
          "last_5_words": "new technologies and industry trends"
        },
        "text": "\u2022 Develop and maintain software applications using the .NET framework and Microsoft SQL Server\n\u2022 Participate in all phases of the software development life cycle\n\u2022 Collaborate with cross-functional teams to define, design, and ship new features\n\u2022 Write clean, scalable, and maintainable code\n\u2022 Perform unit testing and troubleshooting of applications\n\u2022 Ensure the performance, quality, and responsiveness of applications\n\u2022 Work on bug fixing and improving application performance\n\u2022 Stay up-to-date with new technologies and industry trends",
        "word_count": 66
      }
    ],
    "urls": [
      {
        "type": "website",
        "url": "http://www.cnsolutions.in"
      }
    ]
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "5b76bc31-3165-46c4-95ee-7f4c0f359bea",
  "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
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "Flutter Developer",
        "kra_matches": [
          {
            "kra_text": "collaborate with design, product, and backend teams",
            "sentence": "Collaborate with cross-functional teams to define, design, and ship new features",
            "similarity": 0.7428
          },
          {
            "kra_text": "optimize responsiveness and performance",
            "sentence": "Ensure the performance, quality, and responsiveness of applications",
            "similarity": 0.645
          },
          {
            "kra_text": "structure reusable application code",
            "sentence": "Write clean, scalable, and maintainable code",
            "similarity": 0.5116
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 74,
        "score": 0.6331,
        "slug": "flutter-developer",
        "total_count": null
      },
      {
        "display_name": "Angular Frontend Developer",
        "kra_matches": [
          {
            "kra_text": "collaboration with design and QA",
            "sentence": "Collaborate with cross-functional teams to define, design, and ship new features",
            "similarity": 0.5936
          },
          {
            "kra_text": "code review and refactoring",
            "sentence": "Write clean, scalable, and maintainable code",
            "similarity": 0.5816
          },
          {
            "kra_text": "UI responsiveness and performance",
            "sentence": "Ensure the performance, quality, and responsiveness of applications",
            "similarity": 0.5313
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 90,
        "score": 0.5688,
        "slug": "angular-frontend-developer",
        "total_count": null
      },
      {
        "display_name": "React Native Developer",
        "kra_matches": [
          {
            "kra_text": "maintain code quality",
            "sentence": "Write clean, scalable, and maintainable code",
            "similarity": 0.7062
          },
          {
            "kra_text": "maintain code quality",
            "sentence": "Ensure the performance, quality, and responsiveness of applications",
            "similarity": 0.5277
          },
          {
            "kra_text": "maintain code quality",
            "sentence": "Work on bug fixing and improving application performance",
            "similarity": 0.4509
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 73,
        "score": 0.5616,
        "slug": "react-native-developer",
        "total_count": null
      },
      {
        "display_name": "Fullstack Developer",
        "kra_matches": [
          {
            "kra_text": "Works closely with product managers and UX designers to translate requirements and wireframes into working software features through iterative development.",
            "sentence": "Collaborate with cross-functional teams to define, design, and ship new features",
            "similarity": 0.6154
          },
          {
            "kra_text": "Optimizes application performance from database query efficiency through API response latency to frontend rendering speed and bundle size.",
            "sentence": "Ensure the performance, quality, and responsiveness of applications",
            "similarity": 0.5165
          },
          {
            "kra_text": "Debugs full-stack issues that span frontend rendering, API behavior, database queries, and infrastructure configuration to identify root causes.",
            "sentence": "Perform unit testing and troubleshooting of applications",
            "similarity": 0.4778
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.5366,
        "slug": "full-stack-engineer",
        "total_count": null
      },
      {
        "display_name": "Java Backend Developer",
        "kra_matches": [
          {
            "kra_text": "code refactoring and defect fixes",
            "sentence": "Work on bug fixing and improving application performance",
            "similarity": 0.567
          },
          {
            "kra_text": "backend performance tuning",
            "sentence": "Ensure the performance, quality, and responsiveness of applications",
            "similarity": 0.5448
          },
          {
            "kra_text": "code refactoring and defect fixes",
            "sentence": "Write clean, scalable, and maintainable code",
            "similarity": 0.4818
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 79,
        "score": 0.5312,
        "slug": "java-backend-developer",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": ".NET Backend Developer",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          ".NET"
        ],
        "role_id": 83,
        "score": 0.3333,
        "slug": "dotnet-backend-developer",
        "total_count": 3
      }
    ]
  },
  "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",
      "Database-Driven Software Development",
      "Software Testing and Debugging",
      "Application Performance Optimization",
      "Cross-Functional Feature Delivery"
    ],
    "matched_kras": [
      "Develop and maintain software applications using the .NET framework",
      "Participate in all phases of the software development life cycle",
      "Collaborate with cross-functional teams to define, design, and ship new features",
      "Write clean, scalable, and maintainable code",
      "Perform unit testing and troubleshooting of applications",
      "Ensure the performance, quality, and responsiveness of applications",
      "Work on bug fixing and improving application performance"
    ],
    "matched_skills": [
      ".NET framework",
      "Microsoft SQL Server",
      "software development life cycle",
      "cross-functional teams",
      "unit testing",
      "troubleshooting",
      "performance",
      "quality",
      "responsiveness",
      "bug fixing"
    ],
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "Domain=Software Engineering \u2192 sub-role dotnet-backend-developer; The JD is clearly for a .NET backend/application developer working with Microsoft SQL Server, testing, and application maintenance.",
    "sub_role": {
      "confidence": 0.99,
      "display_name": ".NET Backend Developer",
      "reasoning": "The JD explicitly centers on the .NET framework and SQL Server, which clearly maps to the .NET backend specialization.",
      "role_id": 83,
      "slug": "dotnet-backend-developer"
    }
  },
  "stage5_updates": {
    "centroid_n_after": 205,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": {
      "best_kra_similarity": 0.0,
      "queue_id": 246,
      "r_and_r_preview": "\u2022 Develop and maintain software applications using the .NET framework and Microsoft SQL Server\n\u2022 Participate in all phases of the software development life cycle\n\u2022 Collaborate with cross-functional te",
      "role_display_name": "Backend Developer",
      "role_slug": "backend-engineer",
      "status": "pending"
    },
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 5221,
        "role_display_name": "Backend Developer",
        "role_slug": "backend-engineer",
        "skill_name": "Microsoft SQL Server",
        "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": 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"
    },
    {
      "alias_persist_skipped_reason": "TODO: REMOVE AFTER TESTING \u2014 alias DB write disabled",
      "alias_persisted": false,
      "existing_alias_id": 135,
      "existing_alias_text": "SQL Server",
      "input_term": "Microsoft 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": "embedding_alias"
    },
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 865,
      "existing_alias_text": "Unit Testing",
      "input_term": "Unit Testing",
      "matched_canonical": {
        "category_id": 8,
        "display_name": "Unit Testing",
        "id": 517,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "METHODOLOGY",
        "slug": "unit-testing",
        "sub_category_id": 44,
        "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 clearly for a .NET backend/application developer working with Microsoft SQL Server, testing, and application maintenance.",
    "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": "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"
        }
      ]
    },
    {
      "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": "Microsoft 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": "React Frontend Development",
        "id": 96,
        "rationale": "Building interactive web user interfaces with React.js, including component composition, state management, hooks, and rendering patterns. React.js belongs here because it is a core library for client-side UI development in modern web applications.",
        "slug": "d_init_01",
        "source": "db"
      },
      "input_skill": "Unit Testing",
      "llm_role": null,
      "roles_from_db": []
    }
  ],
  "input_final_skills": [
    ".NET",
    "Microsoft SQL Server",
    "Unit Testing"
  ],
  "input_llm_skills": [
    ".NET",
    "Microsoft SQL Server",
    "Unit Testing"
  ],
  "new_aliases_persisted": 0,
  "run_id": "5b76bc31-3165-46c4-95ee-7f4c0f359bea",
  "skills_detail": [
    {
      "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
    },
    {
      "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": "Microsoft 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": "Microsoft SQL Server",
      "matched_via": "embedding_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": "Unit Testing",
          "alias_type": "CANONICAL",
          "id": 865,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 8,
        "display_name": "Unit Testing",
        "id": 517,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "METHODOLOGY",
        "slug": "unit-testing",
        "sub_category_id": 44,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "React Frontend Development",
            "id": 96,
            "rationale": "Building interactive web user interfaces with React.js, including component composition, state management, hooks, and rendering patterns. React.js belongs here because it is a core library for client-side UI development in modern web applications.",
            "slug": "d_init_01",
            "source": "db"
          },
          "input_skill": "Unit Testing",
          "llm_role": null,
          "roles_from_db": []
        }
      ],
      "input_skill": "Unit Testing",
      "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": []
}
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 clearly for a .NET backend/application developer working with Microsoft SQL Server, testing, and application maintenance.",
    "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": ".NET",
      "tag": "in_db"
    },
    {
      "skill": "Microsoft SQL Server",
      "tag": "in_db"
    },
    {
      "skill": "Unit Testing",
      "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": 1,
        "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
      },
      {
        "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": "Microsoft SQL Server",
        "llm_role": null,
        "matched_chosen_role": true,
        "outcome_line": "Skipped \u2014 no persistable v3 meta for new skill",
        "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": false,
        "skill_id": null,
        "skill_tag": "new",
        "skipped_reason": "skill_not_in_db_v3_proposed"
      },
      {
        "chosen_role_id": 1,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "React Frontend Development",
          "id": 96,
          "rationale": "Building interactive web user interfaces with React.js, including component composition, state management, hooks, and rendering patterns. React.js belongs here because it is a core library for client-side UI development in modern web applications.",
          "slug": "d_init_01",
          "source": "db"
        },
        "dimension_id": 96,
        "input_skill": "Unit Testing",
        "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": [],
        "skill_dimension_saved": true,
        "skill_id": 517,
        "skill_tag": "in_db",
        "skipped_reason": null
      }
    ],
    "new_skills_created": 0,
    "role_dimension_saved": 0,
    "skill_dimension_saved": 0,
    "skipped": 1
  },
  "planner_output": null,
  "run_id": "5b76bc31-3165-46c4-95ee-7f4c0f359bea"
}

LLM Calls

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

Loading…