Mangal Singh

About Mangal Singh

Data Engineer with a proven track record in architecting and delivering enterprise-scale data warehousing solutions on the Microsoft Azure platform. Expert in Azure Synapse, Azure Data Factory, Azure Databricks, Azure Functions, and SQL Server Management Studio, with a deep understanding of cloud-based data engineering best practices.Specialized in leading the design and implementation of end-to-end ETL processes, including the extraction of raw data from multiple sources, advanced transformation leveraging dataflows and Databricks, and seamless data loading into business-critical systems via automated pipelines. Experienced in building and optimizing dataflows and pipelines to ensure data reliability, scalability, and security.A strategic partner to business stakeholders, I translate complex data requirements into actionable solutions that drive operational efficiency, enable advanced analytics, and support data-driven decision-making. Passionate about mentoring teams, fostering collaboration, and delivering innovative data architectures that empower organizations to achieve their digital transformation goals.

Experience

1. Senior Data Engineer

   Gartner

   Feb 2022 — Present · Gurugram, IN

   Collaborated closely with business stakeholders to analyze data requirements, ensuring Azure-based solutions aligned with organizational goals and delivered actionable insights for decision-making.Assessed the current production environment with stakeholders to understand business processes, proactively identifying potential impacts and risks of new implementations.Delivered real-time data solutions using Azure Data Factory and AWS Data Migration Services, empowering stakeholders with up-to-date information for operational and strategic decisions.Led Proof of Concept (POC) initiatives with stakeholders for migrating the data warehouse to Microsoft Fabric, providing clear recommendations based on performance, scalability, and cost analyses.Designed and implemented ETL processes using Azure Data Factory, T-SQL, Azure Data Lake Analytics, Azure Synapse, and Databricks, ensuring data integrity and reliability for business reporting and analytics.Established robust error logging and automatic pipeline recovery, minimizing downtime and ensuring stakeholders had continuous access to critical business data.Developed reusable components for Slowly Changing Dimensions, Fact loads, and Flat file ingestion, streamlining data operations and accelerating time-to-value for business initiatives.

Education

• Maharaja Surajmal Institute Of Technology

  BTech - Bachelor of Technology

  2015 — 2018