← Back to history

Pipeline run

ee2275d0-9488-42c1-beb0-c706f5eb9091

Pipeline LLM cost (USD)
API 1: $0.0027 API 2: $0.0001 API 3: $0.0000 Total: $0.0028

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/implementation
Build, support, maintain, and implement a complex SSIS project module, working independently, answering 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 ↓
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."

Signals

Skill
Alias
KRA devops-engineer
0.40

Post-classification

Centroidupdated · n=1
Alias collision log
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

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 …

v3 pipeline · ETL / ELT Developer

pending
0 · charter approved 2026-05-21T23:39:22.002688Z 7.4s
1 · anchor approved 2026-05-21T23:39:30.501427Z 3.2s
2 · dim_gen approved 2026-05-21T23:39:35.498406Z 43.8s
3 · reconciler awaiting_review 2026-05-21T23:40:21.491692Z 105.1s
4 · typing pending
5 · placement pending
6 · containment pending
7 · enrichment pending
8 · catalog_load pending
Status: completed Created: 2026-05-21T23:39:20.894688Z Updated: 2026-05-21T23:39:28.400519Z API 3 duration: 1078 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 EXCEL_NEW

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 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": 134
    }
  ],
  "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 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": 134
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "ee2275d0-9488-42c1-beb0-c706f5eb9091",
  "stage3_signals": {
    "alias_found": false,
    "alias_match_roles": [],
    "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.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": "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": false,
    "case": "EXCEL_NEW",
    "chosen_role": {
      "display_name": "ETL / ELT Developer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 50,
      "score": 0.9,
      "slug": "etl-elt-developer",
      "total_count": null
    },
    "confidence": 0.9,
    "is_new_role": true,
    "llm2_fired": false,
    "llm2_reasoning": null,
    "new_role_display_name": "ETL / ELT Developer",
    "new_role_slug": "etl-elt-developer",
    "queued": false,
    "reasoning": "JD title \u0027SSIS-Developer\u0027 not in catalog; Excel taxonomy matched \u0027ETL / ELT Developer\u0027 (confidence 0.90): The responsibilities outlined in the JD closely align with the skills and tasks typically associated with an ETL / ELT Developer, particularly in the context of SSIS and software development principles."
  },
  "stage5_updates": {
    "centroid_n_after": 1,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": {
      "best_kra_similarity": 0.0,
      "queue_id": 79,
      "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": 2446,
        "role_display_name": "ETL / ELT Developer",
        "role_slug": "etl-elt-developer",
        "skill_name": "SSIS",
        "status": "pending"
      }
    ],
    "queue_entry_id": null,
    "v3_pipeline_triggered": true,
    "v3_role_slug": "etl-elt-developer",
    "v3_run_id": "e7ae9aec-5d34-486a-95ef-4a127a62363d"
  }
}
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": "ee2275d0-9488-42c1-beb0-c706f5eb9091",
  "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": "ee2275d0-9488-42c1-beb0-c706f5eb9091"
}

LLM Calls

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

Loading…