Solution Architect

**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 e-commerce and MDM platforms, which run on enterprise grade infrastructure that are 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**:
**Roles & Responsibilities**:

- Experience in IICS Application Integration components like Processes, Service Connectors and
- process object.
- Demonstrated success in building RESTful API Integration using IICS.
- Build Business Services using JSON file to call web services.
- 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 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**:

- 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

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