Iics Etl

11 Jun 2024

Vacancy expired!

Title: IICS ETL Duartion: 6 Months Location: Quincy MA

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

  • ID: #42835876
  • State: Massachusetts Quincy 02169 Quincy USA
  • City: Quincy
  • Salary: $70 - $75
  • Job type: Contract
  • Showed: 2022-06-11
  • Deadline: 2022-07-26
  • Category: Et cetera