atomic-lld-design

What problem does it solve?

This Skill eliminates inconsistent, error-prone low-level design (LLD) for source tables in the Atomic data layer of the UBCK Medallion architecture, which commonly causes mismatched attributes, failed ETL pipelines, and inconsistent data models across source systems.

Core Features & Use Cases

• Guided LLD Workflow: Step-by-step process for designing compliant LLD files for individual source tables, including attribute mapping, data domain selection, and foreign key standardization.
• Shared Entity Handling: Built-in rules for splitting Involved Party data into standardized shared entities (IP Postal Address, IP Electronic Address, IP Alt Identification) with consistent naming and classification formatting.
• Validation & Consolidation: Automated pre-flight checks, post-validation workflows, and Level 2 entity consolidation support for merging attributes from multiple source systems into unified Atomic entities.
• Use Case: A data modeler designing LLD for the NHNCK source system's PROFESSIONALS table can use this Skill to ensure all attributes are mapped correctly, shared entities are split properly, and all validation checks pass before human review.

Quick Start

Use the atomic-lld-design skill to generate a compliant LLD file for the NHNCK.PROFESSIONALS source table, mapping all source columns to Atomic attributes, handling shared Involved Party entities, and running all required validation checks.