Hello, I’m

Harpalsinh Vaghela

Data Engineer

I’m a Data Engineer with hands-on experience in building end-to-end data pipelines and Lakehouse architectures using Azure Data Factory, Synapse Analytics, and Databricks. From ingestion to transformation to insights, I specialize in making data work smarter for businesses.

Hire Me
Download Resume
0 +

Years Of Experience

0 +

Data Engineering Projects

0 %

Client Commitment & Delivery

About Me

Innovative Data Engineer with a Strategic Vision

I’m a detail-oriented Data Engineer with expertise in designing scalable data solutions, building robust pipelines, and delivering cloud-based analytics using Azure and Databricks.

  • Data Pipeline Development
  • Azure Synapse & ADF Integration
  • Lakehouse Architecture Design
  • Databricks + Delta Lake Workflows

Email Me

harpalvaghela990@gmail.com

Make A Call

+1 (905) 924-1282

InShot_20220215_161137332-modified

My Resume

Experience

2023 – Present

Azure Data Engineer
TechieCan Solutions, Canada

2022 – 2022

MS Associate System Analyst
Altera Digital Health, India

2021 – 2022

Data Engineer
Thoughtpearls Software, India

2019 – 2021

Data Engineer
P5Infosoft, India
Education
2023 – 2024

Durham College, ON, Canada

AI Analysis, Design & Implementation

2022 – 2023

Durham College, ON, Canada

Data Analytics for Business Decision Making

2015 – 2019

GTU University, India

B.E. in Computer Engineering

Experience
2024 – Present

Data Engineer

Scotiabank, Canada

2022 – 2022

MS Associate System Analyst

Altera Digital Health, India

2021 – 2022

ETL Developer

Thoughtpearls Softwares, India

2019 – 2021

Data Engineer

P5Infosoft, India

My Skills

Programming Languages

  • Python Python
  • PySpark PySpark
  • Java Java
  • Kotlin Kotlin

Databases

  • AzureSQLDB Azure SQL DB
  • MySQL MySQL
  • SQL Server SQL Server
  • PostgreSQL PostgreSQL

Cloud Tools

  • Azure Data Factory Azure Data Factory
  • Azure Synapse Analytics
  • Microsoft Fabric
  • Databricks

Other Tech Skills

  • Git
  • GitHub GitHub
  • BitBucket BitBucket
  • Jira Jira
  • Confluence Confluence
  • VSCode

My Services as an Azure Data Engineer

Skilled in Azure data engineering, cloud-based pipelines, data modeling, and building scalable analytics solutions.

Data Pipeline Development
Designing scalable, automated ETL workflows with Azure Data Factory.
  • Built ingestion and transformation pipelines across multiple sources.
  • Integrated with Azure Synapse and Power BI for end-to-end flow.
  • Enabled dynamic parameterization and CI/CD deployment.
Cloud Integration & Automation
Connecting Azure services and automating orchestration tasks.
  • Worked with Key Vault, ADLS Gen2, and Synapse pipelines.
  • Scheduled jobs and alerts using triggers and event-based flows.
  • Secured credentials and sensitive data via Azure best practices.
Data Modeling & Optimization
Structuring data for performance and analytics readiness.
  • Applied SCD Type 1 and 2 logic in Delta Lake tables.
  • Built star schemas and optimized joins in Synapse SQL Pools.
  • Reduced query runtimes with partitioning and caching in Spark.
Analytics & Reporting Enablement
Delivering business insights through clean, curated datasets.
  • Prepared Gold layer datasets for Power BI dashboards.
  • Visualized loan, transaction, and customer data in interactive reports.
  • Collaborated with analysts to ensure actionable data views.

Explore My Projects

Project 1

Transactions and Loan Data Pipeline

Project 1

Processes transactional and loan data through scalable ADF and Databricks pipelines. Implements SCD logic to enable historical tracking and accurate financial reporting.

Project 2

Data Pipeline for Customer Account Analysis

Project 2

Built a scalable Azure data pipeline using ADF, Dataflows, and SQL DB to process customer account data. Enabled historical tracking with SCD logic and delivered insights via Power BI dashboards.

Project 3

Fabric Data Pipeline

Project 3

Designed an end-to-end Microsoft Fabric pipeline to ingest, transform, and load on-prem data using Data Gateway, Dataflow, and Notebooks. Implemented SCD Type 2 logic and automated success email notifications for reliable and auditable execution.

View More Projects
My Certifications
Microsoft Certified: Fabric Data Engineer Associate
Databricks Certified Data Engineer Associate
Microsoft Certified: Azure Data Fundamentals

Clients Testimonials

I’ve 10+ Clients Feedback

Collecting valuable insights to improve services and enhance user experience

I’m really impressed with the quality of work and professionalism. The projects were delivered on time and exceeded expectations. Communication was clear throughout, and the solutions provided made a real difference in our team’s productivity. Definitely would work with them again!

Riya Sharma

Senior Data Analyst
Let’s Talk

Let’s connect and explore how I can help you turn raw data into impactful insights through scalable pipelines and modern data architecture.

Schedule a Call
© 2025 Copyright All Rights Reserved
Scroll to Top