SHUBHAM CHAKRABORTY
Kolkata
Summary
A diligent ETL Developer having 3 Years of Experience and a passion for data analysis, have demonstrated good technical skills in Informatica, IICS, ADF, Oracle , SQL Server, Snowflake and MySQL for BI Dashboards. Motivated to gain more experience in data engineering domain to add value in Work as per company standard.
Overview
3
3
years of professional experience
7
7
years of post-secondary education
Work History
ETL Developer
ITC Infotech Limited
09.2023 - Current
- Company Overview: MODERN TRADE - The project is to analyze the business requirement and develop required ETL jobs to help Modern Trade team of ITC for their reporting and analytical Solutions
- Developed mappings, workflows and tasks using Informatica Power Center
- Collaborated with business analysts to understand and define requirements
- Completed quality reviews for designs, codes, test plans and documentation methods
- Created Tables, views as per new development requirements
- Review existing views and procedures for updates in application
- MODERN TRADE - The project is to analyze the business requirement and develop required ETL jobs to help Modern Trade team of ITC for their reporting and analytical Solutions
SQL Developer
Ubique Systems (Client PWC)
10.2022 - 08.2023
- Company Overview: DATA MODERNIZATION - In this project we are moving data from Legacy System to Modern Database
- Developed Mapping tasks and mappings which were using components like File listener, Intelligent structure model and Hierarchical Schema which constituted transformation like Source, Target, Joiner, Expression, Mapplet, lookup, Hierarchical builder and Parser
- Developed Task flows of various kind like Sequential, Parallel and parallel Task with decision as part of client requirement
- Worked on converting Informatica Power Center ETL Code to IICS and implemented Type1, Type2 and incremental load strategies in IICS
- Used Push Down Optimization and Partition as part of Performance Tuning Technique in IICS Mappings which resulted in decrease in runtime by 10%-15%
- Created Tables, custom query and Views in Snowflake for data migration as per legacy systems like Teradata, SQL Server and Oracle
- DATA MODERNIZATION - In this project we are moving data from Legacy System to Modern Database
Jr. SQL Developer
Ubique System (Client - PWC)
09.2021 - 07.2022
- Company Overview: Implementation of database model in Azure Storage for SAP modules (PROCUREMENT, SALES & INVENTORY)
- Created and Managed database objects like Tables, Stored procedure and Views
- Worked on fixing of Stored Procedures (SP) for Data migrations and auditing
- Fixing and Monitoring Azure Data Factory (ADF) pipelines and fixing issues related to data transformation process
- Implemented Partitioning and Indexing resulted in decrease in run time by more than 15%
- Worked on Custom Power BI Report development
- Implementation of database model in Azure Storage for SAP modules (PROCUREMENT, SALES & INVENTORY)
Education
Adv Diploma - Industrial Safety And Environmental Management
Jadavpur University
Kolkata, West Bengal 08.2019 - 09.2021
Bachelor of Technology - Mechanical Engineering
Academy of Technology
Adisaptagram, Hooghly 08.2013 - 07.2017
Higher Secondary - Science Education
D.A.V PUBLIC SCHOOL D.V.C M.T.P.S
03.2012 - 05.2013
Skills
Data warehousing
ETL modeling
Data migration
SQL programming
Timeline
ETL Developer
ITC Infotech Limited
09.2023 - Current
SQL Developer
Ubique Systems (Client PWC)
10.2022 - 08.2023
Jr. SQL Developer
Ubique System (Client - PWC)
09.2021 - 07.2022
Adv Diploma - Industrial Safety And Environmental Management
Jadavpur University
08.2019 - 09.2021
Bachelor of Technology - Mechanical Engineering
Academy of Technology
08.2013 - 07.2017
Higher Secondary - Science Education
D.A.V PUBLIC SCHOOL D.V.C M.T.P.S
03.2012 - 05.2013
Similar Profiles
VIJAYA SHANTHI VIJAYA SHANTHI null
Windchill & FlexPLM Developer at ITC Infotech LimitedWindchill & FlexPLM Developer at ITC Infotech Limited
Aditya BiswasAditya Biswas
Consultant at Infosys LimitedConsultant at Infosys Limited
Rakshith G AminRakshith G Amin
Business Analyst at ITC Infotech India LimitedBusiness Analyst at ITC Infotech India Limited