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)
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
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Gyata JainGyata Jain
Senior SQL Server DBA at Tata Consultancy Services (TCS)Senior SQL Server DBA at Tata Consultancy Services (TCS)
Praveen Kumar GorantlaPraveen Kumar Gorantla
Test Lead at Tata Consultancy Services (TCS)Test Lead at Tata Consultancy Services (TCS)
Facundo GimenezFacundo Gimenez
Gerente Administrativo at Montevideo Open Mall (M.O.M.)Gerente Administrativo at Montevideo Open Mall (M.O.M.)