Support Engineer - Informatica 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 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: 

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 Support Engineer with Informatica  IICS  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 objects. 

• 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 files 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 RDBMS (SQL Server, Oracle), including complex SQL constructs and DDL  generation. 

• Strong knowledge on either DOS scripting or Shell scripting. 

• Evangelizes MDM best practice with customers and partners

• Quickly understands business issues and data challenges of client's organization and industry

• Provides functional support for MDM applications

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 a variety of data sources (OLTP, Data  Warehouse) . 

• Knowledge of Informatica Architecture 

• User interface design skills working knowledge of data modeling (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

• Prior experience working with clients face to face will be highly preferred

• Previous experience working with multiple technologies

• A desire to constantly grow and learn

• Enjoys a new challenge everyday and ability to think outside the box

• Prior experience with diagnosing and resolving issues

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