Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nupur Dhall

Bengaluru

Summary

Accomplished Data Engineer with 10+ years of experience in designing, developing, and optimizing scalable data infrastructure and systems. Expertise in database management, ETL processes, and modern cloud technologies (AWS, Snowflake, Databricks, Azure, DataLake). Skilled in building data models, designing efficient pipelines, and developing reports aligned with business requirements. Adept at implementing data strategies and leading cross-functional teams to deliver high-performance, data-driven solutions. Seeking to contribute technical expertise and leadership as a Senior Data Engineer in a product-based company, focusing on building robust, scalable, and cost-efficient data pipelines, architectures, and platforms.

Overview

10
10
years of professional experience

Work History

Senior Manager - Data Engineering

Genpact
Bengaluru
02.2025 - Current
  • Led end-to-end delivery of cloud-based data engineering projects for BFSI and retail sectors.
  • Managed a team while coordinating with cross-functional stakeholders in agile environments.
  • Executed KetteQ implementation project across multiple regions for Johnson.
  • Extracted large-scale datasets from AWS S3 buckets, ensuring secure, accurate retrieval.
  • Performed data cleaning and applied transformation rules to prepare source files for integration.
  • Implemented end-to-end data pipeline automation using MAGE as an integration tool, orchestrating workflow steps through Python scripts.
  • Authored SQL scripts to clean and transform raw datasets for precise analytics and reporting.
  • Streamlined and monitored complex business process steps, reducing manual intervention, and improving overall pipeline reliability.

Project Leader - Data Engineering

R Systems pvt. ltd
Bengaluru
06.2022 - 02.2025
  • Led data engineering initiatives aligned with business goals, developing scalable systems for data processing and management.
  • Designed and optimized ETL pipelines using Talend and Python, ensuring seamless data transitions and transformations between SQL Server and Postgres.
  • Collaborated with cross-functional teams to enhance cloud data infrastructure, improving data availability, scalability, and processing efficiency.
  • Drove the migration of ETL jobs from Windows to Linux, optimizing performance by 15% and improving system integration.
  • Championed the implementation of data governance and quality testing, ensuring compliance with best practices and improving data consistency across systems.
  • Spearheaded the design and implementation of data roadmaps, ensuring alignment with cutting-edge industry trends and technologies.

Senior Data Engineer

TCS
Gurugram
09.2019 - 06.2022
  • Designed and implemented scalable data models for enterprise data warehouses, ensuring consistent and reliable data availability, supporting multiple high-availability production environments.
  • Optimized database performance by leading the administration of 50+ SQL Server instances, achieving a 30% reduction in downtime and improving system reliability.
  • Led a team of SQL DBAs, guiding the monitoring, tuning, and replication processes, resulting in enhanced data availability and disaster recovery capabilities.
  • Directed the migration from SQL Server 2008 to 2019, successfully upgrading over 50 servers with zero downtime, contributing to improved security and performance.
  • Developed and implemented advanced backup strategies, including FULL, Differential, and Transactional backups, ensuring 100% data recovery during incidents.
  • Executed and optimized SSIS package deployments, enhancing data flows efficiency and supporting various critical business operations.

Data Engineer – SQL & ETL

SIKOF
Delhi
03.2018 - 09.2019
  • Managed daily SQL Server administration, ensuring high availability, security, and performance across multiple production and development environments.
  • Designed and executed ETL processes that improved data migration efficiency by 20%, facilitating seamless integration of diverse data sources.
  • Developed and optimized complex SQL queries in SQL Server, enhancing data retrieval speed by 25% and reducing query execution times.
  • Automated task scheduling using MS SQL event scheduler, improving operational efficiency and reducing manual intervention.
  • Conducted extensive performance tuning of stored procedures, leading to a 30% improvement in execution times and system responsiveness.
  • Monitored and optimized database health and performance metrics, proactively resolving issues to ensure continuous availability and reliability.
  • Collaborated with developers on query tuning and schema optimization, resulting in more efficient database interactions and better application performance.

Associate Data Engineer

Ramky Enviro Engineers Ltd
Gurugram
06.2015 - 02.2018
  • Conducted thorough process evaluations and comprehensive requirements analyses to align software implementations with business needs.
  • Managed software implementation processes, delivering training and ensuring smooth transitions during module rollouts.
  • Oversaw sales, purchase, and finance modules functionalities, generating reports and managing databases for efficient data handling.

Education

MBA - Information Technology

Swami Vivekanand Subharti University
07.2022

Bachelor of Technology - Computer Science

Maharshi Dayanand University
07.2013

Skills

  • SQL and PostgreSQL
  • Talend and Snowflake
  • ETL processes
  • Python and C#
  • AWS services
  • Kafka messaging
  • Power BI and Excel
  • Data warehousing and reporting
  • Master data management (MDM)
  • Docker containers
  • RabbitMQ messaging
  • S3 storage solutions
  • DBT transformations
  • Metabase analytics
  • API integration
  • Git version control
  • Data modeling and governance
  • Jira project tracking
  • Postman API testing
  • Databricks analytics platform
  • Leadership and team management
  • Analytical thinking
  • Creative problem solving
  • Strategic planning
  • Project management methodologies
  • Performance tuning

Timeline

Senior Manager - Data Engineering

Genpact
02.2025 - Current

Project Leader - Data Engineering

R Systems pvt. ltd
06.2022 - 02.2025

Senior Data Engineer

TCS
09.2019 - 06.2022

Data Engineer – SQL & ETL

SIKOF
03.2018 - 09.2019

Associate Data Engineer

Ramky Enviro Engineers Ltd
06.2015 - 02.2018

MBA - Information Technology

Swami Vivekanand Subharti University

Bachelor of Technology - Computer Science

Maharshi Dayanand University
Nupur Dhall