Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Receptionist
Sohan Sinha

Sohan Sinha

Kolkata,WB

Summary

Data Engineer with 3 years of experience delivering enterprise-grade data solutions on Azure for global clients like Boehringer Ingelheim and Volkswagen. Engineered scalable pipelines that boosted operational efficiency by 30% and achieved 99.8% SLA compliance. Skilled in ADF, ADLS, Databricks, T-SQL and Power BI. Known for driving cross-functional collaboration, optimizing complex workflows, and deploying secure, high-performance systems aligned with business goals. Recognized with team excellence awards and certified in AZ-900 and DP-700.

Overview

3
3
years of professional experience
3
3
Certification

Work History

Senior Analyst (Data Engineer)

Capgemini Technologies
Mumbai, MH
09.2022 - Current
  • Developed scalable ETL pipelines using Azure Data Factory capable of processing high volumes of production data.
  • Implemented optimization techniques that improved business efficiency by 30%.
  • Established data governance and management techniques, enhancing data quality and compliance.
  • Developed parameterized and dynamic pipelines to handle various ingestion formats (CSV, JSON, and Parquet).
  • Implemented robust logging, error handling, and alerting mechanisms.
  • Integrated ADF with cloud storage and on-premises storage.
  • Collaborated with cross-functional teams to design data ingestion strategies from various on-premises and cloud-based systems.
  • Ensured timely deployment aligned with project milestones and business goals.
  • Monitored and debugged workflow failures, improving data pipeline reliability.
  • Achieved 99.8% SLA compliance across all production data pipelines by implementing proactive monitoring and error handling.
  • Designed and orchestrated Mapping Data Flows with activities.
  • Automated incremental data loads by scheduling Azure Data Factory pipelines for daily and monthly processing reducing manual effort by 90%.
  • Developed Azure Data Lake Storage (ADLS) solutions, ensuring secure and scalable data storage.
  • Applied the medallion architecture to optimize data organization and processing.
  • Scheduled Databricks notebooks with ADF activities.
  • Adept in leveraging CI/CD practices and Azure DevOps to ensure robust and repeatable data deployment processes.

Education

B.Tech - CSE

CGCTC Jhanjeri

Skills

  • SQL
  • Data Warehousing
  • Data Modeling
  • ETL/ELT
  • Python
  • Pyspark
  • Databricks
  • ServiceNow
  • SQL Server Management Studio
  • Azure SQL Database
  • Azure Data Lake Storage (ADLS)
  • Azure Key Vault
  • Azure Data Factory (ADF)
  • Power BI

Websites

Certification

  • MICROSOFT CERTIFIED: FABRIC DATA ENGINEER ASSOCIATE-Link
  • MICROSOFT CERTIFIED: AZURE FUNDAMENTALS-Link
  • Jr DATA ENGINEER CERTIFIED LEVEL- 2(PRACTITIONER) FROM OCEAN (CAPGEMINI-INTERNAL)
  • Jr DATA ENGINEER CERTIFIED LEVEL- 1 FROM OCEAN (CAPGEMINI-INTERNAL)

Personal Information

Title: Data Engineer

Timeline

Senior Analyst (Data Engineer)

Capgemini Technologies
09.2022 - Current

B.Tech - CSE

CGCTC Jhanjeri
Sohan Sinha