Kit de arquitecto de soluciones de datos
Plataformas de datos duraderas: arquitectura lakehouse, MDM, BI y capa semántica, streaming, contratos de datos, bases de datos, migración y conciliación de datos, residencia y privacidad.
Planteamiento
Data Platform Architecture Template (Lakehouse, Medallion, Lineage)
CompletaConsumers and SLOs, ingestion patterns, medallion layers, Iceberg/Delta/Hudi choice, semantic layer, OpenLineage, quality, access, cost
DAMA-DMBOK2 Revised (2024) knowledge areas; Apache Iceberg table spec v3; Delta Lake protocol; OpenLineageData Requirements Specification Template
EstándarEntities, data dictionary, quality targets, retention, privacy basis, lineage, data interfaces, migration, ERD
Diseño
Master Data Management Design Template (MDM Hub, Match and Merge)
CompletaMDM styles (registry, consolidation, coexistence, centralised), golden record, CRUD matrix, match/merge sizing, survivorship, stewardship, KPIs
DAMA-DMBOK2 Revised (2024), Reference and Master Data knowledge areaAnalytics and BI Solution Design Template (Dimensional Model, Semantic Layer)
CompletaDecisions, KPI catalogue, bus matrix, facts and dimensions, SCD types, semantic layer, refresh, row-level security, capacity, testing, adoption
Kimball dimensional modelling concepts (structure only); DAMA-DMBOK2 Revised (2024) Data Warehousing and BIStreaming Solution Design Template (Kafka, Flink, AsyncAPI)
CompletaLatency SLOs, delivery guarantees, CDC sources, AsyncAPI 3.1.0 contracts, topics, watermarks, windows, state, exactly-once, capacity, lag
AsyncAPI 3.1.0; CloudEvents 1.0.2; Apache Kafka 4.x and Apache Flink 2.x conceptsData Contract Template (ODCS)
EstándarProducer-consumer data contract: owner, schema, quality rules, SLAs, access, breaking-change policy, YAML skeleton
Open Data Contract Standard (ODCS), Bitol projectDatabase Design Document Template (ERD and Physical Model)
CompletaDatabase design: DBMS choice, conceptual, logical and physical models, indexes, partitioning, integrity, security, backup, capacity
Migración
Data Migration Strategy Template (Mapping, Mock Loads, Reconciliation)
CompletaObject inventory, profiling, cleansing, mapping, big bang vs phased vs trickle, load sequence, mock loads, reconciliation design, cutover steps, fallback
DAMA-DMBOK2 Revised (2024) knowledge areas; SAP Activate and Dynamics 365 migration stagesData Migration Reconciliation Report Template
CompletaLoad identification, record count balance, control totals, field sampling, rejected records, defects, tolerance assessment, business validation, trend, sign-off
DAMA-DMBOK2 Revised (2024) data quality knowledge area
Revisión y gobernanza
Data Residency and Sovereignty Assessment Template (GDPR Chapter V)
CompletaData tiers, flow map, jurisdiction matrix, Chapter V mechanisms, TIAs, PIPL and DPDP examples, Data Act Art. 32, key custody, sovereign cloud scoring, decision
GDPR Chapter V; SCCs 2021/914; EU-US DPF 2023/1795; EDPB Recommendations 01/2020 v2.0; Data Act Art. 32Data Protection Impact Assessment (DPIA) Template
EstándarData protection impact assessment
GDPR Record of Processing Activities (ROPA) Template
EstándarRecord of Processing Activities – all required fields
GDPR Art.30