Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
Generic
Soumyadeep Sarkar

Soumyadeep Sarkar

Hyderabad

Summary

Results-driven data engineer with 3+ years of experience in data analysis, data warehousing, and ETL. Skilled in designing and implementing robust data pipelines to streamline processes and improve data accessibility. Proficient in utilizing cutting-edge tools and technologies to transform raw data into actionable insights, driving informed decision-making and optimizing business performance. Experienced in designing and optimizing data pipelines to ensure seamless data flow. Utilizes advanced SQL and Python skills to create and maintain robust data architectures. Track record of implementing scalable solutions that enhance data integrity and support informed decision-making.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Engineer

Chubb Business Services India
06.2022 - Current
  • Assisted in the design, development, and implementation of ETL processes using Informatica IICS
  • Wrote SQL queries, stored procedures, and functions to retrieve and manipulate data from databases
  • Collaborated with senior developers and stakeholders to gather requirements and understand project objectives
  • Tested and debugged code to ensure accuracy, reliability, and optimal performance
  • Participated in code reviews and provided feedback to improve code quality and maintainability
  • Kept up-to-date with emerging technologies and best practices in data integration and SQL development
  • Provided support and troubleshooting assistance to end-users as needed
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
  • Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
  • Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
  • Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
  • Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
  • Evaluated various tools, technologies, and best practices for potential adoption in the company''s data engineering processes.
  • Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
  • Established robust monitoring processes to detect system anomalies.
  • Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
  • Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
  • Documented and communicated database schemas using accepted notations.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
  • Managed identification, protection and use of data assets.
  • Established and secured enterprise-wide data analytics structures.
  • Planned and installed upgrades of database management system software to enhance database performance.
  • Gathered, defined and refined requirements, led project design and oversaw implementation.
  • Designed data models for complex analysis needs.
  • Developed and delivered business information solutions.
  • Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
  • Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.

Data Engineer Trainee

Chubb Business Services India
09.2021 - 06.2022
  • Trained on Data warehousing concepts, SQL and Informatica Power Center
  • Worked on live projects like Australia Digital 1.0 as a junior developer, also learnt IICS there
  • Documented technical specifications, process flows, and system configurations

Education

B-Tech - Computer Science

Kalinga Institute of Industrial Technology
05.2022

Intermediate -

D.A.V Public School
Bilaspur, C.G
06.2017

Skills

  • IICS
  • Informatica Power Center
  • Data Warehouse
  • MDM
  • ADF
  • Azure synapse
  • Data Bricks
  • SQL server
  • Python
  • JAVA

Accomplishments

    Awarded with Q2 Platinum award for year 2023

Certification

  • AZ-900: Microsoft Azure Fundamentals
  • DP-900: Microsoft Azure Data Fundamentals

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

Intermediate -

D.A.V Public School

B-Tech - Computer Science

Kalinga Institute of Industrial Technology
Soumyadeep Sarkar