Surajit Sengupta Email & Phone Number | • Data Architect having more than 14 years' experience with strong knowledge in Database Technology, ETL Development, Data Management, Cloud Computing, Data Security. • Experienced in design the Enterprise Data Model using Data Vault 2.0 methodology also have good knowledge in traditional dimension modelling. • Experienced in creating and loading Stages in AWS S3. Have knowledge on different storage class and life cycle policy implementation. • Experienced in creating the terraform code for different AWS services. • Experienced in AWS managed Airflow services for job orchestrations. • Experienced in designing the warehouse architecture in Snowflake (Cloud data warehouse). • 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 in columnar MPP database AWS Redshift. Implemented Legacy to Cloud modernization on Redshift. • Experience in AWS IMA, S3, EC2, VPC, RedShift, RDS, CloudWatch, Autoscaling, CloudFront. • Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using Ab-Initio. • Have rich experience on Legacy Modernization projects, moving data from Legacy on premise platforms to on premise or cloud platforms. • Experience in Data Warehouse design and implementation as well as application development projects. • Experience in implementing SCD (Slowly changing Dimensions) as well as working with Star and snowflake schema with Fact and Dimension tables. • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions. • Experienced in presales & project management activities including participating in due diligence workshops, Response to RFI /RFP, managing resources & project deliverables etc. • Competent with latest technologies in translating complex business problems into customer solutions together with Strategy, Design, Requirement Analysis, SOW and Estimation within budget.

Surajit Sengupta

• Data Architect having more than 14 years' experience with strong knowledge in Database Technology,...
Kolkata, West Bengal, India

*50 free lookup(s) per month.

No credit card required.

Surajit Sengupta’s Email surajit.sengupta@cognizant.com

Surajit Sengupta’s Phone Numbers

Get SURAJIT’s Phone Number (For Free)

Social Media

Surajit Sengupta’s Location Kolkata, West Bengal, India

Surajit Sengupta’s Current Industry Tata Consultancy Services

Surajit Sengupta’s Prior Industry Cognizant | Cmc

Not the Surajit Sengupta you were looking for?

Find accurate emails & phone numbers for over 700M professionals.

Work Experience

Tata Consultancy Services

Associate Consultant

2021-10-01 00:00:00 - Present

Cognizant

Project Manager

2021-01-01 00:00:00 - 2021-10-01 00:00:00

Cmc

Software Professional

2008-11-01 00:00:00 - 2011-08-01 00:00:00

Skills

No Skills Available

Languages

No Languages Available

FAQ About Surajit Sengupta

Surajit Sengupta is located at
Kolkata, West Bengal, India

Surajit Sengupta is a • Data Architect having more than 14 years' experience with strong knowledge in Database Technology, ETL Development, Data Management, Cloud Computing, Data Security. • Experienced in design the Enterprise Data Model using Data Vault 2.0 methodology also have good knowledge in traditional dimension modelling. • Experienced in creating and loading Stages in AWS S3. Have knowledge on different storage class and life cycle policy implementation. • Experienced in creating the terraform code for different AWS services. • Experienced in AWS managed Airflow services for job orchestrations. • Experienced in designing the warehouse architecture in Snowflake (Cloud data warehouse). • 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 in columnar MPP database AWS Redshift. Implemented Legacy to Cloud modernization on Redshift. • Experience in AWS IMA, S3, EC2, VPC, RedShift, RDS, CloudWatch, Autoscaling, CloudFront. • Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using Ab-Initio. • Have rich experience on Legacy Modernization projects, moving data from Legacy on premise platforms to on premise or cloud platforms. • Experience in Data Warehouse design and implementation as well as application development projects. • Experience in implementing SCD (Slowly changing Dimensions) as well as working with Star and snowflake schema with Fact and Dimension tables. • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions. • Experienced in presales & project management activities including participating in due diligence workshops, Response to RFI /RFP, managing resources & project deliverables etc. • Competent with latest technologies in translating complex business problems into customer solutions together with Strategy, Design, Requirement Analysis, SOW and Estimation within budget.