Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
Gourav Kumar

Gourav Kumar

Data Engineer
Noida

Summary

Highly motivated data engineer with a proven track record in designing, implementing, and optimizing data solutions. Possessing expertise in SQL, Python, Spark, and cloud-based data warehousing. Brings a strong background in data modeling, ETL pipelines, and reporting. Passion lies in leveraging data to drive analytics and business insights. Excels at collaborating with cross-functional teams and delivering high-quality solutions in fast-paced environments.

Overview

2
2
years of professional experience
3
3
years of post-secondary education
3
3
Certifications

Work History

Software Engineer I

MAQ Software
Noida
09.2024 - Current
  • Designed and implemented scalable ETL pipelines using SQL, Python, and Spark for efficient data integration
  • Developed robust data models adhering to star schema architecture, optimizing query performance and accessibility
  • Automated the creation of data shortcuts in Fabric Lakehouse, streamlining processes for analytics and reporting
  • Worked with cross-functional teams to deliver analytical reports with Row-Level Security (RLS), ensuring data compliance

Associate Software Engineer

MAQ Software
Noida
09.2023 - 09.2024
  • Built interactive reports in Power BI with advanced DAX calculations for in-depth data visualization and analysis
  • Developed an ingestion framework to automate ETL processes across multiple data sources, including APIs and on-premises systems
  • Optimized data extraction using PySpark, reducing pipeline execution time from 8 hours to 1 hour
  • Ensured data integrity through automated validation checks, including null, grain, and variance checks

Education

Bachelor of Technology - Computer Science

Lovely Professional University (LPU)
Punjab

Indian School Certificate -

Hill Top School
Jamshedpur
06.2018 - 05.2020

Indian Certificate of Secondary Education -

Hill Top School
05.2017 - 06.2018

Skills

  • SQL Proficiency

  • Experienced Python Developer

  • Skilled in Data Processing with PySpark

  • Data Analysis

  • DAX Proficiency

  • AWS Redshift Management

  • Data Integration with Azure Synapse

  • Experience with Databricks

  • Experience with Azure Data Lake Solutions

  • ADF Pipeline Development

  • Data Transformation Workflows

  • Data Structure Design

  • Proficient in OLAP

  • Data Storage Solutions

  • Expertise in Power BI

  • SQL Server Management Studio

  • Azure Logic Apps

  • MySQL Query Optimization

  • Object-Oriented Design

Certification

Microsoft Certified: Fabric Analytics Engineer Associate, 05/01/24, DEF0032918076A9C

Timeline

Software Engineer I

MAQ Software
09.2024 - Current

Associate Software Engineer

MAQ Software
09.2023 - 09.2024

Indian School Certificate -

Hill Top School
06.2018 - 05.2020

Indian Certificate of Secondary Education -

Hill Top School
05.2017 - 06.2018

Bachelor of Technology - Computer Science

Lovely Professional University (LPU)
Gourav KumarData Engineer