Role: Informatica Developer with IICS

Location: Remote

Contract: Long Term Project

Client: TCS/ XCEL

Job Description:

• 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.