Job summary:

Job description:

*** Webcam interview; long term project; initial PO for 1 year with multiyear extensions ***Remote*** 35 hours per week; need 3 references

Description:

DATA CLEANSING REQUIREMENTS:

• Data analysis
• Data cleansing
• Data conversion

This includes the following:

• Providing review of the System Integrator s Data Cleansing
• Recommendations of signoff and oversight of the Data Cleansing work performed by the System Integrator.
• Attending the PAS design sessions to provide input on data requirements and limitations.
• Gain insight to support the design transformation process.
• The data team meets individually on their own design process multiple times per week with the system integrator, as well as Fund internal meetings to accomplish related responsibilities.

Consultant(s) / Vendor requirements are below:

• Provide a written deliverable- the Data Cleansing Approach Document, describing the methods to be employed, as appropriate, to correct, reformat, standardize and/or eliminate data elements. The Approach document will describe the process of gaining the Fund s approval of the proposed solution for each data issue prior to correction. It will also clearly identify the activities expected of the Fund s staff in the cleansing effort and describe the Quality Assurance/Audit method to ensure accuracy and traceability.
• Provide data correction and cleansing in the existing source data prior to migration, as well as corrections during the data conversion process.  Eliminate unnecessary data records.
• Identify and correct inaccurate data.
• Merge duplicated data where appropriate.
• Reformat and standardize data from the legacy system so that it can be converted.
• Determine how to gather the information that does not exist in any legacy system but is required in the new PAS.
• Provide scripts which will correct the extracted data from the legacy data sources, if needed, and place the data into a staging database, as applicable and appropriate.
• Conduct ongoing data validation against all identified data sources during the cleansing process.
• Develop and publish Data Cleansing Directives.
• Conduct Data Cleansing Analysis.
• Provide a written deliverable- a Data Cleansing/Conversion Audit Report

Skills

• 6 years experience
• any Oracle certification

Contact the recruiter working on this position:

The recruiter working on this position is Mahesh Kodur(Raghu team)
His/her contact number is
His/her contact email is kmahesh@msysinc.com

Our recruiters will be more than happy to help you to get this contract.