Surajit Sengupta

Background

About Surajit Sengupta

Data Architect having more than 16 year's of experience with strong knowledge inDatabase Technology, Data warehousing, ETL Development, Data Management, CloudComputing, Data Quality, Data Security.• Have rich experience on Legacy Modernization projects, moving data from Legacy onpremise platforms to on premise or cloud platforms.• Experience in Data Warehouse design and implementation as well as applicationdevelopment projects.• Experience in columnar MPP database AWS Redshift. Implemented Legacy to Cloudmodernization on Redshift.• Experienced in different AWS database (AWS RDS, AWS Aurora).• Experienced in creating and loading Stages in AWS S3. Have knowledge on differentstorage class and life cycle policy implementation.• Experienced in architecture design using AWS S3, IAM, AWS Lambda, AWSCloudWatch, AWS Fargate AWS EventBridge, AWS managed Airflow.• Experienced in designing the warehouse architecture in Snowflake (Cloud datawarehouse) with Data Vault 2.0 & Dimensional methodology.• Creating and loading Stages in Snowflake.• Loading and unloading data in Snowflake using Snow pipe, Copy Command• Loading and processing JSON data in Snowflake using the explicit Variant feature• Experienced in different features in Snowflake like data share, time travel, failsafe,zero copy clone, snowflake procedures and UDF• Experienced in Snowflake warehouse design, Clustering, Scale up and Scale Out.• Experience to create EDW in Snowflake using Data Vault2.0.• Experience in implementing SCD (Slowly changing Dimensions) as well as workingwith Star and snowflake schema with Fact and Dimension tables.• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DMLTriggers, Views, User defined data types, functions.• Experience in Data Extraction, Transforming and loading (ETL) between Homogenousand Heterogeneous System using Ab-Initio.• Competent with latest technologies in translating complex business problems intocustomer solutions together with Strategy, Design, Requirement Analysis, SOW andEstimation within budget.