Over 10 years of experience in implementation of DW/BI solutions and involved in end-to-end project life cycle- Analysis, design, development, Production support, automation & implementation. Extensive experience in implementing ETL solutions using Informatica Power Center 10.2.0/9.6.1/9.1.0/8.6.1, Informatica Cloud (IICS), Snowflake and Qlik compose. Experienced in Healthcare, Telecom, and Banking for data warehousing projects.• Responsible for Extraction, Transformation, and Loading of data from multiple sources into Data Warehouse, Snowflake, Salesforce• Designed Snow pipes to load data from Azure blob to Snowflake raw layer and used Qlik compose to design model and load into Snowflake DW, DM and SA layers.• Designed and developed Mappings from varied Transformation’s logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update strategy and more.• Designed and developed Mappings, Tasks, Linear workflows, Replication tasks and Synchronization tasks using Informatica Cloud (IICS).• Worked with different transformation like Hierarchy Builder, Hierarchy parser, Joiner, Expression, Lookup and more using informatica cloud to load data into Salesforce.• Strong conceptual knowledge in Dimension Modeling (Dimension tables, Fact tables, Star Schema and Snowflake Schema).• Good experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.• End to end implementation of EDW/BDW/Data marts.• Expertise in working with different data sources like Oracle, SQL Server, and Flat Files.• Excellent inter-personal and communication skills and ability to work individually as well as in a team. Technologies: Informatica Power Center 10.2.0/9.6.1/9.1.0/8.6.1, Informatica Cloud (IICS), Snowflake, Business Objects, XIR2/R3,Teradata V2R6/12/13 (fast load, multiload, fastexport,TPT, Tpump), Oracle 9i/10g/11i, SQL Server, SQL, PL/SQL, Shell Scripting, Tidal, Control-M, Autosys, Reliance, Remedy, Toad, SQL developer, SQL Assistant, Service now, HP Quality Center, Putty