Over 6+ years of extensive experience with Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation, and support of Data Warehousing applications using Informatica PowerCenter 10.x /9.x/8.x/7.x, IICS, IDQ, IDMC, Informatica ETL Developer etc.• Extensive knowledge in Data Extraction, Transformation and Loading (ETL) using Informatica Intelligent Cloud Services (IICS/IDMC), Informatica Power center 10.4 /10.1 /9.5 /9.1/ 8.6.1.1 and SSIS.• Professional experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle and snowflake databases on windows and UNIX platforms.• Track record of successful implementation of Cloud Enterprise Data Warehouse in Snowflake with IICS as ETL Tool.• Proficient in using Amazon Web Services AWS.• Extensive experience focusing on services like EC2, VPC, Cloud Watch, Cloud Front, Cloud Formation, IAM, S3, SNS, SQS.• Expert in creating Mappings, Mapping tasks, Taskflows, Synchronization tasks, Replications tasks, Dynamic mapping tasks, mass ingestion tasks etc. using IICS.• Expert level experience in Data Integration and Data Warehousing using ETL tool Informatica PowerCenter (Source Analyzer, Target Designer, Mapping/ Mapplet Designer, Sessions/tasks, Worklets / Workflow Manager).• Expert in IICS (Informatica Intelligent Cloud Services) for Cloud based Data Integration between cloud and on-premises systems.• Experienced in using IICS for Data Integration and Data Migration from many source systems.• Extensively worked on Extraction Transformation and Loading (ETL) using IICS/Informatica 10.1/9.6/9.x, Cloud Database like Azure database, AWS and On-prem like Oracle, SQL etc.• Extensive knowledge in Streams, Tasks, continuous ingestion using Snow pipe, loading data from external stages, time travel concepts etc... in snowflake.• Strong expertise in Relational database systems like Oracle and snowflake, design and database development using SQL, PL/SQL, SQL Developer, TOAD.