Senior Data Engineer- IICS- USA- 6 months+
Posted on Feb 14, 2021 by Global Enterprise Partners
Global Enterprise Partners is currently looking for a Senior Data Engineer-IICS for one of our clients in USA for 1 year.
Senior Data Engineer-IICS:
- 4+ years of hands on experience with Informatica IICS
- 5+ years of hands on experience with Informatica PowerCenter and other ETL tools
- 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 modelling (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 Salesforce, Workday, ServiceNow
- 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 (SQL Server, Oracle), including complex SQL constructs and DDL generation.
- Strong 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
- Testing and Debugging
- Database Migration
- Database Ingestion/Mass Ingestion
- Different IICS Connectors
Location: USA- Milpitas- Remote until further notice
Start date: ASAP