Saptarshi Basu

Saptarshi leads a team responsible for developing and maintaining core tools and frameworks used globally within MSD's Human Health (HH) division.

These tools leverage various AWS serverless technologies, including Lambda, SQS, SNS, EventBridge, API Gateway, DynamoDB, and S3. One notable framework, built on top of Matillion using AWS services like Lambda, SQS, and SNS, overcomes limitations in executing parallel workflows within Matillion.

Saptarshi has successfully led significant migration activities, such as the migration of Matillion servers from HH-owned AWS accounts to a central AWS account. He prepared the technical migration plan and coordinated with HH stakeholders globally. Additionally, he played a crucial role in migrating Airflow servers from an EC2-based architecture to EKS.

Currently, he is focusing on the data lakehouse architecture pattern using Databricks, further enhancing his expertise in modern data engineering practices.

During MSD's Human Health (HH) division's transition from a legacy application stack (Oracle, Informatica, AutoSys) to the cloud (AWS), Saptarshi was part of the core team responsible for designing the security model within the AWS account using IAM roles and policies.

He developed a Python application leveraging AWS DMS (Database Migration Service) to migrate data from Oracle to Redshift while a parallel solution was being built for direct data ingestion into Redshift. This application remained live for nearly three years, serving as a crucial stepping stone in HH's cloud journey by allowing downstream applications to start using Redshift as a warehouse solution while MSD decided and eventually developed solutions for direct data ingestion.

The solution dynamically created DMS tasks based on changes in source table data volumes, ensuring scalability and preventing task overloading.

Saptarshi played lead ETL developer role responsible for the delivery of project artifacts for three major markets.

He was involved in designing the end to end solution for Customer integration with DIL (data integration layer) and MDM

Simplify design of Informatica mappings (prototyping) to enable client team to generate Informatica artifacts with minimal effort using automation. Effort reduction – almost 30% due to simplified design

Saptarshi worked for different clients across different domains including British Airways, Dun & Bradstreet.

He worked as ETL and Oracle PLSQL developer during his tenure in Cognizant