← Back to history

Pipeline run

795555d5-8b2d-4190-9380-5593e2a4fc78

Pipeline LLM cost (USD)
API 1: $0.0097 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 · Data access and persistence
Build PHP back-end modules and portals around website/app requirements, optimize database access and storage, handle front-end integration requests, and troubleshoot/test code before release.
""Developing Back-End Portals with an Optimized Database.""
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 (3)
PHP Database Testing
Skill cluster (1 dimension groups, role-scoped)
Cross-cutting / unaligned
PHP Database Testing
Show KRA description ↓
Conducting Analysis of Website and Application Requirements. -Writing Back-End Code and Building Efficient PHP Modules. -Developing Back-End Portals with an Optimized Database. -Troubleshooting Application and Code Issues. -Integrating Data Storage Solutions. -Responding To Integration Requests from Front-End Developers. -Finalizing Back-End Features and Testing Web Applications.

Signals

Skill wordpress-dev
0.50
Alias backend-engineer
1.00
KRA python-backend-developer
0.55

Post-classification

Centroidupdated · n=1231
Alias collision log
New-role queue
New skills captured2
New KRA capturedyes

Captured for admin review

Database primary Backend Developer pending
Testing Backend Developer pending
R&R fragment (sim 0.00) Backend Developer pending

Conducting Analysis of Website and Application Requirements. -Writing Back-End Code and Building Efficient PHP Modules. -Developing Back-End Portals with an Optimized Database. -Troubleshooting Applic…

Status: completed Created: 2026-05-27T16:00:55.829277Z Updated: 2026-05-27T16:02:11.765786Z API 3 duration: 8109 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

PHP Backend Developer

sub-role · 0.99 domain · Software Engineering CASE DOMAIN

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

Domain=Software Engineering → sub-role php-backend-developer; The JD is clearly for PHP back-end development, database-backed portals, integrations, troubleshooting, and testing, which best matches Backend Developer.

Matched skills

PHPBack-End CodePHP ModulesOptimized DatabaseData Storage SolutionsIntegrationFront-End DevelopersTesting Web Applications

Matched dimensions

Backend DevelopmentDatabase-Driven Web ApplicationsApplication IntegrationDebugging and TroubleshootingWeb Application Testing

Matched KRAs

Conducting Analysis of Website and Application RequirementsWriting Back-End Code and Building Efficient PHP ModulesDeveloping Back-End Portals with an Optimized DatabaseTroubleshooting Application and Code IssuesIntegrating Data Storage SolutionsResponding To Integration Requests from Front-End DevelopersFinalizing Back-End Features and Testing Web Applications

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

SH Square Consultants MUMBAI || LONDON || PUNE || DELHI || CHENNAI Role Name : PHP Developer Experience : 2-3 Years Qualifications : Any Graduation Job Time : 09:00 AM to 07:00 PM (Monday to Friday) Responsibilities: Conducting Analysis of Website and Application Requirements. -Writing Back-End Code and Building Efficient PHP Modules. -Developing Back-End Portals with an Optimized Database. -Troubleshooting Application and Code Issues. -Integrating Data Storage Solutions. -Responding To Integration Requests from Front-End Developers. -Finalizing Back-End Features and Testing Web Applications.

Skills from this JD

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

PHP Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)
Canonical: PHP id=2986 · php

Aliases — catalog

  • PHP (CANONICAL) primary

Stored enrichment (catalog DB)

Category
Language
Sub-category
Programming Language
Confidence
0.99
Version strategy
NOT_APPLICABLE

Skill profile (library / DB)

Skill nature
LANGUAGE
Volatility
STABLE
Typical lifespan
EVERGREEN
Category id
6
Sub-category id
96
Extractable
True
Also category
False

Dimensions (API 2 worklist)

  • PHP and Magento Extension Points Catalog dimension db id 391

    Library dimension (catalog)

    Roles linked in library: Magento Dev

  • PHP and WordPress Hooks Catalog dimension db id 326

    Library dimension (catalog)

    Roles linked in library: WordPress Dev

  • Programming Languages & Template Languages Catalog dimension db id 359

    Library dimension (catalog)

    Roles linked in library: Drupal Dev

API 3 link attempts (this skill)

