- Hands-on experience with Informatica PowerCenter and other ETL tools

- Hands-on experience with Informatica IICS

- Should have working experience in Informatica Intelligent Cloud Services IICS components - Cloud application integration, Cloud data integration, Cloud B2B, data quality and governance cloud, data and cloud integration Hub.

- Experience in IICS Application Integration components like Processes, Service Connectors and process object.

- Extensive experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML,

- Advanced SQL skills required. Solid understanding of relational databases and business data; ability to write complex SQL queries against variety of data sources (OLTP, Data Warehouse) .

- Knowledge of Informatica Architecture

- User interface design skills working knowledge of data modeling (conceptual, logical and physical) as well as database design

- Solid experience with Business Intelligence/Analysis and Data Warehousing

- Solid understanding of relational and dimensional data model

- Experience in installing Add-on connectors and drivers for IICS





- Experience in Integrating Informatica cloud with other applications like Oracle ERP, Salesforce

- Expertise in using methodologies for data extraction, transformation and loading data using various transformations like Expression, Router, Filter, Lookup, Update Strategy, Union, and Aggregator.

- Strong technical experience building data integration processes by constructing mappings, tasks, task flows, schedules, and parameter files.

- Ability to write scripts for File watching and File transfer protocols.

- Experience in RDMBS (Oracle), including complex SQL constructs and DDL generation.

- Solid knowledge on either DOS scripting or Shell scripting.

- Ability to learn new technology and quickly adapt to technology changes

- Should have extensively worked on the below features of IICS:

- Data Integration and Transformations

- Performance Tuning and Optimization

- Error Handling

- Parameterizations

- Testing and Debugging

- Database Migration

- Database Ingestion/Mass Ingestion

- Different IICS Connectors

📌 IICS Developer (India)
🏢 QuessCorp/Genpact
📍 India