Phumla Q.

DATA PROFILING • Analyzing Business and Technical processes • Reviewing and identifying master data from various source systems • Creating ERD documents that display data flow and integration • Develop over-all Data Dictionary from ERD's, Creating high-level diagrams for system changes DATA CLEANSING • Identifying data quality issues in the form of reports and DQ dashboards • Creating SQL scripts / stored procedure to provide cleansed data to source system owners for update or backend update ETL • Extract, Transform, and load data using Talend / SSIS / SQL for updates, inserts, deletions, stored procedures on DB • Extract data from API and Transform to desired format. (csv/json/to database) • Develop Rest API using Talend and adding authentication SUPPORT • Providing reports that require Integrated data from our various source systems to Business and Technology • Assisting Call Centre in updating master data in various source systems • Assisting CRM team with backend analytics • Manage and monitor MDM database (Schedule jobs, Clear temporal tables, assist in resolving issues arising) • Assist in identifying how and where data governance can be implemented to preserve data integrity