Sampath Chunchula

Senior Data Engineer @Solventum

Designed and implemented scalable cloud architectures on AWS using services like EC2, S3, Lambda, Glue, EMR, Redshift, and VPC to optimize data workflows.• Built robust data pipelines between AWS services and tools like Databricks, Snowflake, and Power BI, enabling seamless data flow and analytics.• Migrated legacy systems to AWS Cloud with minimal disruption, ensuring a smooth transition through meticulous planning and testing.• Leveraged Databricks to develop ETL pipelines, data lakes, and real-time processing solutions using Apache Spark, Delta Lake, and automated cluster scaling.• Designed and managed Snowflake environments, focusing on query optimization, auto-scaling, secure data sharing, and data governance.• Created efficient ETL/ELT workflows using Python, Spark, and Snowflake for seamless data movement and transformation.• Utilized PySpark for distributed data processing, applying transformations, optimizing Spark jobs, and managing clusters for performance.• Implemented security best practices such as IAM roles, RBAC, and row-level security in AWS, Snowflake, and Power BI to ensure secure and compliant data access.• Developed Power BI dashboards with advanced data modeling and DAX calculations, integrating AWS S3, Redshift, and Snowflake for actionable insights.• Automated data workflows using Databricks Jobs, AWS Lambda, and Step Functions to ensure reliable and consistent pipeline execution.• Configured and managed Snowflake’s multi-cluster architecture to support high-demand workloads, ensuring performance and scalability.• Designed optimized data models within Snowflake, including star and snowflake schemas, to support efficient querying and reporting.• Deployed containerized data pipelines using Docker and Kubernetes, leveraging scaling capabilities to handle workload fluctuations.