Rounak Das

Experience

• 

  Tata Consultancy Services

  Jul 2019 - Apr 2024

  System Engineer

  ●Implemented various ingestion processes with the help of Azure Databricks, Data factory to consume data. Created validation frameworks for checks on various files to prevent incorrect format files from being ingested.● Worked on SCD and Dimension data modelling like star schema, snowflake schema modelling, FACT and Dimension tables.● Created and orchestrated pipelines in Azure Data Factory using Linked services/Datasets to extract, transform and load data from sources like Azure blob storage up until Azure Data Lake or Azure Synapse.● Designed and implemented validation notebooks using python for the various finance projects to validate the successful loading of data and alerting the system in case of any corrupt data load.● Contribution to data modelling and data mapping by working closely with data architects & SAP SMEs. Show less

• 

  Deloitte

  Apr 2024 - now

  Consultant