Currently Working as IICS Developer in Cognizant from Feb 2022 to Dec 2022 and previously worked as Informatica PowerCenter Developer in Lobo staffing solution from sept 2016 to Jan 2022• Extensively used Informatica PowerCenter 10.x/9.x as ETL tool for extracting, transforming and loading from various source data inputs to various targets, in batch. • Experience on relational databases like Oracle, SQL Server and snowflake cloud.• Worked with different non-relational databases such as Flat files and XML files.• Worked extensively with Data cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data warehouse.• Having good experience and knowledge on Created many IICS mapping by using almost all transformations like source, Target, Aggregator, Joiner, Normalizer, Sequence, Lookup, Hierarchy Parser, Hierarchy Builder etc.• having Good exp in Creating Un-connected lookups and Dynamic lookups.• having in depth of knowledge in loading the dim tables by using Slowly changing dimension (SCD) Type 1 and Type 2 for change data capture.• Created different kinds of tasks in IICS like mapping task and data transfer task in IICS using various data sources Oracle dB Saved query and Target as Snowflake.• Created different types of components like saved Query, Hierarchical Schema, Fixed width File Format, Shared Sequence and File listener.• Created input/In-out Parameters from parameters panel in data integration. Created and used parameter files in different MCTs.• Experience in Informatica PowerCenter and IICS, snowflake cloud platform.• Experience working in end-to-end implementation of IICS.• Working with data storage systems like Snowflake, AWS S3.• Experience working in Agile/Scrum methodology.• Implemented SCD TYPE-1 and SCD TYPE-2 mapping logic in IICS and load to the dimension tables.