Summary
Overview
Work History
Education
Skills
Accomplishments
Soft Skills And Strengths
Websites
Timeline
Generic
Ayushi Mathur

Ayushi Mathur

Dubai

Summary

Accomplished Senior Data Engineer at Wipro with expertise in Azure Data Factory and PySpark. Successfully enhanced data processing efficiency through dynamic pipeline design and seamless integration into Azure Synapse. Known for analytical problem-solving and effective collaboration, I thrive in delivering innovative data solutions that meet complex business needs.

Overview

6
6
years of professional experience

Work History

Senior Data Engineer

Wipro
Pune
03.2024 - Current
  • Project: TD-Core Banking (Canadian banking client).
  • Analyzed user needs and created logical models that met those needs while adhering to industry standards.
  • Developed Azure Databricks notebook using PySpark and SQL for data transformation and orchestration codes, as per the framework for scheduling ADF pipelines.
  • Designed and implemented dynamic pipelines for data transformation and seamless integration into Azure Synapse, enhancing data processing efficiency and supporting advanced analytics.
  • Migrated multiple jobs from on-premises to Azure.
  • Deployed the code in multiple environments using Bitbucket.
  • Tested and compared the data between on-prem and cloud.

Data Engineer

AMDOCS
Pune
10.2021 - 03.2024
  • Project 1: 3 UK (UK based Telecom Client)
  • Project Purpose: To migrate the pre-paid and post-paid customers from the legacy system to the Amdocs system, along with historical data.
  • Role: Informatica Developer, along with data migration.
  • Technology: Informatica PowerCenter, Oracle, Unix shell scripting.
  • Performed source system data analysis in order to manage source-to-target data mapping.
  • Developed code on informatica tool, along with Unix and Oracle, to migrate customers as per requirements.
  • Manage assigned risks, and monitor potential impacts as part of the data migration plan.
  • Project 2: CRMF (Client) Migration Gen 1 to Gen 2.
  • Project Purpose: Data Migration
  • The key focus here was historical data migration from ADLS Gen1 to ADLS Gen2 and load the everyday incremental data to the Gen2 Delta tables.
  • Responsibilities: Migrated multiple applications from Azure Gen 1 to Gen 2.
  • Developed linked services and datasets for ADF pipelines.
  • Designed and developed ADF pipelines for data ingestion.
  • Implemented a Big Data component, such as Spark SQL, using Azure Databricks.

Data Engineer

Tata Consultancy Services
Pune
10.2018 - 10.2021
  • Project 1: UNFI (formerly SuperValu) (U.S. FMCG Client)
  • Project Purpose: To provide a fast and efficient automated data model to feed the source data into the EDW data model, in accordance with the business need.
  • Role: ETL Developer.
  • Technology: Informatica, Unix, Teradata.
  • Responsibilities: Developed an automated process as part of the R&D team, and a framework to generate the feed from different sources, and load it into target databases.
  • Performed cleansing and transformation as per the standards.
  • Project 2: IPAR
  • Project purpose: To extract a large amount of data into a simpler form according to the conditions provided by clients, and to design code accordingly.
  • Role: ETL Developer.
  • Technology: Informatica, SQL Server, Unix.
  • Responsibilities: Designed Informatica mappings of different SCD types.
  • Created procedures in SQL Server as per the client's requirement.

Education

Bachelor of Engineering - Information Technology

Oriental Institute of Science And Technology
Bhopal, Madhya Pradesh, India
06-2018

Central Board of Secondary Education (Certificate Exam) -

Jagrati Vidhya Mandir
Badnawar, Madhya Pradesh, India
05-2014

Skills

  • Azure Data Factory
  • Azure Databricks
  • Azure Synapse
  • Data pipeline design
  • PySpark
  • Python
  • Spark development
  • Informatica PowerCenter 1014
  • Data warehousing
  • SQL Server database
  • Oracle Database

Accomplishments

  • Was sent site to London (UK) for representation and deployment of project.
  • Was recognized and appreciated by the client for deploying the code as per committed timelines.

Soft Skills And Strengths

  • Work well independently and on a team
  • Quick learner, Self-motivated, Problem-solver
  • Good communication skills
  • Excellent written and verbal communication skills.

Timeline

Senior Data Engineer

Wipro
03.2024 - Current

Data Engineer

AMDOCS
10.2021 - 03.2024

Data Engineer

Tata Consultancy Services
10.2018 - 10.2021

Bachelor of Engineering - Information Technology

Oriental Institute of Science And Technology

Central Board of Secondary Education (Certificate Exam) -

Jagrati Vidhya Mandir

Similar Profiles

CREATE PROFILE
Ayushi Mathur