Hi, I’m
Aayush Peshin
Data Engineer
Gurugram
Summary
Over 2+ years of experience in Data Engineering , ETL processes , and Business Intelligence , with expertise in tools like Azure Synapse , Power BI , and Microsoft SQL Server . Hands-on experience in designing and automating data pipelines using Azure Data Factory and processing large-scale data with PySpark and Hive . Skilled in writing complex SQL queries , optimizing PySpark code , and delivering actionable insights through Power BI dashboards . Proven ability to collaborate with stakeholders to gather requirements, deliver tailored solutions, and manage databases effectively using Microsoft SQL Server . Strong proficiency in ETL pipeline design , data transformation , and performance optimization, ensuring alignment with business needs. Experienced in Unix scripting , performance monitoring , and troubleshooting PySpark jobs to ensure seamless operations.
Overview
3
years of professional experience
2021
years of post-secondary education
8
Certifications
3
Languages
Work History
Capgemini
Data Engineer, Business Intelligence Project
01.2024 - Current
Job overview
- Leveraged Azure Data Factory to automate ETL pipelines , enabling efficient data extraction, transformation, and loading processes
- Utilized Azure Synapse and PySpark to process large-scale datasets and perform advanced analytics, reducing processing time by 30%
- Built and deployed Power BI dashboards to present actionable insights to stakeholders, improving decision-making processes
- Engaged in stakeholder discussions to translate business requirements into technical PySpark code , ensuring accurate data transformations
- Conducted database management and executed complex SQL queries for reporting purposes, ensuring data accuracy and integrity
- Monitored and optimized PySpark job performance , resolving bottlenecks and improving execution efficiency
- Tools & Technologies : Azure Data Factory, Azure Synapse, PySpark, Power BI, Microsoft SQL Server
CPERM
SQL Developer
01.2023 - 11.2024
Job overview
- Executed stored procedures on SQL Server for quality checks and data processing, ensuring data consistency and accuracy
- Designed dashboards in Power BI for better insights and visualization of sample data for clients
- Created complex SQL queries to analyze changes between current and previous data samples, enabling trend analysis and reporting
- Managed tasks in Azure DevOps , ensuring seamless project collaboration and timely delivery of deliverables
- Automated ETL workflows using Azure Data Factory , streamlining data integration processes and improving operational efficiency
- Tools & Technologies : Microsoft SQL Server, Azure Synapse, Power BI, Azure Data Factory, Azure DevOps
R&ET, EUC
Automation Test Engineer
05.2022 - 12.2022
Job overview
- Developed and optimized automation scripts using Eggplant Functional and Eggplant DAI , improving test execution times by 25%
- Designed AI-based models with actions and snippets for web, desktop, and mainframe applications, ensuring comprehensive test coverage
- Performed maintenance of automation scripts, analyzing and fixing failed executions to improve script reliability
- Trained new team members on Eggplant tools , fostering team expertise and enhancing productivity
- Tools & Technologies : Eggplant Functional, Eggplant DAI, GitHub, Jira
Education
JSPM NTC CampusPune, Maharashtra
Bachelor of Engineering from Mechanical
Skills
Apache Spark
undefinedCertification
Eggplant Functional Level 1 – Expert
Key Skills
Apache Spark, PySpark, Hive, Azure Synapse, Python, SQL, PL/SQL, Unix Shell Scripting, Azure Data Factory, Power BI, Microsoft SQL Server, Eggplant Functional, Eggplant DAI, Selenium, ETL Pipeline Design, Data Warehousing Concepts, Complex SQL Query Writing, Data Transformation, Report Generation, Performance Monitoring and Troubleshooting of PySpark Jobs, Stakeholder Collaboration and Requirements Analysis
Timeline
Data Engineer, Business Intelligence Project
Capgemini
01.2024 - Current
SQL Developer
CPERM
01.2023 - 11.2024
Automation Test Engineer
R&ET, EUC
05.2022 - 12.2022
JSPM NTC Campus
Bachelor of Engineering from Mechanical
01.2021
Similar Profiles
Mohammed Rabic RiyazudeenMohammed Rabic Riyazudeen
Senior Applications Consultant at CapgeminiSenior Applications Consultant at Capgemini
V S S R K RAJU KATARIV S S R K RAJU KATARI
Senior Analyst at CapgeminiSenior Analyst at Capgemini
Thierry MaurelThierry Maurel
Engagement Manager at CAPGEMINIEngagement Manager at CAPGEMINI
Priyanka SutarPriyanka Sutar
SAP Analyst at CapgeminiSAP Analyst at Capgemini
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture