Data Profiling and Data Quality Initiative
The U.S. Marine Corps (USMC) maintains a catalog of over 600,000 items for procurement. It is imperative that the information associated with these items is correct so that the downstream systems that consume the information display relevant and confident information to users. To provide this capability, data must be analyzed in both the source system and the transactions that feed the source system.
As part of the data profiling and quality initiative, Data Blueprint:
Utilized Informatica 9 Data Quality Analyst to profile data sets related to item introduction for the USMC
Created mappings inside Informatica 9 Data Quality Developer to produce error staging tables based upon business rules provided by SMEs
Validated and deployed additional mappings inside Informatica 9 Data Quality Developer to automate the creation of remediation transactions