Data Quality & Migration Consultant
Malomatia
Total years of experience :9 years, 9 Months
Ministry of Municipality & Environment and Ministry of Finance.
•Key Responsibilities includes Data Modeling, Data Unification, Data Assessment, Data Profiling, Data Quality, GAP Analysis, Data Cleansing, Data Migration Procedures Development and Testing
•Subject areas include Beneficiary Management, Entity Resolution, Contact Management, Reference Data Management, Master Data Management, Record Linkage and Data Matching
•Identify and explore the legacy data structure/design and business workflows
•Understand the target system design and business requirements
•Merge different data sources into single data source
•Design legacy data structure document consists all technical details of Data Set
•Perform Data Profiling by using PL/SQL and Python libraries like Pandas, Pandas Profiling and Dedupe.
•Review Data Profiling\Legacy Landscape reports with Client/IT SPOC’s
•Perform Data Cleansing based on the policies made by Data Governance Board
•Data Cleansing including (Entity Resolution for Contacts, gathering Qatar QID through different data sources)
•Perform Unit Testing on Data Conversion and Cleansing outcomes
•Prepare Data Mapping document to map business fields & LOV’s between legacy and new system after unifying LOV’s if available across different data sources
•Develop and execute Data Migration Program written in PL/SQL
•Validate Data in target application
•Write API’s to perform Data Integrations between source and target system by using PL/SQL
•Work independently and responsible for end to end Data Migration Process in collaboration with business users and IT SPOC’s.