Debasis Bhadra
Kolkata
Summary
Dynamic Data Analyst with over 7 years of experience in data analysis and ETL processes, successfully transforming complex data into actionable insights. Proven expertise in Talend and SQL, with a strong focus on data migration and enhancing process efficiencies. Skilled in collaborating with stakeholders to identify improvement opportunities, ensuring that data solutions align with business needs. Committed to leveraging technical capabilities and innovative problem-solving to support organizational growth and drive impactful results.
Overview
7
7
years of professional experience
Work History
IT Analyst
Tata Consultancy Services
Kolkata
10.2021 - Current
- Efficiently worked as a Snowflake developer to migrate the database from Oracle to Snowflake.
- Created Talend (version 8.0) jobs to migrate data from the Oracle to the Snowflake database.
- Responsible for designing and developing ELT processes (Talend), and creating database objects in Oracle/Snowflake to provide data for Tableau dashboards.
- Designed and implemented error handling, logging, success/failure notification in Talend jobs, and scheduling of Talend jobs in TMC.
- Performed root cause analysis on the problems and provided optimal solutions to the business.
- Collaborated with stakeholders to identify areas of improvement, and developed solutions to improve processes, which enhanced customer satisfaction.
- Served as Talend developer during Informatica to Talend migration project.
System Engineer
Tata Consultancy Services
Kolkata
11.2018 - 10.2021
- Served as a Talend (version 7.3.1) developer in the Ab Initio to Talend migration project and successfully migrated two applications from Ab Initio to Talend.
- Implemented ETL for data load from heterogeneous sources to Oracle as target databases, and for fact and slowly changing dimensions (SCD-Type 1 and SCD-Type 2) using Talend.
- Responsible for automating all ETL processes that can be automated.
Participated in requirements meetings and data mapping sessions to understand business needs.
Assistant System Engineer
Tata Consultancy Services
Kolkata
11.2017 - 11.2018
- Worked as an ETL developer for developing new Talend (version 6.3) jobs, bug fixes, and enhancements.
- Analyzed existing processes and implemented solutions to improve efficiency through parallel programming and performance optimization.
- Interacted with end users and conducted functional analysis to identify and develop Business Specification Documents, transforming them into technical requirements.
Education
Bachelor of Technology - Electronics & Communication Engineering
Kalyani Govt. Engineering College
Kalyani, West Bengal07-2017
Diploma - Electronics & Telecommunication Engineering
Ramakrishna Mission Shilpamandira
Howrah, West Bengal06-2014
Skills
- Talend
- Talend Management Console
- SQL
- Snowflake
- Ab initio
- Informatica
- Unix
- Gitlab
Timeline
IT Analyst
Tata Consultancy Services
10.2021 - Current
System Engineer
Tata Consultancy Services
11.2018 - 10.2021
Assistant System Engineer
Tata Consultancy Services
11.2017 - 11.2018
Bachelor of Technology - Electronics & Communication Engineering
Kalyani Govt. Engineering College
Diploma - Electronics & Telecommunication Engineering
Ramakrishna Mission Shilpamandira
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Sourav MukherjeeSourav Mukherjee
Senior Cloud Tester at Koerber PharmaSenior Cloud Tester at Koerber Pharma