Should have 8 years Informatica experience with 2 years IICS experience in ETL Tools implementation of Informatica Intelligent Cloud Services (IICS) and Power center. Should have working experience in ETL data from various sources into Data warehouses and Data Marts using IICS informatica cloud components. Profile & Analyze Source data using IICS Informatica tool Build ETL mappings using IICS in Cloud Data Integration Proficient in SQL Server and Oracle databases. Ensure appropriate level of Unit Test of all the deliverables. Ability to prioritize and execute tasks in a high - pressure environment Experience in IICS Application Integration components like Processes, Service Connectors and process object. Demonstrated success in building RESTful API Integration using IICS. Good to have following Responsibilities: Responsible for automation of the processes process of impact analysis, remediation related changes, validations etc. Create and maintain adequate documentation of project ETL design, technical artifacts and ETL environment. Creating ETL protocols and database objects Working on upgrades & system maintenance, developing complex mappings and load data from different sources to vertica Designing and Data Modelling Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services. Strong functional understanding of RDBMS DWH-BI conceptual knowledge. Excellent data analysis and data profiling skills using Informatica and Excel.