← Back to history

Pipeline run

9e6d40fa-90e5-4da2-9d35-a087bd9b5b48

Pipeline LLM cost (USD)
API 1: $0.0043 API 2: $0.0001 API 3: $0.0000 Total: $0.0045

Client output enrichment

v2 Skill cluster · Nature of work · AI index · Tech stack maturity · Evidence · KRA description
SPARSE JD sources · ai_index: jd · nature_of_work: jd · tech_stack_maturity: jd
Nature of work · development, support, maintenance and implementation
Build, support, maintain, and implement a complex SSIS project module, working independently, handling technical queries, and mentoring junior team members.
""responsible for development, support, maintenance and implementation of a complex project module""
Tech stack maturity
Mainstream Modern
AI index (0 = no AI use, 5 = totally AI-dependent · v2.1)
0.00 / 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 (1)
SSIS
Skill cluster (1 dimension groups, role-scoped)
Cross-cutting / unaligned
SSIS
Show KRA description ↓
Key skills required for the job are: 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. 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.

Signals

Skill
Alias etl-elt-developer
1.00
KRA devops-engineer
0.40

Post-classification

Centroidupdated · n=5
Alias collision log#128
New-role queue
New skills captured1
New KRA capturedyes

Captured for admin review

SSIS primary ETL / ELT Developer pending
R&R fragment (sim 0.00) ETL / ELT Developer pending

Key skills required for the job are: n SSIS-L3, (Mandatory) .As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module. You should…

Status: completed Created: 2026-05-22T00:36:32.940669Z Updated: 2026-05-22T00:36:38.696888Z API 3 duration: 1108 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

SSIS-Developer

CASE D

slug: — · id: — · source: llm

Resolution: human_review_required — role not in DB; role↔dimension links may be deferred.

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

Job description

Job Title: SSIS-Developer

Key skills required for the job are: 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. 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. "

Skills from this JD

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

SSIS 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
Data Engineering Tools
Sub-category
general
Skill nature
TOOL
Volatility
MEDIUM
Typical lifespan
MULTI_YEAR
Version strategy
UNVERSIONED

Library artifacts (this run)

Kind Detail DB id
canonical_skill_proposed SSIS | type=Data Engineering Tools subtype=general nature=TOOL lifespan=MULTI_YEAR
nano JD Parser — gpt-4.1-nano click to toggle
RoleSSIS-Developer
Experience3 - 5 YEARS
DomainOther
JD type pass
Show raw JSON
{
  "JD_type": "pass",
  "about_company": null,
  "certifications": [],
  "company_name": null,
  "ctc": null,
  "domain": {
    "primary": {
      "aliases": [],
      "domain": "Other"
    },
    "secondary": null
  },
  "education": [],
  "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",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "Key skills required for the",
        "last_5_words": "in the team."
      },
      "text": "Key skills required for the job are: 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": "Responsibilities",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "As a Senior Developer, you",
        "last_5_words": "in the team."
      },
      "text": "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
    }
  ],
  "urls": []
}
API 1 — extract-from-jd click to toggle
{
  "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",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Key skills required for the",
          "last_5_words": "in the team."
        },
        "text": "Key skills required for the job are: 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": "Responsibilities",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "As a Senior Developer, you",
          "last_5_words": "in the team."
        },
        "text": "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
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "9e6d40fa-90e5-4da2-9d35-a087bd9b5b48",
  "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": "Cloud Architect",
        "kra_matches": [
          {
            "kra_text": "Conducts architecture reviews, approves technical design documents, and guides engineering teams through cloud migration and modernization projects.",
            "sentence": "As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module.",
            "similarity": 0.4065
          },
          {
            "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
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 9,
        "score": 0.4024,
        "slug": "cloud-architect",
        "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 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.3448
          }
        ],
        "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": "As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module.",
            "similarity": 0.3912
          },
          {
            "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
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.3837,
        "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.9,
    "is_new_role": false,
    "llm2_fired": true,
    "llm2_reasoning": "The JD\u2019s focus on SSIS-based development, support, maintenance, and mentoring aligns closely with an ETL/ELT Developer role rather than DevOps.",
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "LLM2 picked etl-elt-developer (confidence 0.90)"
  },
  "stage5_updates": {
    "centroid_n_after": 5,
    "centroid_updated": true,
    "collision_log_id": 128,
    "new_kra_attached": {
      "best_kra_similarity": 0.0,
      "queue_id": 94,
      "r_and_r_preview": "Key skills required for the job are: n SSIS-L3, (Mandatory) .As a Senior Developer, you are responsible for development, support, maintenance and implementation of a complex project module. You should",
      "role_display_name": "ETL / ELT Developer",
      "role_slug": "etl-elt-developer",
      "status": "pending"
    },
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 2931,
        "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
  }
}
API 2 — extract-details
{
  "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": "9e6d40fa-90e5-4da2-9d35-a087bd9b5b48",
  "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"
  ]
}
API 3 — final-role-output
{
  "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": "9e6d40fa-90e5-4da2-9d35-a087bd9b5b48"
}

LLM Calls

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

Loading…