Swapnil Kshirsagar

Consultant

Pune, Maharashtra, India9 yrs 4 mos experience

Key Highlights

Expert in Snowflake ETL processes and data architecture.
Proven track record in healthcare data analytics.
Strong experience in Agile methodologies and technical documentation.

Stackforce AI infers this person is a Data Engineer specializing in Healthcare data solutions with expertise in Snowflake and ETL processes.

Contact

Skills

Core Skills

SnowflakeSql

Other Skills

Snowflake data clean roomAWS S3UnixUC4SnwoflakeJinjaData AnalysisMicrosoft ExcelRetailData ModelingVisioPython (Programming Language)ETL ToolsIICSData Warehousing

About

•Data engineer with 4 year of experience in ETL development of Health Care and Pharma Domain having strong knowledge of snowflake architecture /warehouse , SQL ,Snowpipe ,UNIX ,JIRA and Git-Hub with good understanding of end-to-end data pipeline and basic understanding of AWS and IICS. • Working for Health Care and Phrama client and mainly dealing with analysis and data loading of HCP, HCO , Patient and Pharmaceutical Brand. •Excellent experience in Snowflake Roles,Schemas,Warehouses, databases external stages. •Created file formats,stages and storage integration object into snowflake databases. •Working experience in Agile Jira,sprints and JSql. •Excellent experience in creating/designing technical design documents in Confluence.

Experience

9 yrs 4 mos

Total Experience

Average Tenure

Current Experience

Ey

3 roles

Senior Consultant

Oct 2025 – Present · 8 mos · Pune, Maharashtra, India

Senior Analyst

Promoted

Oct 2024 – Oct 2025 · 1 yr · Pune, Maharashtra, India

As a Senior Analyst specializing in the Retail domain, I have extensive experience in designing and building complex SQL reports within Snowflake, ensuring accurate and actionable insights for business decision-making. My expertise also extends to developing robust Snowflake ETL pipelines, streamlining data ingestion, transformation, and loading processes to support scalable data architectures.

Snowflake data clean roomSQLSnowflake

Analyst

Jul 2023 – Oct 2024 · 1 yr 3 mos · Pune, Maharashtra, India

SnowflakeSQL

Accenture

2 roles

Data Engineer Analyst

Promoted

Jul 2022 – Jul 2023 · 1 yr · Maharashtra, India

>>Ingested Incremental data into Snowflake-
Tech Stack :
●AWS S3
●Snowflake
●Unix
●UC4
●SQL
●Stored Procedure
Designed end to end ETL process by defining Snowflake Stages, file
formats and S3 integration object by use of Copy into ,Snowpipe ,Stored-
Procedure functions/command for leading Healthcare Pharma company .
●Good hands on in creating schema/tables/views, loading data from Snowflake to AWS S3
●Created dependency between multiple interdependent ETL pipelines by
using UC4 as a result data refresh lag and time saved significantly.
●Created Unix shell script in order to archive the files on AWS S3.
●Maintaining 8+ data pipeline up -time 99.8% while ingesting streaming
and transactional data across 4 different primary source using
SQL,S3,Snwoflake and IICS.
●Created Confluence/ Alation documentation for 10+ data pipeline.