End-to-End E-commerce ETL Pipeline (AWS → Snowflake)
Designed and implemented an end-to-end ETL pipeline for e-commerce data using AWS Glue and Amazon S3, loading curated datasets into Snowflake for analytics and reporting. Included SQL-based transformations and data validation.
AWSS3GlueSnowflakeSQLPython
Repository →
COVID-19 ETL Pipeline (Python → PostgreSQL)
Automated ingestion and cleaning of Mexico COVID-19 data. Loaded to PostgreSQL via Docker; queried with SQL for validation and exploration.
PythonSQLPostgreSQLDocker
Repository →
RDS ↔ QuickSight (Secure VPC)
Deployed a MySQL instance on Amazon RDS, secured via VPC and security groups, and integrated it with QuickSight for building interactive data visualizations. Included detailed documentation of IAM policies and network security design.
AWSRDS (MySQL)QuickSight
Repository →
Aurora + EC2 Connectivity
Built an Amazon Aurora (MySQL-compatible) cluster and connected it securely from EC2. Covered endpoints, security groups, and connectivity validation.
AWSAuroraEC2
Repository →