ETL / IICS Lead

ETL / IICS Lead

19 Jan 2024
Massachusetts, Cambridge, 02138 Cambridge USA

ETL / IICS Lead

Vacancy expired!

Title: ETL /IICS Lead

Location: Cambridge MA

Duration: Long term

Description:
  • Ability to define and design the best architecture to install Informatica Intelligent Cloud Services (IICS) Secure Agent components and subsystems for a multi-server platform capable of scaling with growing number of components and applications
  • Proven ability to architect and build high volume, mission critical cloud native applications.
  • Demonstrated success in building RESTful API Integration using IICS.
  • Strong understanding across Cloud and infrastructure components (server, storage, network, data, and applications) to deliver end to end Cloud Infrastructure architectures and designs.
  • Experience in IICS Application Integration components like Processes, Service Connectors and process object.
  • Build Service connectors for Real Time integration with Third party applications.
  • Build Business Services using JSON file to call web services.
  • Experience in Integrating Informatica cloud with other applications like Salesforce, Workday, ServiceNow
  • Experience in installing Add-on connectors and drivers for IICS
  • 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 leveraging and writing architectural patterns, best practices and guidelines for enterprise applications.
  • Experience in RDMBS (SQL Server, Oracle), including complex SQL constructs and DDL generation.
  • Strong knowledge on either DOS scripting or Shell scripting.
  • Communicate project status with management
  • Ability to learn new technology and quickly adapt to technology changes
  • The qualified candidate will display excellent problem solving, analytical, communication, coordination, and task management skills Qualifications
  • 3 years of hands-on experience with Informatica IICS
  • 5 years of hands-on experience with Informatica PowerCenter
  • 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

Related jobs

Job Details

  • ID
    JC32052324
  • State
  • City
  • Job type
    Permanent
  • Salary
    Depends on Experience
  • Hiring Company
    Bahwan CyberTek Inc.
  • Date
    2022-01-11
  • Deadline
    2022-03-12
  • Category

Jocancy Online Job Portal by jobSearchi.