Summary
Overview
Work History
Education
Skills
Project
Languages
ADDITIONAL INFORMATION
Timeline
Generic

Pramod Prajapati

Pune

Summary

Results-driven Azure Data Engineer with expertise in Azure Data Factory, SQL, and Databricks. Experienced in designing and maintaining scalable data pipelines, optimizing ETL/ELT workflows, and ensuring data quality and integrity. Proficient in utilizing Databricks for big data processing and performing complex SQL queries. Committed to implementing best practices for data governance and security while collaborating with cross-functional teams to deliver high-quality data solutions that enhance operational efficiency and drive business insights.

Overview

5
5
years of professional experience

Work History

Data Engineer

Krios Info solutiuons
Pune
09.2021 - 08.2023

In my role as an Azure Data Engineer, I actively contributed to our team's success by engaging in daily stand-up calls and efficiently executing tasks assigned by the team manager. I played a vital role in maintaining code quality through active participation in code reviews and contributing to project status meetings, ensuring alignment with project goals. My technical skills shine in utilizing Databricks notebooks for extracting and loading data in cloud platforms. Proficiency in creating, monitoring, and maintaining ETL jobs has allowed me to streamline data processes effectively. Moreover, I demonstrated my expertise by implementing orchestration of data pipelines using Azure Data Factory services, enhancing data workflow efficiency. To maintain a robust data infrastructure, I took charge of monitoring and updating configurations for Databricks notebooks, promptly addressing any issues that arose or jobs that failed. My commitment to data integrity extends to monitoring and analyzing logs for failed Data Factory operations daily, ensuring the reliability and quality of our data processes.

IT Support Engineer

Aasaan jobs Pvt. limited.
Mumbai
03.2021 - 09.2021

In my role as an Azure Data Engineer, I monitor and maintain Azure Data Factory, Databricks, Azure SQL, and Data Lakes to ensure optimal performance and reliability. I troubleshoot and resolve data pipeline issues while optimizing data jobs and SQL queries for efficiency. Supporting the development and deployment of new data pipelines, I ensure data security and compliance with industry standards. I automate routine tasks to streamline processes, maintain comprehensive system documentation and reporting, and collaborate with cross-functional teams to address and resolve data-related challenges. My commitment to data integrity and operational excellence drives my contributions to the team.

Trainee Engineer

Varroc Engineering private limited
Pune
06.2018 - 06.2019

As a trainee data engineer, I assist in developing and maintaining data pipelines to facilitate the extraction, transformation, and loading (ETL) of data from various sources. I help write basic SQL queries to retrieve and analyze data, ensuring its quality and accuracy. Under supervision, I support the setup and configuration of data storage solutions in cloud platforms. I monitor data workflows for issues and contribute to troubleshooting efforts. Additionally, I participate in team meetings to learn best practices and document processes, gaining hands-on experience with data engineering tools and methodologies while supporting senior engineers in their tasks.

Education

Mechanical Engineering

Pune University
Pune
06-2017

Skills

    PySpark

    Delta Table

    Big Data

    ETL

    Databricks

    Azure Data Factory

    Azure SQL Database

    Azure Data Lake

    Azure Dataflow

    Azure Key Vault

    SQL

    SQL Databases

    Git

    Agile

Project

Smart Policy Data System: Designed a three-layered data architecture to ingest, clean, and transform data from various sources, optimizing it for PowerBI visualization. Utilized Azure Data Factory and Databricks to manage data flow, ensuring quality and consistency in the Bronze and Silver layers before storing the optimized data as Delta tables in the Gold layer. Integrated PowerBI with the Gold layer for enhanced analytics and reporting, leveraging technologies such as Azure Data Lake Storage, PySpark, and SQL to drive insights.

Languages

Marathi
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2

ADDITIONAL INFORMATION

Name : Pramod Prajapati
Address : C/o Sawant Ajitkumar Balkrishna, sr. No. 122/2 lane no. 4, Near Datta Mandir, Walhekarwadi, Pimpri Chinchwad, 411033.
Date of Birth : 20 January 1993.

Timeline

Data Engineer

Krios Info solutiuons
09.2021 - 08.2023

IT Support Engineer

Aasaan jobs Pvt. limited.
03.2021 - 09.2021

Trainee Engineer

Varroc Engineering private limited
06.2018 - 06.2019

Mechanical Engineering

Pune University
Pramod Prajapati