This Job Vacancy has Expired!

Senior Data Engineer- IICS- USA- 6 months+

Global Enterprise Partners

Posted on Feb 14, 2021 by Global Enterprise Partners

Milpitas, CA 95035
Immediate Start
Annual Salary

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

    • Parameterizations

    • Testing and Debugging

    • Database Migration

    • Database Ingestion/Mass Ingestion

    • Different IICS Connectors

Location: USA- Milpitas- Remote until further notice
Start date: ASAP

Reference: 1096364303

Set up alerts to get notified of new vacancies.