Devanshi Agarwal

Devanshi Agarwal

Internship

Followers of Devanshi Agarwal467 followers
location of Devanshi AgarwalGurugram, Haryana, India

Connect with Devanshi Agarwal to Send Message

Connect

Connect with Devanshi Agarwal to Send Message

Connect
  • Timeline

  • About me

    Data Engineer at Nagarro | AWS Certified Cloud Practitioner | Ex-TCS | Ex-Infosys

  • Education

    • United College of Engineering and Research

      2015 - 2019
      Bachelor of Technology - BTech Electronics and Communication 85%
    • St. Anthony's convent Girls' Inter College

      2014 - 2015
      12th PCM 85.4%
    • St. Anthony's Convent Girls' Inter College

      2012 - 2013
      10th PCM 85.6%
  • 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
  • Licenses & Certifications