Summary
Overview
Work History
Education
Skills
Disclaimer
Current Location
Timeline
Generic

Deepshekhar Dey

KOLKATA

Summary

ETL Developer with 3 years of experience at TCS, specializing in designing and deploying large-scale ETL solutions using Informatica PowerCenter, IICS, and Snowflake. Expertise in automating data pipelines and troubleshooting data issues to ensure efficient analytics delivery. Proven ability to enhance data processing reliability for business teams.

Overview

3
3
years of professional experience

Work History

Informatica Developer

TCS
Kolkata
09.2022 - Current
  • Designed and developed ETL workflows, mappings, and processes using Informatica PowerCenter and IICS for automated data extraction, transformation, and loading across multiple source systems.
  • Maintained and enhanced ETL pipelines to optimize performance, scalability, and reliability for large-scale data integration projects in Banking, Financial Services, and Insurance domains.
  • Analyzed requirements and executed systems analysis for comprehensive data migration, integration, and reporting solutions with business stakeholders.
  • Participated in SDLC testing phases by developing and executing unit, integration, and UAT test cases for ETL jobs to ensure data accuracy.
  • Monitored daily ETL loads by tracking workflow executions, resolving job failures, and ensuring healthy data flows in production environments like Snowflake and AWS S3.
  • Developed technical documentation including mapping specifications, workflow designs, and operational support materials for ETL solutions.
  • Collaborated with cross-functional teams to implement enhancements, troubleshoot issues, and deliver timely data for analytics and reporting.

Education

BTech - Computer Science and Engineering.

Jorhat Engineering College
Jorhat, Assam
07-2022

Skills

  • ETL tools: Informatica PowerCenter, IICS, Talend
  • Programming languages: SQL, PL/SQL, Python, Java
  • Database management: Oracle, SQL Server, Snowflake
  • Data integration: ETL pipeline design, data mapping
  • Cloud platforms: Snowflake, AWS S3
  • Performance optimization: Tuning and modeling
  • Agile methodologies: SCRUM practices

Disclaimer

I do hereby declare that the above statements are true to best of my knowledge and belief.

Current Location

Kolkata, West Bengal

Timeline

Informatica Developer

TCS
09.2022 - Current

BTech - Computer Science and Engineering.

Jorhat Engineering College

Similar Profiles

CREATE PROFILE
Deepshekhar Dey