Dimension Skill↔dim Role↔dim Outcome
PHP and Magento Extension Points
php-and-magento-extension-points
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP and WordPress Hooks
php-and-wordpress-hooks
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Programming Languages & Template Languages
programming-languages-template-languages
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Database 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
Databases
Sub-category
general
Skill nature
TOOL
Volatility
MEDIUM
Typical lifespan
MULTI_YEAR
Version strategy
UNVERSIONED
Testing Secondary 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
Testing Tools
Sub-category
general
Skill nature
PRACTICE
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
PHP in_db
PHP and Magento Extension Points
php-and-magento-extension-points
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP in_db
PHP and WordPress Hooks
php-and-wordpress-hooks
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP in_db
Programming Languages & Template Languages
programming-languages-template-languages
Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Library artifacts (this run)

Kind Detail DB id
canonical_skill_proposed Database | type=Databases subtype=general nature=TOOL lifespan=MULTI_YEAR
canonical_skill_proposed Testing | type=Testing Tools subtype=general nature=PRACTICE lifespan=MULTI_YEAR
nano JD Parser — gpt-4.1-nano click to toggle
RolePHP Developer
CompanySH Square Consultants
Experience2-3 Years
DomainOther
Location Mumbai, India
JD type pass
Show raw JSON
{
  "JD_type": "pass",
  "about_company": null,
  "certifications": [],
  "company_name": "SH Square Consultants",
  "ctc": null,
  "domain": {
    "primary": {
      "aliases": [],
      "domain": "Other"
    },
    "secondary": null
  },
  "education": [
    {
      "level": "Bachelor\u0027s",
      "qualification": "Any Graduation",
      "raw": "Any Graduation",
      "requirement": "required"
    }
  ],
  "experience": {
    "max": 3,
    "min": 2,
    "raw": "2-3 Years"
  },
  "job_locations": [
    {
      "aliases": [
        "Bombay"
      ],
      "city": "Mumbai",
      "country": "India",
      "state": null,
      "work_mode": null
    },
    {
      "aliases": [],
      "city": "London",
      "country": "United Kingdom",
      "state": null,
      "work_mode": null
    },
    {
      "aliases": [],
      "city": "Pune",
      "country": "India",
      "state": null,
      "work_mode": null
    },
    {
      "aliases": [],
      "city": "Delhi",
      "country": "India",
      "state": null,
      "work_mode": null
    },
    {
      "aliases": [
        "Madras"
      ],
      "city": "Chennai",
      "country": "India",
      "state": null,
      "work_mode": null
    }
  ],
  "role": "PHP Developer",
  "role_aliases": [
    "PHP Engineer",
    "Backend Developer",
    "Software Developer"
  ],
  "role_archetype": "Engineering",
  "roles_and_responsibilities": [
    {
      "bullet_count": 7,
      "heading": "Responsibilities",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "Conducting Analysis of Website and",
        "last_5_words": "and Testing Web Applications."
      },
      "text": "Conducting Analysis of Website and Application Requirements.\n-Writing Back-End Code and Building Efficient PHP Modules.\n-Developing Back-End Portals with an Optimized Database.\n-Troubleshooting Application and Code Issues.\n-Integrating Data Storage Solutions.\n-Responding To Integration Requests from Front-End Developers.\n-Finalizing Back-End Features and Testing Web Applications.",
      "word_count": 45
    }
  ],
  "urls": []
}
API 1 — extract-from-jd click to toggle
{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "PHP"
    },
    {
      "is_primary": true,
      "skill_name": "Database"
    },
    {
      "is_primary": false,
      "skill_name": "Testing"
    }
  ],
  "jd_role": {
    "display_name": "PHP Developer",
    "rationale": null,
    "role_aliases": [
      "PHP Engineer",
      "Backend Developer",
      "Software Developer"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": null,
    "certifications": [],
    "company_name": "SH Square Consultants",
    "ctc": null,
    "domain": {
      "primary": {
        "aliases": [],
        "domain": "Other"
      },
      "secondary": null
    },
    "education": [
      {
        "level": "Bachelor\u0027s",
        "qualification": "Any Graduation",
        "raw": "Any Graduation",
        "requirement": "required"
      }
    ],
    "experience": {
      "max": 3,
      "min": 2,
      "raw": "2-3 Years"
    },
    "job_locations": [
      {
        "aliases": [
          "Bombay"
        ],
        "city": "Mumbai",
        "country": "India",
        "state": null,
        "work_mode": null
      },
      {
        "aliases": [],
        "city": "London",
        "country": "United Kingdom",
        "state": null,
        "work_mode": null
      },
      {
        "aliases": [],
        "city": "Pune",
        "country": "India",
        "state": null,
        "work_mode": null
      },
      {
        "aliases": [],
        "city": "Delhi",
        "country": "India",
        "state": null,
        "work_mode": null
      },
      {
        "aliases": [
          "Madras"
        ],
        "city": "Chennai",
        "country": "India",
        "state": null,
        "work_mode": null
      }
    ],
    "role": "PHP Developer",
    "role_aliases": [
      "PHP Engineer",
      "Backend Developer",
      "Software Developer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 7,
        "heading": "Responsibilities",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Conducting Analysis of Website and",
          "last_5_words": "and Testing Web Applications."
        },
        "text": "Conducting Analysis of Website and Application Requirements.\n-Writing Back-End Code and Building Efficient PHP Modules.\n-Developing Back-End Portals with an Optimized Database.\n-Troubleshooting Application and Code Issues.\n-Integrating Data Storage Solutions.\n-Responding To Integration Requests from Front-End Developers.\n-Finalizing Back-End Features and Testing Web Applications.",
        "word_count": 45
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "795555d5-8b2d-4190-9380-5593e2a4fc78",
  "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": "PHP Backend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 86,
        "score": 1.0,
        "slug": "php-backend-developer",
        "total_count": null
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "Python Backend Developer",
        "kra_matches": [
          {
            "kra_text": "Design backend endpoints and request handling",
            "sentence": "Responding To Integration Requests from Front-End Developers.",
            "similarity": 0.5769
          },
          {
            "kra_text": "Troubleshoot server-side defects",
            "sentence": "Troubleshooting Application and Code Issues.",
            "similarity": 0.5636
          },
          {
            "kra_text": "Write backend-focused automated checks",
            "sentence": "Finalizing Back-End Features and Testing Web Applications.",
            "similarity": 0.5185
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 80,
        "score": 0.553,
        "slug": "python-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Pega Developer",
        "kra_matches": [
          {
            "kra_text": "Requirements analysis and process translation",
            "sentence": "Conducting Analysis of Website and Application Requirements.",
            "similarity": 0.5674
          },
          {
            "kra_text": "external system integration implementation",
            "sentence": "Responding To Integration Requests from Front-End Developers.",
            "similarity": 0.4984
          },
          {
            "kra_text": "defect troubleshooting and resolution",
            "sentence": "Troubleshooting Application and Code Issues.",
            "similarity": 0.4962
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 24,
        "score": 0.5207,
        "slug": "pega-developer",
        "total_count": null
      },
      {
        "display_name": "Fullstack Developer",
        "kra_matches": [
          {
            "kra_text": "Optimizes application performance from database query efficiency through API response latency to frontend rendering speed and bundle size.",
            "sentence": "Developing Back-End Portals with an Optimized Database.",
            "similarity": 0.5255
          },
          {
            "kra_text": "Implements complete product features end-to-end from database schema design through backend API to frontend UI using JavaScript, TypeScript, Python, or Ruby on Rails.",
            "sentence": "Finalizing Back-End Features and Testing Web Applications.",
            "similarity": 0.5002
          },
          {
            "kra_text": "Debugs full-stack issues that span frontend rendering, API behavior, database queries, and infrastructure configuration to identify root causes.",
            "sentence": "Troubleshooting Application and Code Issues.",
            "similarity": 0.5002
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.5086,
        "slug": "full-stack-engineer",
        "total_count": null
      },
      {
        "display_name": "React Frontend Developer",
        "kra_matches": [
          {
            "kra_text": "debug user-facing application issues",
            "sentence": "Troubleshooting Application and Code Issues.",
            "similarity": 0.609
          },
          {
            "kra_text": "translate product and design requirements",
            "sentence": "Conducting Analysis of Website and Application Requirements.",
            "similarity": 0.4589
          },
          {
            "kra_text": "connect UI to backend data and actions",
            "sentence": "Developing Back-End Portals with an Optimized Database.",
            "similarity": 0.4503
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 89,
        "score": 0.5061,
        "slug": "react-frontend-developer",
        "total_count": null
      },
      {
        "display_name": "Drupal Dev",
        "kra_matches": [
          {
            "kra_text": "site troubleshooting and defect fixes",
            "sentence": "Troubleshooting Application and Code Issues.",
            "similarity": 0.5534
          },
          {
            "kra_text": "external system integration",
            "sentence": "Responding To Integration Requests from Front-End Developers.",
            "similarity": 0.4865
          },
          {
            "kra_text": "site troubleshooting and defect fixes",
            "sentence": "Finalizing Back-End Features and Testing Web Applications.",
            "similarity": 0.4537
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 228,
        "score": 0.4979,
        "slug": "drupal-dev",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": "WordPress Dev",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "PHP"
        ],
        "role_id": 227,
        "score": 0.5,
        "slug": "wordpress-dev",
        "total_count": 2
      },
      {
        "display_name": "Drupal Dev",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "PHP"
        ],
        "role_id": 228,
        "score": 0.5,
        "slug": "drupal-dev",
        "total_count": 2
      },
      {
        "display_name": "Magento Dev",
        "kra_matches": null,
        "matched_count": 1,
        "matched_skills": [
          "PHP"
        ],
        "role_id": 231,
        "score": 0.5,
        "slug": "magento-dev",
        "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 Development",
      "Database-Driven Web Applications",
      "Application Integration",
      "Debugging and Troubleshooting",
      "Web Application Testing"
    ],
    "matched_kras": [
      "Conducting Analysis of Website and Application Requirements",
      "Writing Back-End Code and Building Efficient PHP Modules",
      "Developing Back-End Portals with an Optimized Database",
      "Troubleshooting Application and Code Issues",
      "Integrating Data Storage Solutions",
      "Responding To Integration Requests from Front-End Developers",
      "Finalizing Back-End Features and Testing Web Applications"
    ],
    "matched_skills": [
      "PHP",
      "Back-End Code",
      "PHP Modules",
      "Optimized Database",
      "Data Storage Solutions",
      "Integration",
      "Front-End Developers",
      "Testing Web Applications"
    ],
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "Domain=Software Engineering \u2192 sub-role php-backend-developer; The JD is clearly for PHP back-end development, database-backed portals, integrations, troubleshooting, and testing, which best matches Backend Developer.",
    "sub_role": {
      "confidence": 0.99,
      "display_name": "PHP Backend Developer",
      "reasoning": "The JD explicitly names PHP and building back-end modules in PHP, which clearly matches PHP Backend Developer.",
      "role_id": 86,
      "slug": "php-backend-developer"
    }
  },
  "stage5_updates": {
    "centroid_n_after": 1231,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": {
      "best_kra_similarity": 0.0,
      "queue_id": 1293,
      "r_and_r_preview": "Conducting Analysis of Website and Application Requirements.\n-Writing Back-End Code and Building Efficient PHP Modules.\n-Developing Back-End Portals with an Optimized Database.\n-Troubleshooting Applic",
      "role_display_name": "Backend Developer",
      "role_slug": "backend-engineer",
      "status": "pending"
    },
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 17773,
        "role_display_name": "Backend Developer",
        "role_slug": "backend-engineer",
        "skill_name": "Database",
        "status": "pending"
      },
      {
        "is_primary": false,
        "queue_id": 17774,
        "role_display_name": "Backend Developer",
        "role_slug": "backend-engineer",
        "skill_name": "Testing",
        "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": 4444,
      "existing_alias_text": "PHP",
      "input_term": "PHP",
      "matched_canonical": {
        "category_id": 6,
        "display_name": "PHP",
        "id": 2986,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "LANGUAGE",
        "slug": "php",
        "sub_category_id": 96,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    }
  ],
  "candidate_roles": [
    {
      "display_name": "Magento Dev",
      "id": 231,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "magento-dev",
      "source": "db"
    },
    {
      "display_name": "WordPress Dev",
      "id": 227,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "wordpress-dev",
      "source": "db"
    },
    {
      "display_name": "Drupal Dev",
      "id": 228,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "drupal-dev",
      "source": "db"
    }
  ],
  "chosen_role": {
    "display_name": "Backend Developer",
    "id": 1,
    "rationale": "Domain=Software Engineering \u2192 sub-role php-backend-developer; The JD is clearly for PHP back-end development, database-backed portals, integrations, troubleshooting, and testing, which best matches Backend Developer.",
    "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": "PHP and Magento Extension Points",
        "id": 391,
        "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
        "slug": "php-and-magento-extension-points",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Magento Dev",
          "id": 231,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "magento-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "PHP and WordPress Hooks",
        "id": 326,
        "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
        "slug": "php-and-wordpress-hooks",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "WordPress Dev",
          "id": 227,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "wordpress-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Programming Languages \u0026 Template Languages",
        "id": 359,
        "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
        "slug": "programming-languages-template-languages",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Drupal Dev",
          "id": 228,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "drupal-dev",
          "source": "db"
        }
      ]
    }
  ],
  "input_final_skills": [
    "PHP",
    "Database",
    "Testing"
  ],
  "input_llm_skills": [
    "PHP",
    "Database",
    "Testing"
  ],
  "new_aliases_persisted": 0,
  "run_id": "795555d5-8b2d-4190-9380-5593e2a4fc78",
  "skills_detail": [
    {
      "aliases_in_db": [
        {
          "alias_text": "PHP",
          "alias_type": "CANONICAL",
          "id": 4444,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 6,
        "display_name": "PHP",
        "id": 2986,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "LANGUAGE",
        "slug": "php",
        "sub_category_id": 96,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "PHP and Magento Extension Points",
            "id": 391,
            "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
            "slug": "php-and-magento-extension-points",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Magento Dev",
              "id": 231,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "magento-dev",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "PHP and WordPress Hooks",
            "id": 326,
            "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
            "slug": "php-and-wordpress-hooks",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "WordPress Dev",
              "id": 227,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "wordpress-dev",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Programming Languages \u0026 Template Languages",
            "id": 359,
            "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
            "slug": "programming-languages-template-languages",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Drupal Dev",
              "id": 228,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "drupal-dev",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "PHP",
      "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": "Database",
      "matched_via": null,
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": {
        "derived": {
          "category": "Databases",
          "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": "database",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [],
      "canonical": null,
      "dimensions": [],
      "input_skill": "Testing",
      "matched_via": null,
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": {
        "derived": {
          "category": "Testing Tools",
          "skill_nature": "PRACTICE",
          "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": "testing",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    }
  ],
  "unmatched_skills": [
    "Database",
    "Testing"
  ]
}
API 3 — final-role-output
{
  "chosen_role": {
    "display_name": "Backend Developer",
    "id": 1,
    "rationale": "Domain=Software Engineering \u2192 sub-role php-backend-developer; The JD is clearly for PHP back-end development, database-backed portals, integrations, troubleshooting, and testing, which best matches Backend Developer.",
    "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": "PHP",
      "tag": "in_db"
    },
    {
      "skill": "Database",
      "tag": "new"
    },
    {
      "skill": "Testing",
      "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": "PHP and Magento Extension Points",
          "id": 391,
          "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
          "slug": "php-and-magento-extension-points",
          "source": "db"
        },
        "dimension_id": 391,
        "input_skill": "PHP",
        "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": "Magento Dev",
            "id": 231,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "magento-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 1,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "PHP and WordPress Hooks",
          "id": 326,
          "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
          "slug": "php-and-wordpress-hooks",
          "source": "db"
        },
        "dimension_id": 326,
        "input_skill": "PHP",
        "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": "WordPress Dev",
            "id": 227,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "wordpress-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 1,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Programming Languages \u0026 Template Languages",
          "id": 359,
          "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
          "slug": "programming-languages-template-languages",
          "source": "db"
        },
        "dimension_id": 359,
        "input_skill": "PHP",
        "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": "Drupal Dev",
            "id": 228,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "drupal-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "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": "795555d5-8b2d-4190-9380-5593e2a4fc78"
}