Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
DEBLINA MOHANTA

DEBLINA MOHANTA

Bengaluru

Summary

Detail-oriented data analyst with extensive experience in monitoring data pipelines, troubleshooting system issues, and managing data workflows in cloud environments. Proven track record in optimizing data processes, performing quality assurance, and ensuring data accuracy. Skilled in using SQL Server Management Studio (SSMS), Azure Data Factory (ADF), and Python for data migration and analysis.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Senior Engineer- Cloud & Infra Management

LTIMINDTREE
Bengaluru
03.2023 - 10.2024
  • Developing notebooks using Python, Py Spark, and SQL to read, write, and onboard data from legacy environment to Azure Synapse and execute data flow through ADF.
  • Design, build, and maintain data pipelines using PySpark on Databricks.
  • Utilize PySpark to read, process, and transform large datasets. Implement data cleansing, aggregation, and transformation logic.
  • Actively monitored ADF pipelines and data flow, and checked if the data is up to date.
  • Creating triggers for various products in ADF pipelines and scheduling for both master and staging pipelines.
  • Use PySpark to extract and manipulate data for reporting.
  • Create dashboards and visualizations in Databricks.
  • Worked with the data in the data warehouse using the SSMS Job monitoring tool to ensure that all scheduled jobs run effectively.
  • Onboarding of data from CosmosDB to ADLS Gen 2 during MAP Migration.
  • Preparing scripts in Python to effectively copy data from the legacy environment to the migrated environment (Azure Synapse workspace). Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Validated results and performed quality assurance to assess accuracy of data. By leveraging Databricks and Py Spark, teams can effectively manage large-scale data processing and analytics, driving better decision-making within organizations.

Senior Analyst

Capgemini
03.2021 - 03.2023
  • Identified and resolved problems through root cause analysis and research
  • Queried databases for information needed for report processing
  • Researched and adopted new technologies to add value to existing offerings
  • Preparing daily reports of data warehouse runs and running daily queries to check if all the product runs are upto date and generating mails to the team daily.

Education

B.Tech/B.E. - Computers

Calcutta Institute Of Engineering And Management
01.2020

10th - CISCE(ICSE/ISC), English

01.2014

Skills

  • Data Management: Azure Data Factory (ADF), SQL Server Management Studio (SSMS), Azure Synapse, Cosmos DB, Databricks
  • Programming languages: Python, PySpark, SQL
  • Data analysis: quality assurance, scripting notebook, root cause analysis, reporting
  • Cloud Technologies: Azure Data Lake Storage (ADLS Gen 2), Azure Data Synapse, AAD

Certification

Completion Of Vocational Training

Languages

English, Hindi, Bengali

Timeline

Senior Engineer- Cloud & Infra Management

LTIMINDTREE
03.2023 - 10.2024

Senior Analyst

Capgemini
03.2021 - 03.2023

B.Tech/B.E. - Computers

Calcutta Institute Of Engineering And Management

10th - CISCE(ICSE/ISC), English

Similar Profiles

CREATE PROFILE
DEBLINA MOHANTA