Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Roopal Sharma

Delhi

Summary

Results-driven Data Engineer with 6 years of experience designing scalable data pipelines and analytics solutions. Proven expertise in Azure Data Factory (ADF), Azure SQL Data Warehouse (Synapse), Azure Data Lake, Databricks (PySpark/Scala), and T-SQL. Adept at delivering high-quality data ingestion pipelines, performance optimization, and data warehouse development. Demonstrated success in legacy migration, automation, and documenting solutions aligned with data governance standards.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Governance and Management Sr. Analyst

Accenture
Gurugram
08.2024 - 03.2025
  • Designed and delivered data pipelines using Azure Data Factory and Azure SQL Data Warehouse, aligned with backlog items and strategic projects.
  • Developed JSON ingestion workflows with dynamic schema detection using Python, enabling scalable and automated data ingestion into ADLS.
  • Optimized energy data pipelines and transformed datasets for reporting, achieving 30% higher throughput.
  • Authored technical documentation to meet Data Governance and compliance standards.
  • Created Tableau dashboards using curated warehouse views, enhancing business insight into energy KPIs.

Lead Engineer

HCL Tech
Noida
10.2022 - 07.2024
  • Migrated legacy Qlik reports and flat-file data workflows into Tableau and Azure SQL DW, reducing report latency and enhancing visual analytics.
  • Designed automated ingestion pipelines, integrating Dataiku, ADF, and Azure Data Lake, improving batch processing efficiency.
  • Conducted pipeline QA, UAT, and maintained SLA by integrating error handling and auto-alert mechanisms(solved 200+ Tickets).
  • Orchestrated workflows using Power Query and Python scripting, reducing manual effort by 25%.

Associate – Big Data & EDW

Celebal technologies
Gurugram
06.2021 - 09.2022
  • Built scalable ETL pipelines on Azure Data Factory and Azure Databricks (PySpark) for ingestion and transformation across Azure SQL and Data Lake targets.
  • Delivered high-performance Synapse SQL workloads with optimized query performance.
  • Implemented schema validation, automated email alerts, and job retries for fault-tolerant orchestration.
  • Participated in the first-call rotation and proactively improved legacy batch flows with minimal downtime.

Jr. Software Engineer

Datanova India Pvt Ltd
Noida
08.2019 - 04.2021
  • Created custom T-SQL stored procedures, views, and triggers for high-volume transactional data processing.
  • Improved query performance by 40% through indexing and query optimization.
  • Maintained and supported production databases; documented logic for future migr

Education

B.Tech - Computer Science And Engineering

Krishna Engineering College
07-2019

Skills

  • Cloud & Big Data: Azure Data Factory, Azure Databricks, Azure SQL Data Warehouse (Synapse), Azure Data Lake, Azure DevOps, Snowflake
    Programming & Scripting: Python, PySpark, Scala, T-SQL, Power Query
    Pipeline & Automation: ETL/ELT, Data Ingestion, Data Pipeline QA, CI/CD Integration
    BI & Governance: Power BI, Tableau, Dataiku, Azure Purview, Unity Catalog
    Tools: GitHub, DevOps Boards,JIRA, REST API

Certification

  • Microsoft Certified: Azure Data Fundamentals (DP-900)
  • Microsoft Certified: Azure Fundamentals (AZ-900)

Timeline

Data Governance and Management Sr. Analyst

Accenture
08.2024 - 03.2025

Lead Engineer

HCL Tech
10.2022 - 07.2024

Associate – Big Data & EDW

Celebal technologies
06.2021 - 09.2022

Jr. Software Engineer

Datanova India Pvt Ltd
08.2019 - 04.2021

B.Tech - Computer Science And Engineering

Krishna Engineering College

Similar Profiles

CREATE PROFILE
Roopal Sharma