Pipeline run

{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "SSIS"
    }
  ],
  "jd_role": {
    "display_name": "SSIS-Developer",
    "rationale": null,
    "role_aliases": [
      "SSIS Developer",
      "Senior SSIS 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": [],
    "experience": {
      "max": 5,
      "min": 3,
      "raw": "3 - 5 YEARS"
    },
    "job_locations": [],
    "role": "SSIS-Developer",
    "role_aliases": [
      "SSIS Developer",
      "Senior SSIS Developer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 0,
        "heading": "Key skills required for the job are",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "n SSIS-L3, (Mandatory) .As",
          "last_5_words": "members in the team."
        },
        "text": "n SSIS-L3, (Mandatory) .As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module. You should have good experience in application of standard software development principles. You should be able to work as an independent team member, capable of applying judgment to plan and execute your tasks. You should have in-depth knowledge of at least one development technology/ programming language. You should be able to respond to technical queries / requests from team members and customers. You should be able to coach, guide and mentor junior members in the team.",
        "word_count": 104
      },
      {
        "bullet_count": 0,
        "heading": "Minimum work experience",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Minimum work experience: 3 -",
          "last_5_words": "members in the team."
        },
        "text": "Minimum work experience: 3 - 5 YEARS \"As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module. You should have good experience in application of standard software development principles. You should be able to work as an independent team member, capable of applying judgment to plan and execute your tasks. You should have in-depth knowledge of at least one development technology/ programming language. You should be able to respond to technical queries / requests from team members and customers. You should be able to coach, guide and mentor junior members in the team.\"",
        "word_count": 156
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "d18dbcdd-7927-4e0b-b16f-07a76dced08c",
  "stage3_signals": {
    "alias_found": true,
    "alias_match_roles": [
      {
        "display_name": "ETL / ELT Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 50,
        "score": 1.0,
        "slug": "etl-elt-developer",
        "total_count": null
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "DevOps Engineer",
        "kra_matches": [
          {
            "kra_text": "Collaborates with development teams to improve build processes, reduce deployment friction, containerize applications, and adopt DevOps best practices.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.4164
          },
          {
            "kra_text": "Collaborates with development teams to improve build processes, reduce deployment friction, containerize applications, and adopt DevOps best practices.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.4164
          },
          {
            "kra_text": "Responds to deployment failures, infrastructure incidents, and environment misconfiguration issues to restore service availability and prevent recurrence.",
            "sentence": "You should be able to respond to technical queries / requests from team members and customers.",
            "similarity": 0.3748
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 10,
        "score": 0.4025,
        "slug": "devops-engineer",
        "total_count": null
      },
      {
        "display_name": "Cybersecurity Engineer",
        "kra_matches": [
          {
            "kra_text": "Defines secure engineering standards, secure coding guidelines, threat intelligence feeds, and compliance requirements for the organization.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.3975
          },
          {
            "kra_text": "Defines secure engineering standards, secure coding guidelines, threat intelligence feeds, and compliance requirements for the organization.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.3975
          },
          {
            "kra_text": "Leads security incident response investigations including forensic analysis, malware triage, containment actions, and post-incident remediation coordination.",
            "sentence": "You should be able to respond to technical queries / requests from team members and customers.",
            "similarity": 0.3947
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 5,
        "score": 0.3966,
        "slug": "cybersecurity-engineer",
        "total_count": null
      },
      {
        "display_name": "Cloud Architect",
        "kra_matches": [
          {
            "kra_text": "Conducts architecture reviews, approves technical design documents, and guides engineering teams through cloud migration and modernization projects.",
            "sentence": "You should be able to respond to technical queries / requests from team members and customers.",
            "similarity": 0.4003
          },
          {
            "kra_text": "Conducts architecture reviews, approves technical design documents, and guides engineering teams through cloud migration and modernization projects.",
            "sentence": "You should be able to respond to technical queries / requests from team members and customers.",
            "similarity": 0.4003
          },
          {
            "kra_text": "Conducts architecture reviews, approves technical design documents, and guides engineering teams through cloud migration and modernization projects.",
            "sentence": "n SSIS-L3, (Mandatory) .As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module.",
            "similarity": 0.3855
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 9,
        "score": 0.3954,
        "slug": "cloud-architect",
        "total_count": null
      },
      {
        "display_name": "Cloud Security Engineer",
        "kra_matches": [
          {
            "kra_text": "Documents cloud security standards, approved architecture patterns, security exceptions, and remediation guidance for engineering teams.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.4047
          },
          {
            "kra_text": "Documents cloud security standards, approved architecture patterns, security exceptions, and remediation guidance for engineering teams.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.4047
          },
          {
            "kra_text": "Supports cloud security incident response including forensic log analysis, containment procedures, and post-incident remediation for cloud-based breaches.",
            "sentence": "You should be able to respond to technical queries / requests from team members and customers.",
            "similarity": 0.345
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 23,
        "score": 0.3848,
        "slug": "cloud-security-engineer",
        "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": "You should have good experience in application of standard software development principles.",
            "similarity": 0.3799
          },
          {
            "kra_text": "Works closely with product managers and UX designers to translate requirements and wireframes into working software features through iterative development.",
            "sentence": "You should have good experience in application of standard software development principles.",
            "similarity": 0.3799
          },
          {
            "kra_text": "Works closely with product managers and UX designers to translate requirements and wireframes into working software features through iterative development.",
            "sentence": "Minimum work experience: 3 - 5 YEARS \"As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module.",
            "similarity": 0.3712
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.377,
        "slug": "full-stack-engineer",
        "total_count": null
      }
    ],
    "skill_match_roles": []
  },
  "stage4_decision": {
    "alias_collision_detected": true,
    "case": "D",
    "chosen_role": {
      "display_name": "ETL / ELT Developer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 50,
      "score": 1.0,
      "slug": "etl-elt-developer",
      "total_count": null
    },
    "confidence": 0.87,
    "is_new_role": false,
    "llm2_fired": true,
    "llm2_reasoning": "The role requires hands-on SSIS development, support and mentoring skills typical of an ETL/ELT Developer rather than a DevOps Engineer.",
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "LLM2 picked etl-elt-developer (confidence 0.87)"
  },
  "stage5_updates": {
    "centroid_n_after": 2,
    "centroid_updated": true,
    "collision_log_id": 111,
    "new_kra_attached": {
      "best_kra_similarity": 0.0,
      "queue_id": 83,
      "r_and_r_preview": "n SSIS-L3, (Mandatory) .As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module. You should have good experience in application ",
      "role_display_name": "ETL / ELT Developer",
      "role_slug": "etl-elt-developer",
      "status": "pending"
    },
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 2580,
        "role_display_name": "ETL / ELT Developer",
        "role_slug": "etl-elt-developer",
        "skill_name": "SSIS",
        "status": "pending"
      }
    ],
    "queue_entry_id": null,
    "v3_pipeline_triggered": false,
    "v3_role_slug": null,
    "v3_run_id": null
  }
}

{
  "alias_matches": [],
  "candidate_roles": [],
  "chosen_role": {
    "display_name": "SSIS-Developer",
    "id": null,
    "rationale": null,
    "role_archetype": "Engineering",
    "slug": "",
    "source": "llm"
  },
  "dimensions": [],
  "input_final_skills": [
    "SSIS"
  ],
  "input_llm_skills": [
    "SSIS"
  ],
  "new_aliases_persisted": 0,
  "run_id": "d18dbcdd-7927-4e0b-b16f-07a76dced08c",
  "skills_detail": [
    {
      "aliases_in_db": [],
      "canonical": null,
      "dimensions": [],
      "input_skill": "SSIS",
      "matched_via": null,
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": {
        "derived": {
          "category": "Data Engineering Tools",
          "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": "ssis",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    }
  ],
  "unmatched_skills": [
    "SSIS"
  ]
}

{
  "chosen_role": {
    "display_name": "SSIS-Developer",
    "id": null,
    "rationale": null,
    "role_archetype": "Engineering",
    "slug": "",
    "source": "llm"
  },
  "chosen_role_resolution": "human_review_required",
  "final_input_skills": [
    {
      "skill": "SSIS",
      "tag": "new"
    }
  ],
  "llm_cost_api1_usd": null,
  "llm_cost_api2_usd": null,
  "llm_cost_api3_usd": null,
  "llm_cost_total_usd": null,
  "persistence": {
    "items": [],
    "new_skills_created": 0,
    "role_dimension_saved": 0,
    "skill_dimension_saved": 0,
    "skipped": 0
  },
  "planner_output": null,
  "run_id": "d18dbcdd-7927-4e0b-b16f-07a76dced08c"
}