Sagnik Kundu

Sagnik Kundu

Snowflake Lead
India
Bengali, Hindi, English

About Me

Snowflake Data Engineer with over 2.5 years of experience designing and optimizing enterprise-grade data pipelines and cloud data warehouse solutions. Strong expertise in Snowflake, scalable ETL development, and SQL perf…

Experience

Lead Data Engineer

Cognizant Technology Solutions
Sep 2023 - Present · 2 years 10 months

Designed and developed 30+ scalable Snowflake-based ETL pipelines on Matillion and DBT to support annuity, actuarial, and operations.
Built end-to-end process flow for enterprise applications including Workday, Salesforce, and ServiceNow to enable seamless data ingestion and data movement of 7M+ records/day within the Snowflake data warehouse.
Implemented AI-driven analytics and Snowflake Cortex AI functions to build advanced data processing solutions.
Delivered 3 fully working multi-agent Snowflake Intelligence ChatBots using Snowflake Cortex Analyst, Search Service, and Cortex AI Agents.
Optimized complex SQL query performance of existing pipelines and load strategies, achieving 98% query runtime optimization while ensuring data accuracy, consistency, and reliability across all pipelines.
Collaborated with data scientists, analysts, and engineers to ensure efficient, timely, and reliable delivery of production data for advanced analytics use cases.
Translated business requirements into robust Snowflake-based technical solutions and ensured data quality, validation, and audit framework.

Lead Data Engineer

Cognizant Technology Solutions - Kolkata, India
Sep 2023 - Present · 2 years 10 months

Designed and developed 30+ scalable Snowflake-based ETL (Extract, Transform, Load) pipelines on Matillion & DBT to support annuity, actuarial, and operations., Built end-to-end process flow for enterprise applications (Workday, Salesforce, ServiceNow) to enable seamless data ingestion and data movement of 7M+ records/day within the Snowflake data warehouse., Implemented AI-driven analytics and Snowflake Cortex AI functions to build advanced data processing solutions., Delivered 3 fully working multi-agent Snowflake Intelligence ChatBots using Snowflake Cortex Analyst, Search Service, and Cortex AI Agents., Optimized complex SQL query performance of existing pipelines and load strategies, achieving 98% query runtime optimization while ensuring data accuracy, consistency, and reliability across all pipelines., Collaborated with data scientists, analysts, and engineers to ensure efficient, timely, and reliable delivery of production data for advanced analytics use cases., Translated business requirements into robust Snowflake-based technical solutions and ensured data quality, validation, and audit framework.

PROJECTS

End-to-End ETL Pipeline Design | Matillion ETL, Snowflake, SQL

Cognizant Technology Solutions · https://github.com/SagnikKundu07/ETL-Data-Pipeline
Duration : 31-Mar-2024 - 29-Sep-2025

Engineered end-to-end ETL pipelines using Matillion to consolidate multi-source operational data into Snowflake, improving data processing efficiency by 40%Designed optimized ingestion and transformation workflows to prepare curated datasets for Snowflake Cortex AI–based analytics and AI use casesImplemented data validation and audit frameworks across 60+ data groups, ensuring data accuracy, consistency, and compliance within enterprise pipelinesAuthored comprehensive pipeline logic, data model, and failure-handling documentation, reducing new-hire onboarding time by 50%Collaborated with the Generative AI team to build a Knowledge Error Database (KEDB), reducing operational effort and saving 30+ man-hours per week

Skills

Python Structured Query Language (SQL) Data Modeling Snowflake Data Warehouse Snowflake Cortex AI Advanced SQL Stakeholder Communication Matillion ETL DBT Snowflake Matillion
Report this Profile?