Required Skills

ETL

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 11th Nov 2022

JOB DETAIL

 

Job Responsibilities

o Participate in full software development life-cycle from requirements gathering, estimating, design, development, and implementation

o Developing CDC mappings and experience using number of transformations like Expression, Reusable Sequence Generator, Java transformation, Router, Update Strategy, Filter and

o Developing Source and Target systems like SAP source systems, Oracle database system and flat files.

o Using Informatica Power Center, via Informatica Power Exchange

o Experience on Change Data Capture and Real Time support from Mainframe, SQL Server, and Oracle database sources.

o Experience in Power Exchange registrations

o Importing sources for CDC mappings.

o 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.

o Develop test plans and test scripts for unit and integration testing.

o Create Structured Query Language (SQL) and UNIX shell scripts.

o Analyze the source systems to identify business rules around data profiling, data flows, data transformations, and data cleansing.

o Work with data stewards to resolve data variances and exceptions.

o Perform validations against transactional records and make corrections to resolve data quality issues

 

Company Information