Piyush Chaudhari

About Piyush Chaudhari

6.5+ years of experience in Informatica CDI, Informatica PowerCenter, Informatica Data Quality (IDQ), Informatica Master Data Management (MDM), and ETL development- Proficient in integrating data between on-premises databases and cloud-based sources using Informatica Intelligent Cloud Services (IICS)- Skilled in creating mappings, validation rules, match paths, match columns, match rules, merge properties, and in the creation of entity objects, hierarchies, entity types, relationship objects, and relationship types- Knowledge on Data Modeling, designing and Data Analysis with Conceptual, Logical and Physical Modeling for Online Transaction Processing (OLTP), Online Analytical Processing (OLAP) and Data Warehousing- Experienced with cloud-based data sources including Dynamics 365, Credit Risk, and ZoomInfo- Experienced with traditional on-premises databases such as Oracle and SQL Server- Expert in all phases of the Software Development Life Cycle (SDLC), including project analysis, requirements gathering, design documentation, development, unit testing, user acceptance testing, implementation, and post-implementation support and maintenance- Proficient in working with various non-relational databases, including flat files, XML files, and CSV files- Extensive experience in data migration, data cleansing, and the extraction, transformation, and loading (ETL) of data from multiple sources to data warehouses- Instrumental in establishing standard ETL naming conventions and best practices across the ETL process- Experienced in addressing and resolving Informatica performance tuning issues related to sources, targets, mappings, transformations, and sessions, and optimizing transformations for enhanced session performance- Proficient in creating ETL design documents and experienced in crafting effective queries, views, and indexes- Skilled in designing reusable transformations in Informatica, such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer, and Rank, and in creating mappings using Informatica Designer and processing tasks using Workflow Manager to facilitate data movement from multiple sources to targets- Experienced in data profiling with Informatica Data Quality (IDQ) and IICS IDQ to analyze various data patterns- Completed an online MBA after getting an overview of how an IT industry functions and implementing the gained knowledge in my daily tasks to complete them more effectively.

Experience

1. Consultant

   KPMG

   Sep 2023 — Present · IN

   Worked closely with Business Analysts and End Users for gathering requirements and providing technical- solutions during the design phase- Analyzed complex data sets to identify patterns and trends, providing actionable insights for clients- Created a business model to identify and capitalize on new opportunities for client growth- Extensively used cloud transformations - Aggregator, Expression, Filter, Joiner, Lookup (connected and- unconnected), Rank, Router, Sequence Generator, Sorter, Union Transformations- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records- Involved in troubleshooting problems encountered during UAT phase and provided necessary fixes before going live- Automated ETL processes to reduce manual effort and improve data accuracy- Developed data cleansing procedures to remove and replace incorrect and incomplete data- Worked on building complex mappings and taskflows to meet business needs, and ensured they were reusable to avoid duplication- Designed and developed efficient error handling methods, and implemented them throughout the mappings- Coordinated with the DBA team for creating new databases, tablespace configurations, user account creation, and privilege management, when required for development purposes or migration purposes across different environments- Worked with a team of 4 onshore and 6 offshore development teams, prioritizing project tasks.

Education

• Yeshwantrao Chavan College of Engineering,Nagpur

  Bachelor of Engineering - BE, electronics engineering

  2015 — 2019

• Somalwar Nikalas High School and Junior College

  Secondary Education

• SVKM's Narsee Monjee Institute of Management Studies (NMIMS)

  Master of Business Administration - MBA, INFORMATION TECHNOLOGY AND SYSTEM MANAGEMENT