Sukanta Mitra

Background

About Sukanta Mitra

A highly passionate, proactive, and innovative senior data engineer with over 9 years of notable success in Data Warehousing, Large Scale Data Migrations, ERP implementations in roles such as Azure Data Engineer, Big Data Analyst, and Automation Test Engineer. I have successfully delivered a broad range of IT projects in functional areas such as the Customer market, Energy, and Water utility industries.• Highly proficient to develop solutions for optimal extraction, transformation, and loading of data from a wide variety of data sources using technologies such as Azure Data Factory, Databricks, and SQL Data Warehouse.• Strong technical abilities to understand, design, write, debug complex code, performing code reviews and performance tuning of SQL queries in SQL Datawarehouse (Azure Synapse).• Advanced SQL knowledge and experience in working with relational databases such as SQL Server, SQL Datawarehouse, SQL synapse analytics • Proficient in wrangling structured and unstructured data in various data lake storage types such as Azure Blob Storage, Azure Data Lake Storage Gen2, Azure Table Storage.• Developed control and data pipelines leveraging platforms such as Azure Data Factory, Azure Databricks, and SQL Synapse Analytics to ingest and transform data.• Worked on ingesting data from various sources into Raw Data Vault, loading into Business Data Vault, and creation of information Datamart using Azure Data Platform.• Worked as data migration lead in large-scale data migration projects.• Worked heavily on data reconciliation, data Analysis, business data provisioning.• Hands-on experience in working with Pyspark, Scala, Dataframes, Python libraries like Pandas.• Hands-on experience in CI/CD using Azure DevOps pipelines and Github.• Proficient in requirement gathering, requirement analysis, and conducting workshops. • Committed team player, a quick learner of evolving technologies. • Experienced in both Agile and waterfall methodology.• Ability to multi-task and adapt to a range of projects.