Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Pritam Chowdhury

Pritam Chowdhury

ETL Developer
Montevideo,MO

Summary

Result-oriented IICS Developer with 5.5+ years of experience designing and optimizing scalable ETL pipelines using Informatica Intelligent Cloud Services (IDMC). Strong track record in cloud data integration/application integration, PowerCenter migration, performance tuning, and production support across Oracle and Azure ecosystems. Adept at handling end-to-end data workflows, automation, and stakeholder collaboration in fast-paced enterprise environments.

Developed strong data integration and transformation skills in collaborative and fast-paced environment, seeking to transition into new field. Deep understanding of ETL processes and data warehousing principles, with hands-on experience in SQL and scripting. Aiming to apply analytical and problem-solving skills to drive innovation and efficiency in new role.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior IICS ETL Developer(Onsite)

Tata Consultancy Services (TCS)
04.2024 - Current
  • Designed and deployed hybrid cloud ETL pipelines using IICS CDI/CAI for real-time and batch integrations.
  • Developed ETL processes to extract, transform, and load data from multiple sources.
  • Automated job deployment and scheduling using Jenkins and CAI, reducing manual effort by 30%.
  • Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
  • Built reusable parameterized mappings with robust error-handling, improving pipeline reliability by 40%.
  • Streamlined data flow between multiple systems through the creation of efficient ETL pipelines and APIs.
  • Worked with cross-functional teams to gather business requirements and implement scalable data solutions.
  • Provided L2/L3 production support, decreasing job failures by 20% through root-cause analysis and fixes.
  • Spearheaded initiatives aimed at improving overall data quality through rigorous testing programs.
  • Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
  • Collaborated with stakeholders to gather requirements for data integration projects.

Senior Developer and Tech Lead

Tata Consultancy Services (TCS)
10.2022 - 03.2024
  • Developed ETL processes to extract, transform, and load data from multiple sources.
  • Designed and maintained data models to support reporting requirements and business intelligence initiatives.
  • Assisted in the creation of documentation for ETL processes and data mapping specifications.
  • Collaborated with data analysts to identify data quality issues and implement solutions.
  • Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
  • Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Deployed scalable solutions capable of handling large volumes of data while maintaining high standards of reliability and performance.

Education

Bachelor of Technology (B.Tech) - Mechanical Engineering

Maulana Abul Kalam Azad University of Technology (MAKAUT)
01.2019

Skills

  • ETL Tools: Informatica IDMC (CAI/CDI/CDGC), PowerCenter
  • Languages: SQL, PL/SQL, Shell Scripting, Unix, Python
  • Databases: Oracle Autonomous DB
  • Cloud Platforms: Oracle Cloud Infrastructure (OCI), Azure
  • Data Modeling: Star Schema, Snowflake Schema, OLTP/OLAP
  • CI/CD & Versioning: Git, Jenkins
  • Utilities: JIRA, MS Excel, MS Visio
  • Data migration
  • Data cleansing
  • ETL modeling

Certification

  • Microsoft Certified: Azure AI Engineer Associate
  • Informatica Cloud Data Governance and Catalog (CDGC)
  • Informatica Cloud Data Integration for PowerCenter Developers – Foundation

Languages

English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Bengali
Bilingual or Proficient (C2)

Timeline

Senior IICS ETL Developer(Onsite)

Tata Consultancy Services (TCS)
04.2024 - Current

Senior Developer and Tech Lead

Tata Consultancy Services (TCS)
10.2022 - 03.2024

Bachelor of Technology (B.Tech) - Mechanical Engineering

Maulana Abul Kalam Azad University of Technology (MAKAUT)
Pritam ChowdhuryETL Developer