Patient appointment management ETL pipeline leveraging AWS Kinesis, Glue, EMR, and Lake Formation to ingest, transform, and serve appointment data across raw, curated, and aggregated tiers. Real-time appointment events from patients and pharmacy staff flow through Kinesis Data Streams into Glue ETL for cleansing, then branch to Step Functions for treatment workflows and EMR for batch transformations stored in Lake Formation. Curated data feeds Athena for reporting and QuickSight dashboards, while RDS and DynamoDB serve transactional queries via API Gateway and Lambda. This architecture demonstrates separation of concerns, scalable batch and streaming processing, and governed data lakes essential for HIPAA-compliant healthcare analytics. Fork this diagram on Diagrams.so to customize data retention policies, add encryption layers, or adapt for your clinic's appointment volume and reporting cadence. Consider adding VPC endpoints and private subnets for enhanced security in production deployments.