Skip to content
View dk46164's full-sized avatar
๐ŸŽฏ
Focusing
๐ŸŽฏ
Focusing

Block or report dk46164

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
dk46164/README.md

Hi there, I'm Deepak(DK) ๐Ÿ‘‹

About Me

I'm a passionate Data Engineer with extensive experience in developing and optimizing data workflows and pipelines. With a background in computer science, I specialize in creating efficient data solutions that drive impactful results.

Key Achievements

  • Cost Savings: Developed a custom Python-based DAG orchestration framework, resulting in $200k annual savings.
  • Efficiency in CI/CD: Established a comprehensive CI/CD pipeline for Snowflake in Azure DevOps, ensuring robust SQL syntax and metadata validation.
  • Manual Effort Reduction: Created an XML parser in Azure DataBricks (PySpark), significantly reducing manual effort for schema inference and data flattening.
  • Performance Improvement: Optimized the existing ELT framework for Snowflake, cutting data load time by 70%.
  • Processing Speed: Built a Python library that decreased the parsing time of 2300 files to around 180 seconds using multiprocessing.

Technical Skills

  • Programming Languages: Python, Snowflake SQL, Bash Scripting
  • Tools & Technologies: Azure DevOps, DASK, Control-M, Pandas, PySpark, SnowPark
  • Data Engineering: ETL, ELT, DataBricks, CI/CD, XML Parsing

Education

B.Tech. in Computer Science
Institute of Engineering & Management, Kolkata
Jul 2016 โ€“ Jul 2020 | GPA: 7.97/10

Professional Experience

Data Engineer (Senior Analyst)
EY | Kolkata, India
July 2022 โ€“ Current

  • Developed a Python-based custom DAG orchestration framework with runtime restructuring, saving $200k annually.
  • Established a comprehensive CI/CD pipeline for Snowflake in Azure DevOps.
  • Developed an XML parser in Azure DataBricks (PySpark) to reduce manual schema inference effort.
  • Optimized ELT framework for parallel and deadlock-free data load in Snowflake, reducing load time by 70%.
  • Created a Python library to efficiently parse 2300 files, reducing parsing time to around 180 seconds.

Connect with Me

Let's Collaborate

I'm always open to discussing new projects, ideas, or opportunities to work together. Feel free to reach out!

Pinned Loading

  1. DWH DWH Public

    DataWareHouse Design , Developement & Implementation

    1

  2. SQL_pratice-Questions SQL_pratice-Questions Public

    List of SQL question & implementing recursive Logic in SQl

    1

  3. dk46164 dk46164 Public

    Config files for my GitHub profile.