Default profile banner
PA

Prem Ankit

@PremKumarAnkit

Associate Consultant at Capgemini

Pune, Maharashtra, India

Capgemini Rungta College Of Engineering and Technology

Azure Cloud Data Engineer with 3+ years of experience designing production-grade lakehouse architectures processing 100M+ records using ADF, Databricks, and Delta Lake. Specialized in building optimized ETL/ELT pipelines on Microsoft Azure. Strong expertise in Azure Data Factory, Databricks (PySpark), Delta Lake, and ADLS Gen2 for batch and incremental data processing. Hands-on experience with full-load and upsert pipelines, Delta MERGE operations, data quality frameworks, logging, monitoring, CI/CD using Azure DevOps, and secure orchestration using Azure Key Vault and Logic Apps. Domain experience in insurance and reinsurance data platforms.

Experience

Associate Consultant

Capgemini

Full-time•Dec 2022 - Present•Pune, Maharashtra, India

Cloud Data Engineer with 3.3 years of experience building scalable ETL/ELT and batch data pipelines on Microsoft Azure. Strong expertise in Azure Data Factory, Databricks (PySpark), SQL, Delta Lake, and ADLS Gen2 for data warehousing and analytics-ready lakehouse architectures. Hands-on experience with full-load and incremental pipelines, Delta MERGE (UPSERT), SCD Type 1/Type 2 patterns, dimensional modeling (fact–dimension tables), data quality frameworks, logging, monitoring, and batch scheduling. Proven experience with CI/CD using Azure DevOps, secure orchestration using Azure Key Vault and Logic Apps, and insurance/reinsurance domain data platforms.

Education

Rungta College Of Engineering and Technology

Bachelors of Engineering

Computer Science Engineering

Aug 2018 - May 2022•Grade: 74%

Licenses & Certifications

Microsoft Azure Fundamentals (AZ-900)

Microsoft

• No expiration

Python

• No expiration

Generative AI Fundamentals

• No expiration

Skills

Azure Data Factory
Azure DataBricks
Python
SQL
Pyspark
ADLS
Delta Lake