Pritam Nandy

About Pritam Nandy

A Talend and Snowflake certified competent professional currently working as an Data/ MDM Architect with over 14 years of experience in Data Warehousing/ETL/Data Quality/Master Data Management using Snowflake, Talend MDM (All modules) & SAP BODSExcellent track record of designing & developing high value and complex enterprise-level projects aimed at providing data on various performance parameters for Business Reporting needs of clients using TalendDesigned the architecture and Implemented Talend Upgrades from 6.4 to 7.3 for all Talend applications like TAC, DI, TDS, TDP, MDM etc. Developed solutions for given technical specifications; contributed to code reviews and hosted meetings with businessInteraction with stakeholders for gathering business needs, conducting data analysis, finalizing, and creating technical/functional specifications, low level & high-level design documents, use cases, mapping documents and development stepsDefining technical architecture considering real time constraints and subsequently realizing it into code; working, guiding design and development team for finalizing the development approachHeading complex ETL requirements and design; implementing Data Models (business entities, attributes and rules) in Talend MDMShaping, designing, developing, and enhancing overall ETL Talend DI & Talend MDM architecture in Talend Studio; identifying, recommending, and implementing ETL process and architecture improvementsDeveloping data quality, data consolidation and data matching solutions with the help of DQ and Matching components by studying information needs, conferring with users, studying data flow, data corrections and work processes using Talend Data StewardshipBuilding rules, data analysis and data correction on the raw files/data using Talend Data Preparation to be then consumed by the DI processMaintaining development modules including operational support, problem resolution, production support, preventative and corrective enhancementsManaging performance tuning of Talend solutions at job level and database level for faster performance on the batch and the real-time processReviewing mappings and enhancements for better optimization of the Talend DI data flows, workflows, jobs for all the team members for any changesProviding production support & maintaining objects in TAC with the ETL/DQ process for EDM Office Documenting ETL development, data definitions, system data flow diagrams, operational & process standards as per requirementWorking with Dev Ops for deployment of code to QA and PROD environments

Experience

1. Consultant Architect

   Sopra Steria

   Jan 2025 — Present · Bengaluru, IN

Education

• Siddaganga Institute Of Technology

  Bachelor of Engineering (B.E.), Information Technology

  2006 — 2010

• St. Mary's English High School

  Computer Science

  1992 — 2006

Skills

• Team Management
• Sap Information Steward
• Job Scheduling
• Extract, Transform, Load (Etl)
• Sql
• Databases
• Etl
• Data Quality
• Microsoft Sql Server
• Control M
• Relational Data Modeling
• Oracle
• Requirements Analysis
• Informatica
• Unix
• Sap Data Services