Data Engineer (Sony Music Consumer Analytics)
Sony Music Entertainment
Oct 2019 - Aug 2021 (1 year 11 months)
Designed and delivered a real-time artist portal platform on AWS Private Cloud, ensuring high availability, reliability, and performance for global users.Built high-performance PySpark transformations for large datasets, applying Spark optimization techniques to ensure scalable and efficient data processing.Integrated metadata and media ingestion pipelines from Spotify, Apple, and Deezer, establishing the primary image and metadata source for Sony's global applications.Migrated legacy automation scripts to AWS Managed Airflow, improving scheduling efficiency, reducing processing time by 30%, and lowering operational overhead.Optimized database performance through schema redesign, indexing strategies, and query optimizations, reducing storag