Architected a centralized data warehouse integrating passenger data from two airlines, ensuring consistent data schema, efficient storage, and retrieval mechanisms while normalizing data formats across multiple sources Designed and automated the ETL process with optimized SQL queries, reducing runtime and ensuring data integrity during extraction, transformation, and loading operations for large datasets