Sagnik Ghosh is a Data Engineer with experience in developing data warehousing solutions, particularly within the Life Sciences vertical. He is proficient in ETL development using Snowflake, handling data loading from AWS S3 into internal tables with SCD 2 implementation. His technical expertise spans Python, Java, and big data frameworks like Databricks, complemented by skills in AWS services and various databases.
Experience
Programmer Analyst
COGNIZANT
Part of a Data Warehousing project in the Life Sciences vertical serving a German-based multinational pharmaceutical company. Involved in ETL development in Snowflake. Responsible for writing stored procedures, UDFs in Snowflake, used for loading data (Parquet/JSON/CSV format) from AWS S3 bucket into Snowflake internal tables with SCD 2 implementation. Responsible for creation of tasks, streams and snowpipes to automate the data pipeline.
Education
Institute of Engineering & Management, Kolkata
B.Tech
Electrical Engineering
Hem Sheela Model School, Durgapur
Senior Secondary (12th)
Licenses & Certifications
Hands-on Essentials – Data Warehouse (Snowflake Certified)
Snowflake
HackerRank SQL Certification
HackerRank
Programming, Data Structures And Algorithms using Python
NPTEL
HackerRank Certification in Problem Solving (Data Structures and Algorithms) using Python
HackerRank