Headline

Senior Analyst @ Capgemini | SQL | Python | PySpark | Azure Databricks | Azure Data Factory | Apache Airflow | ETL | Gen AI | 2+ Years Experience

About

Graduated from Meghnad Saha Institute of Technology with a Bachelor of Technology in Information Technology in 2023. Currently a Senior Analyst at Capgemini, contributing to enterprise cloud migration projects by designing, developing, and deploying data interfaces on GCP. Skilled in SQL, PySpark, and Python, with experience in implementing data transformations and quality checks to ensure the reliability of business-critical datasets. At Capgemini, supported a cloud migration from Azure to GCP, leveraging BigQuery, PostgreSQL, and ADF pipelines to streamline data processing workflows. Committed to delivering scalable and accurate cloud-based data solutions while aligning with governance standards. Passionate about leveraging technical expertise to enable impactful business insights through data analytics.

Location

Kolkata

Work experience

Senior Analyst at Capgemini, Jul 2025 - Present · 1 yr, Bengaluru, Karnataka, India · Hybrid, • Worked on an enterprise cloud migration project involving the migration of business-critical datasets from Azure to GCP for analytics and downstream application consumption. • Designed, developed, and deployed 12+ data interfaces in GCP, leveraging SQL transformations in BigQuery and PostgreSQL using CTEs, joins, aggregations, and window functions. • Supported and monitored ADF pipelines for incremental data migration from Azure SQL Database to Google Cloud Storage (GCS) in Parquet format. • Processed and validated data following Medallion Architecture, ensuring data quality and governance standards. • Performed data reconciliation, root cause analysis, and production support activities during migration and UAT phases, achieving 99% data accuracy across migrated datasets. • Monitored and supported Apache Airflow DAGs, troubleshooting pipeline failures and maintaining 98% workflow reliability. • Collaborated with business analysts, QA teams, and stakeholders for requirements gathering, UAT validation, and production deployments.

Analyst/ Software Engineer at Capgemini, Dec 2023 - Jul 2025 · 1 yr 8 mos, Bengaluru, Karnataka, India · Hybrid, • Extracted and processed data from 10+ SQL Server tables using JDBC connectivity in Databricks, supporting downstream analytics and business reporting. • Developed and maintained PySpark-based ETL pipelines to ingest, transform, and export data from relational databases, processing datasets of up to several million records per batch. • Generated and optimized Parquet files in ADLS Gen2, improving storage efficiency and query performance for analytical workloads. • Implemented data transformation logic, schema validation, and data quality checks, ensuring high data accuracy and consistency across pipeline executions. • Managed batch processing workflows and partitioned datasets, reducing data processing time by approximately 25%. • Monitored and supported Databricks jobs and workflow executions, troubleshooting failures and resolving pipeline issues. • Collaborated with business and technical stakeholders to gather requirements, validate data outputs, and support production deployments. • Utilized SQL, PySpark, Databricks, and Azure cloud services to build and maintain enterprise data pipelines.

Education

Bachelor of Technology - BTech, Information Technology, Meghnad Saha Institute Of Technology(MSIT)

12th, pcm, K.T.P.P. High School