Soumyadeep Sarkar
Hyderabad
Summary
Results-driven Data Engineer with 4+ years of experience in data analysis, data warehousing, and ETL development across cloud and on-prem ecosystems. Skilled in designing, building, and optimizing robust data pipelines to streamline processes and enhance data accessibility.
Proficient in leveraging modern data engineering tools and platforms — including Snowflake, Databricks, Informatica IICS, and SQL Server — to transform raw datasets into actionable insights that power informed business decisions.
Expertise in advanced SQL and Python scripting for automation, data validation, and performance tuning. Proven track record of implementing scalable, high-quality data architectures that ensure data integrity, reliability, and governance across complex enterprise environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
Chubb Business Services India
06.2022 - Current
- Designed and implemented end-to-end ETL pipelines using Informatica IICS, Python, and Snowflake, improving data processing efficiency by 30 %.
- Developed complex SQL/Snowflake queries, stored procedures, and views for transformation and validation.
- Created Databricks notebooks to handle incremental data loads and data reconciliation from multiple sources (CSV, JSON, API).
- Built automated data-quality check layers (Python + SQL) for completeness, accuracy, and consistency prior to data load.
- Deployed ETL artifacts and data objects via CI/CD Pipelines.
- Optimized Snowflake warehouse usage (query profiling, clustering, caching) leading to 20 % compute cost reduction.
Data Engineer Trainee
Chubb Business Services India
09.2021 - 06.2022
- Learned and implemented Data Warehousing, ETL, and SQL concepts using PowerCenter & IICS.
- Assisted in developing ETL mappings and workflows for data integration across on-prem and Azure environments.
- Created technical documentation and process flows to standardize ETL development practices.
- Collaborated with senior developers to tune SQL queries and pipeline logic, achieving 15 % performance gain.
- Automated data validation tasks using Python scripts, reducing manual QA effort by 20 %.
Education
B-Tech - Computer Science
Kalinga Institute of Industrial Technology
Bhubaneshwar05.2022
12th Grade -
D.A.V Public School
Bilaspur, C.G06.2017
10th Grade - Science
Maharishi Vidya Mandir
Bilaspur04.2015
Skills
- Data integration
- NoSQL databases
- Data warehousing
- Scripting languages
- ETL development
- Data pipeline control
- Data migration
- Performance tuning
- SQL and databases
- Data analysis
- Relational databases
- SQL programming
Certification
- SnowPro Core Certified – Snowflake (2025)
- Databricks Certified Data Engineer Associate (2025)
- Microsoft Azure Fundamentals (AZ-900)
- Microsoft Data Fundamentals (DP-900)
Additional Information
- Professional Development & Learning
Ongoing certifications, online courses, or learning platforms (e.g., Coursera, Databricks Academy). - Hackathons / Projects / Contributions
Participation in internal or public hackathons, data challenges, or automation projects.
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Bengali
Bilingual or Proficient (C2)
Timeline
Data Engineer
Chubb Business Services India
06.2022 - Current
Data Engineer Trainee
Chubb Business Services India
09.2021 - 06.2022
12th Grade -
D.A.V Public School
B-Tech - Computer Science
Kalinga Institute of Industrial Technology
10th Grade - Science
Maharishi Vidya Mandir