Informatica Power Exchange job vacancy

Vacancy expired!

Informatica Power Exchange

Required Skills

Job Responsibilities

Participate in full software development life-cycle from requirements gathering, estimating, design, development, and implementation
Developing CDC mappings and experience using number of transformations like Expression, Reusable Sequence Generator, Java transformation, Router, Update Strategy, Filter and
Developing Source and Target systems like SAP source systems, Oracle database system and flat files.
Using Informatica Power Center, via Informatica Power Exchange
Experience on Change Data Capture and Real Time support from Mainframe, SQL Server, and Oracle database sources.
Experience in Power Exchange registrations
Importing sources for CDC mappings.
Design and develop Informatica workflows, mappings, mapplets and transformations independently, as well as PL SQL functions, stored procedures and DDL scripts to create database objects.
Develop test plans and test scripts for unit and integration testing.
Create Structured Query Language (SQL) and UNIX shell scripts.
Analyze the source systems to identify business rules around data profiling, data flows, data transformations, and data cleansing.
Work with data stewards to resolve data variances and exceptions.
Perform validations against transactional records and make corrections to resolve data quality issues
Participate in code review and recommend solutions to enhance ETL programs to project team and management.

· Participate in developing Source-To-Target Mapping, technical design documents and SOPs