--- title: "Mehul Kansal (@mehulkansal) | Hashnode" description: "Data Engineer. Read the latest articles by Mehul Kansal on Hashnode." url: "https://hashnode.com/@mehulkansal" --- @mehulkansal # Mehul Kansal @mehulkansal 路 Joined May 2024 Data Engineer ### [25: Netflix Data Pipeline with dbt and Snowflake 馃幀](https://mehulkansal.hashnode.dev/25-netflix-data-pipeline-with-dbt-and-snowflake?utm_source=hashnode&utm_medium=feed) Hey Data Engineers! 馃憢 In this project, we build an end-to-end data pipeline using dbt (Data Build Tool) and Snowflake, simulating a Netflix-style dataset. Starting from raw data in Amazon S3, we load it into Snowflake, apply transformations using db... 7 min read 路 [mehulkansal.hashnode.dev](https://mehulkansal.hashnode.dev/25-netflix-data-pipeline-with-dbt-and-snowflake?utm_source=hashnode&utm_medium=feed) [Sep 2, 2025](https://hashnode.com/posts/25-netflix-data-pipeline-with-dbt-and-snowflake/68b6852b5187f7996062d327) ### [24: AWS Glue Building Blocks 馃П](https://mehulkansal.hashnode.dev/24-aws-glue-building-blocks?utm_source=hashnode&utm_medium=feed) Hey fellow learners! 馃憢 This blog demonstrates how to work with AWS Glue through practical, real-world use cases. From setting up crawlers and managing schema changes to building ETL pipelines with transformations and handling sensitive data, each se... 7 min read 路 [mehulkansal.hashnode.dev](https://mehulkansal.hashnode.dev/24-aws-glue-building-blocks?utm_source=hashnode&utm_medium=feed) [May 31, 2025](https://hashnode.com/posts/24-aws-glue-building-blocks/683b7753964e17c2fd6ae2e4) ### [23: Amazon EMR and EMR Serverless Guide 馃摌](https://mehulkansal.hashnode.dev/23-amazon-emr-and-emr-serverless-guide?utm_source=hashnode&utm_medium=feed) Hey readers! 馃憢 In this blog, I walk through my hands-on journey with Amazon EMR鈥攕tarting from creating a traditional EMR cluster to leveraging the flexibility of EMR Serverless for both batch and interactive workloads. From provisioning resources an... 6 min read 路 [mehulkansal.hashnode.dev](https://mehulkansal.hashnode.dev/23-amazon-emr-and-emr-serverless-guide?utm_source=hashnode&utm_medium=feed) [May 24, 2025](https://hashnode.com/posts/23-amazon-emr-and-emr-serverless-guide/68323cd1b0c8e3c1172446c7) ### [22: AWS Athena Setup and Optimization 馃搳](https://mehulkansal.hashnode.dev/22-aws-athena-setup-and-optimization?utm_source=hashnode&utm_medium=feed) Hi Data Folks! 馃憢 In this blog, we鈥檒l walk through setting up AWS Athena for querying data in S3, defining table structures using both manual metadata and Glue Crawlers, and optimizing query performance with techniques like partitioning and columnar ... 6 min read 路 [mehulkansal.hashnode.dev](https://mehulkansal.hashnode.dev/22-aws-athena-setup-and-optimization?utm_source=hashnode&utm_medium=feed) [May 11, 2025](https://hashnode.com/posts/22-aws-athena-setup-and-optimization/6820fb594843871363db5d04) ### [21: Real-Time Data Streaming with Apache Kafka 馃摗](https://mehulkansal.hashnode.dev/21-real-time-data-streaming-with-apache-kafka?utm_source=hashnode&utm_medium=feed) Hey data folks! 馃憢 Apache Kafka offers a robust ecosystem for handling high-speed data streams and is widely used in various industries for applications such as event-driven architectures, real-time analytics, and data integration. In this blog, we w... 4 min read 路 [mehulkansal.hashnode.dev](https://mehulkansal.hashnode.dev/21-real-time-data-streaming-with-apache-kafka?utm_source=hashnode&utm_medium=feed) [Jan 27, 2025](https://hashnode.com/posts/21-real-time-data-streaming-with-apache-kafka/67972f2e66c3771c7aabdf1d)