Avani Garg

Experience

• 

  Tata Consultancy Services

  Oct 2016 - Jul 2019

  Business Intelligence Developer

  Developed end to end ETL Mappings in Informatica, Table Structures, StoredProcedures and functions to build data warehouse in Teradata.Involved in architectural design of EDW, Data modeling and controllingmechanism.Extracted data from different ERPs ( SAP, QAD, DPRTS ) , databases (Progress DB, Oracle and Teradata), flat files, applied businesstransformations and loaded data using Teradata utilities like BTEQ, fast load,multiload and TPT in Informatica.Prepared project documents like deployment list, run book, Schedulingdocument, LLD and unit test evidence documents. Show less

• 

  Deloitte

  Aug 2019 - Nov 2021

  Engineered, designed & built data migration/ data modernization solutionsusing Azure cloud services to perform data ingestion from various datasources enabling the client to build a datahub on snowflake.Extensively worked on Azure Data Factory. Created dynamic andparameterized pipelines in ADF using Linked Services, Datasets, Pipelines,Logic apps, Triggers and azure SQL config tables to extract and load datafrom Oracle, Azure Data lake and semi-structured files into snowflake.Trained the client teams on azure ingestion stack to bring them up to speedand achieve the milestone of Deloitte + Client Training academy for big datamodernization and adoption of datahub system.As a program module lead, led a team of 7 developers to achieve releasemilestones, worked with program management to track the schedule,provide sprint goals in Jira and coordination with downstream and SIT teams. Show less

  • Consultant

    May 2021 - Nov 2021

  • Business Technology Analyst

    Aug 2019 - May 2021
• 

  Siemens Gamesa

  Nov 2021 - Mar 2022

  Cloud Data Engineer
• 

  Google

  Mar 2022 - now

  Cloud Migration Consultant