SAP PI PO PIPO & Informatica expertise in both SAP ERP and Informatica ETL

Overview

Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

ALE
Adapter
Analytical Skill
Business-to-business
Communication
Conflict Resolution
Data Analysis
Data Extraction
Data Loading
Data Mapping
Data Marts
Data Modeling
Data Warehouse
Database
Electronic Data Interchange
Extract
Transform
Load
Informatica PowerCenter
Flat File
Functional Requirements
HTTP
IDoc
Informatica
Interface Design
Interfaces
JDBC
JMS
Java
Mapping
Modeling
Oracle ERP
PL/SQL
Performance Tuning
Problem Solving
Proxies
RFC
Requirements Analysis
Root Cause Analysis
SAP
SAP ERP
SAP FICO
SAP MM
SAP PI
SAP PO
SD
SFTP
SLD
SOAP
SQL
SQL*Loader
Shell Scripting
Snow Flake Schema
Specification Gathering
Stored Procedures
Unit Testing
Unix
Web Services
XSLT

Job Details

Role:- SAP PI PO PIPO & Informatica expertise in both SAP ERP and Informatica ETL

Location:- Cincinnati, Ohio ( Remote)

JD

PIPO Skills:

7+ years Experience in SAP PI 7.3.1 or SAP PO 7.4 or SAP PO 7.5

Minimum 2 end to end Implementation involving SAP PI interface Design with PI/PO and operations & maintenance of interfaces for SAP systems involving RFC / File / ALE /EDI/WebService based interface developments,

Expert in using PI/PO tools (mapping tools/editors) and proficient in different mapping styles (Graphical Mapping, Java Mapping, XSLT Mapping) & Interfaces using at least Advanced Adapter Engine (AAE)

Extensively working on PI Adapters (EDI, JDBC, HTTP_AAE, IDoc_AAE, RFC, File, XI, SOAP, SFTP, JMS, WebService etc)

Expertise in designing Interface solution based on Functional Spec, and also reviewing technical specifications

Experience in B2B interfaces using EDI/ALE/IDOC interfaces

Must be familiar and hands-on with troubleshooting operational and performance issues, root cause analysis, performance optimization.

Configuration/implementation and support of interfaces based on various standard industry protocols like IDOC, RFC, JDBC, File, Proxy, SOAP, HTTP, REST, SFTP etc.

Must Worked in SLD configuration

Expert in Component based Alert configuration

Should have good hands-on expertise in trouble shooting the PI issues

Should have worked on developments from SAP modules like SD, MM, IM, FICO etc.

Good to have SAP PI systems upgrade experience

Should have proven Excellent analytical , problem-solving, troubleshooting abilities

Excellent communication (written and oral) and interpersonal skill.

Informatica Skills

Candidate must have at least 2 yrs of hands on experience in Informatica

- Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, ERP systems and Flat files.

- Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses using Informatica Power Centre

- In-depth understanding of fundamental Data-Warehousing concepts such as Dimensional Modelling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modelling.

- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

- Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

- Extensive experience in ETL design, development and maintenance using Oracle SQL, PLSQL, SQL Loader

- Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.

- Experience in database programming in PLSQL (Stored Procedures, Triggers and Packages).

- Well versed in UNIX shell scripting.

-Must have some basic knowledge on SAP system and must have some prior experience by using SAP as source/target through Informatica.

- Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.