Associate Solutions Consultant - IICS

Introduction:

Our goal at Pivotree is to help accelerate the future of frictionless commerce. We will help lead this change over the next decade because we believe a future where technology is embedded intimately into all aspects of our everyday lives can benefit everyone and will shape the interactions with the brands we love. We will help shape the future of frictionless commerce by working together with some of the best brands in the world and some of the best people in the industry to leverage converging technologies that will make it possible to accelerate frictionless commerce faster than ever.

Pivotree provides services focused on the design, implementation, management, and maintenance of complex ecommerce solutions for large enterprises. We provide the technical skills necessary to enable the effective use of technologies combined with the business context to leverage a solution to solve our clients' business challenges. We strive to fill the gaps in available technology with our own IP to reduce the barriers to adoption.

We enable inclusive, immersive and highly personalized experiences for our clients and their customers. We build our products with a view to productizing and scaling technology to lower the costs and reduce the risks of implementing and managing our integrated solutions. Each of our solutions starts with reliable and reputable ecommerce, Fulfillment, MDM and Data solutions, which run on enterprise-grade infrastructure that is customized to meet a variety of client needs, situations, and budgets. Over the next 10 years, we will add new categories and capabilities that will define frictionless commerce ecosystems.

This is a journey of technology acceleration combined with consumer readiness and adoption. We are looking for people capable of adapting relentlessly to the rapidly evolving world around us.

Position Summary:

As a market leader in providing product data content solutions, we engage with our clients to assess and implement best-of-breed applications to address their Master Data Management (MDM) and Product Information Management (PIM) needs. We are currently looking for a IICS Developer with hands-on experience that will develop and deliver solutions that enable the collection, transformation, and management of information from one or more sources.

Roles & Responsibilities:
•Experience in IICS Application Integration components like Processes, Service Connectors and process object.
•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.
•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, taskflows, 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

Key Skills and Competencies:
•Experience with Informatica IICS services CAI, CDI.
•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

Pivotree is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive and accessible workplace.