{
  "id": "lib-agent:travel--python-etl-engineer",
  "_kind": "LibraryAgent",
  "_file": "generated-library/agents.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "python-etl-engineer",
    "description": "Writes and executes idempotent Python 3 + stdlib sqlite3 ETL scripts that create the travel database and load every data source into it, then reconciles ingested row counts against scope expectations.",
    "libraryPath": "library/specializations/domains/business/travel/agents/python-etl-engineer/AGENT.md",
    "specialization": "travel",
    "role": "Python ETL Engineer",
    "expertise": [
      "Python 3 standard library (sqlite3, csv, json, urllib.request, pathlib, argparse, hashlib)",
      "Streaming ingestion with batched executemany()",
      "Idempotent rebuild vs reuse semantics",
      "PRAGMA foreign_key_check and integrity_check",
      "Row-level failure diagnostics"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "skill-area:etl-pipelines",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "skill-area:travel-itinerary-planning",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "skill-area:data-quality",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "domain:travel",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "role:data-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "role:analytics-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "role:data-analyst",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "workflow:customer-journey-optimization",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:travel--python-etl-engineer",
      "to": "specialization:travel",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 0.9
      }
    }
  ],
  "incomingEdges": [
    {
      "from": "lib-process:shared--local-db-build",
      "to": "lib-agent:travel--python-etl-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:travel--flight-dataset-build",
      "to": "lib-agent:travel--python-etl-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ]
}