Devanshi Agarwal

Experience

• 

  Asian Institute of Technology

  Jul 2016 - Jul 2016

  Internship
• 

  Civil Aviation Training Center

  May 2018 - Jul 2018

  Internship Program
• 

  Infosys

  Aug 2019 - Sept 2022

  • Senior System Engineer

    Jan 2022 - Sept 2022

  • System Engineer

    Jan 2020 - Dec 2021

  • System Engineer Trainee

    Aug 2019 - Dec 2019
• 

  Tata Consultancy Services

  Oct 2022 - Apr 2024

  Data Engineer

  • To help business not to lose the data in case of any refresh failure, created the Rollback job, which reverts the data in the database based on the configuration Input. • To resolve the cube refresh issue, Design and develop ETL pipeline using AWS S3, Matillion, Snowflake, and Python with the aid of 4 parallel processing and successfully deliver PV dashboards. • To enhance the overall performance of Reports and Dashboards, used the “flatten table” approach which simplified querying and analysis, resulting in a 50% reduction in loading time. • Use the conversation like SQL functionality, to build the pipeline to load the data from Snowflake to GCP Big Query. • Execute complex SQL queries using database functions, stored procedures, Nested Queries, views, and Joins.• Solid understanding of advanced snowflake concepts like Streams, tasks, warehouse optimizations, and SQL tuning/pruning. • Collaborated closely with business teams to understand needs and requests to build data pipelines to move the data from on-premise to the cloud database and vice-versa.• Experience in leading a team and working in an Agile development environment Show less

• 

  Nagarro

  Apr 2024 - now

  Senior Engineer