Sandeep Kumar
ETL Developer
Greater Noida
Summary
Accomplished data engineering and ETL professional with over 11 years of extensive experience in Agile and SDLC-driven consulting, specializing in the analysis, design, and development of innovative solutions utilizing the Microsoft BI Stack, Azure SQL, and various cloud technologies. Expertise in ETL processes and Big Data frameworks, including Azure Synapse, Databricks, and Snowflake, ensures the delivery of robust and scalable data solutions tailored to meet complex business needs. Proven ability to design and implement Azure Data Factory and Synapse pipelines that efficiently manage intricate data sets while translating business requirements into actionable technical specifications. Strong background in SQL, database management, and CI/CD pipelines enhances operational efficiency and supports seamless collaboration across diverse project environments.
Overview
14
14
years of professional experience
Work History
Senior Data Engineer
Coforge Pvt. Ltd
04.2021 - Current
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Championed the adoption of agile methodologies within the team, resulting in faster delivery times and increased collaboration among team members.
- Participated in strategic planning sessions with stakeholders to assess business needs related to data engineering initiatives.
- Designed robust database architecture that supported seamless integration of new datasets and facilitated rapid analysis capabilities.
- Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.
- Contributed significantly towards setting up an automated monitoring mechanism using state-of-the-art technologies and tools, which led to proactive issue identification and resolution.
SQL Developer
SRS Infoway / Infosys
09.2020 - 04.2021
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Participated in regular status meetings with project stakeholders to provide updates on progress and address any concerns or feedback promptly.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
- Developed custom database objects, stored procedures, and delivered application support.
- Optimized server resource usage by monitoring performance metrics and making necessary adjustments to SQL Server configurations.
- Performed regular database backups to prevent information loss.
Sr. Data Analytics Analyst
Risk Management Solution India Pvt. Ltd.
06.2012 - 11.2018
Education
MCA - Computer Science And IT
Sikkim Manipal University (SMU)
Noida01.2015
Graduate - Economics
C.C.S. University
Meerut01.2004
Intermediate -
U.P. Board
01.2001
High School - undefined
U.P. Board
01.1999
Skills
Windows XP
Windows Vista
Windows 7
Windows 10
Azure Synapse
Databricks
ADLS Gen2
PySpark
Scala
Snowflake
SSIS
SQL
C#
SAS
Azure SQL
SparkSQL
SQL Server 2019
SQL Server 2016
SQL Server 2012
SQL Server 2008
MS Visio
SSAS
OLAP Cubes
SSRS
Report Builder
Azure Storage Explorer
BIDS
SSDT
Visual Studio 2010
Visual Studio 2013
Visual Studio 2017
Git
GitHub
JIRA
Confluence
Agile
Scrum
Personal Information
- Pan Number: Bftpk8786g
- Passport Number: N7274357
- Date of Birth: 15-Oct-1984
- Marital Status: Married
- ID Type: Passport
- ID Number: N7274357
Honours And Awards
- Recipient of 'Individual Excellence Award' for exceptional performance and commitment to work at RMS.
- Got awarded with 'collaboration Award' for client interaction.
- Also got recognition awards for performance in RMS.
Timeline
Senior Data Engineer
Coforge Pvt. Ltd
04.2021 - Current
SQL Developer
SRS Infoway / Infosys
09.2020 - 04.2021
Sr. Data Analytics Analyst
Risk Management Solution India Pvt. Ltd.
06.2012 - 11.2018
High School - undefined
U.P. Board
MCA - Computer Science And IT
Sikkim Manipal University (SMU)
Graduate - Economics
C.C.S. University
Intermediate -
U.P. Board