Headline

Senior Data Engineer | Snowflake + dbt | Azure (ADF/Databricks/Synapse) | Data Vault Modelling | Kafka

About

Senior Data Engineer with 7+ years of experience building scalable data platforms and analytics solutions using the modern Azure + Snowflake ecosystem. I specialize in designing end-to-end ETL/ELT pipelines, data modeling, performance optimization, and implementing data governance practices using tools like Azure Data Factory, Databricks (PySpark), Snowflake, dbt, and Fivetran. I have led multiple projects from requirements to production, mentored teams of 10+ engineers, and delivered reliable data products powering BI and decision-making through Power BI/Tableau. Core strengths: • Snowflake + dbt data modeling (incremental models, snapshots, macros, testing) • Azure Data Engineering (ADF, Databricks, Synapse, ADLS) • Performance tuning (SQL/Spark) and scalable design • CI/CD, automation, governance, and collaboration with stakeholders

Location

Noida

Work experience

Senior Data Engineer at Dataction Analytics Private Limited, Jul 2023 - Present · 2 yrs 11 mos, Pune District, Maharashtra, India, Built and maintained scalable data pipelines using Snowflake, dbt, Azure Data Factory (ADF) and Databricks (PySpark) for enterprise analytics. Integrated 10+ data sources using Fivetran/custom ingestion, enabling reliable and automated ELT workflows. Designed dimensional models (facts/dimensions) and curated data marts to support reporting in Power BI/Tableau. Implemented dbt best practices including incremental models, snapshots (SCD2), macros, tests, and documentation for governance. Optimized SQL and pipeline performance, reducing runtimes by 30–40% through partitioning, clustering, and query tuning. Collaborated with business stakeholders to deliver analytics-ready datasets and improve decision-making across teams. Designed and implemented Data Vault 2.0 modeling (Hubs, Links, Satellites) in Snowflake to support scalable, auditable, and historical data warehousing. Built curated Business Vault / Information Marts on top of Data Vault structures using dbt, enabling analytics-ready datasets for Power BI/Tableau.

Senior Software Engineer 2 at MAQ Software, Sep 2022 - Jun 2023 · 10 mos, Noida, Uttar Pradesh, India, Delivered end-to-end data engineering solutions using Azure Data Factory, Databricks (Spark/Scala/Python) and SQL Server. Built ETL pipelines processing TB-scale data for enterprise clients, ensuring data quality, performance, and reliability. Designed data marts and SSAS Tabular models for analytics consumption and reporting. Implemented CI/CD automation and deployment pipelines using Git/Azure DevOps/GitHub Actions, improving release speed and stability. Mentored and led a team of 10+ engineers, handling planning, code reviews, delivery tracking, and stakeholder communication.

Senior Software Engineer 1 at MAQ Software, Sep 2021 - Aug 2022 · 1 yr, Hyderabad, Telangana, India

Software Engineer 2 at MAQ Software, Mar 2020 - Aug 2021 · 1 yr 6 mos, Hyderabad, Telangana, India

Education

Bachelor of Technology, Computer Science and Information Technology, Maharshi Dayanand University

Higher Secondary, Non Medical, Blue Bells Model School