Nikhil Kumar Dubey
Pune
Summary
Results-driven Technical Lead and Data Engineer with 6 years of experience in designing and implementing data engineering and ETL solutions across cloud and on-premises platforms. Skilled in Azure Data Factory, Snowflake, Informatica PowerCenter, Python, Control-M, and Oracle SQL. Expertise in ETL processes, data integration, and automation, with a focus on production support and incident management in Agile environments.
Overview
6
6
years of professional experience
Work History
Technology Lead
Infosys Limited
Pune
03.2025 - Current
- Designed and implemented Snowflake queries, views, and stored procedures for data loading and reporting table population.
- Developed Python scripts in Snowflake Notebooks to dynamically generate XML files from transformed datasets.
- Automated export of CSV and XML files to Azure Blob Storage using ADF pipelines for downstream consumption.
- Coordinated with developers, data engineers, and stakeholders to ensure timely delivery of end-to-end data pipeline.
Senior Data Engineer
LTIMindtree
Navi Mumbai
05.2023 - Current
- Provided continuous 24/7 support for ETL systems to ensure efficient data processing.
- Utilized Informatica PowerCenter services, including monitoring and workflow, to manage and resolve issues.
- Developed ETL mappings for data extraction, transformation, and loading in Oracle databases using Informatica.
- Automated daily tasks with Python scripting, reducing manual effort and enhancing operational efficiency.
- Employed Python libraries like pandas for data manipulation and selenium for web automation.
- Collaborated with cross-functional teams to optimize ETL workflows and boost system performance.
- Designed, developed, and deployed PL/SQL programs to streamline various business processes.
Senior Software Engineer
LTIMINDTREE
Navi Mumbai
05.2021 - 05.2023
- Executed two server migration projects and administered Windows environments, including Java/Tomcat configuration.
- Automated Control-M job scheduling using Cygwin and developed Unix scripts for Informatica ETL processes.
- Managed Automated Quality Record application to enhance operational performance.
- Designed, developed, and deployed PL/SQL programs to streamline data management workflows.
Software Engineer
LTIMINDTREE
Navi Mumbai
09.2020 - 05.2021
- Delivered comprehensive production support for Automated Quality Record application, resolving issues collaboratively with users and cross-functional teams.
- Led migration from on-premises to AWS EC2 servers to enhance infrastructure efficiency.
- Developed Tableau dashboards to provide actionable insights for informed business decisions.
Graduate Engineer Trainee
LTIMINDTREE
Navi Mumbai
09.2019 - 09.2020
- Delivered end-to-end production support for Intelex application, ensuring system stability and operational efficiency.
- Analyzed and resolved application and database issues collaboratively with US, EMEA, and APAC users.
- Provided 24/7 technical support to enhance user workflows and minimize downtime.
Education
Bachelor of Engineering -
Savitribai Phule Pune University
Nashik07.2019
Skills
- Snowflake and Azure
- Python programming
- Azure Data Factory
- SQL
- Data modeling
- Informatica PowerCenter
- Problem solving
- Effective communication
Timeline
Technology Lead
Infosys Limited
03.2025 - Current
Senior Data Engineer
LTIMindtree
05.2023 - Current
Senior Software Engineer
LTIMINDTREE
05.2021 - 05.2023
Software Engineer
LTIMINDTREE
09.2020 - 05.2021
Graduate Engineer Trainee
LTIMINDTREE
09.2019 - 09.2020
Bachelor of Engineering -
Savitribai Phule Pune University