Aditi Bhattacharya

Project : Reunion

Client : BASF Tenure : Aug 2022- Till now

Responsibility:

• Worked as an architect for Reunion project, focused on data gathering from stakeholders and formulating logics based on requirements.
• Built complex adf pipelines which brings data from azure sql tables and stored raw data in datalake storage. Performed data transformations and joined multiple tables using databricks notebook and stored transformed data in transformed container of datalake storage. Finally pushed this data to on-premise oracle tables.
• Connected with external datalake storage and transformed data using azure databricks and stored it inside azure sql tables.
• Contributed to the entire lifecycle of Reunion project, actively involved from its inception to successful deployment.

Project : Europe Region

Client : BASF Tenure : July 2021-Till now

Responsibility:

• Developed complex pipelines to populate data from azure file storage and loaded it to azure datalake storage for downstream consumption with parameterized concept and fault tolerance capabilities.
• Built pipelines which will consume data from rest api and renamed the columns as per requirements and finally loaded in destination folder in adls based on daily scheduled triggers. Finally verified data with postman.
• Used the event-based trigger approach to load multiple files from azure blob storage and later stored in adls.
• Connected with on-premise oracle database and based on requirements loaded the data in adls.
• Used the concept of azure data flow activity to load data from source datalake to destination datalake based on multiple transformation logic.

Project : Global

Client : BASF Tenure : Aug 2022- July 2023

Responsibility:

• Built adf pipelines to bring data from source system with event-grid approach and loaded the entire snapshot data from source to adls destination.
• Performed incremental data load in every five minutes from on-premise oracle database and loaded data in delta lake storage.
• Performed different role like landscape manager for deploying codes from one environment to another as well as solution architect whenever needed to change the design.

Project : Reporting Factory

Client : Tata steel NL Tenure : July 2018 - June 2021

Responsibility

• Extracted data from SAP and mainframe systems.
  Developed mappings that perform extraction, transformation and load of source data into targets using various transformations like aggregator, filter, router, sequence generator, look up, rank, joiner, expression, stored procedure, SQL to meet business logic in mappings using informatica.
• Worked on end-to-end analysis of data from sources