Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Job Description:

Informatica MDM

Raleigh, NC

Long Term

Description
Using the Informatica Master Data Management tool, transform various types of incoming data from source systems;
Profile and analyze extracted data to determine patterns, inconsistencies, and column characteristics;
Apply transformation functions and map extracted data to appropriate staging tables; and
Create various scheduling jobs to automate transformation processes;
Use API software (such as SoapUI) to perform various commands to manipulate and correct data discrepancies to condition the data to be useful in real world scenarios;
Perform operational administrative functions; and
Perform job-related tasks in support of primary support duties including submission of change requests and accomplishment of procedures to open up ports and verify database connectivity, etc.

Primary Skills/Experience
Strong experience with the Informatica Master Data Management (MDM) tool;
Experience with other Informatica product(s);
Strong database experience in any or all of the following databases:
    Oracle;
    SQL Server;
    Teradata; and
    DB2.
Strong Informatica ETL coding experience;
Extensive experience with Red Hat Linux shell scripting;
Knowledge of/exposure to installation of Informatica or other off the shelf products;
Ability to profile and analyze source data to determine patterns, inconsistencies, column characteristics;
Ability to apply transformation functions to source data and map the data to appropriate staging tables;
Ability to research tool and platform-related problems and document/articulate appropriate resolutions; and
Experience with any or all of the following tools/technologies is a plus: