Data Mart Specialist

OBJECTIVES

Data Mart Specialist will work to enhance and create Data Mart Applications under the guidance of Unit Head of Data Mart. The Data Mart Specialist will also be working on the documentation, production support / troubleshooting, and the release of multiple new initiatives.  

KEY RESPONSIBILITIES

1. Operation

- Schedule ETL objects to ensure complete data availability,runtime and system performance

- Tracking ETL jobs status, find out root cause if error and fix it in time

- Handling issues related to data from local team and others departments

- Receive data requests from local team and others departments

2. New Request

- Work with different stakeholders across divisions to integrate data sources and map data between data warehouses and data marts

- Collaborate with business analysts, modelers & reporting specialists to implement & maintain data transformation successfully, including DQ and standards

- Define complex technical design/requirements for data marts projects

- Collect, analyze, design, support the project implementation according to the defined plan and solution.

- Collaborate with BUs to assess impact of changes on downstream with changing data mart design. Incorporate downstream needs in overall design

- Perform necessary tuning of database and ETL systems and objects to ensure timing and performance goals are met. 

- Undertake other tasks assigned by Unit Head of Data Mart.

- Bachelor's degree in computer science, data management or related field

- At least 1 year’ experience working in Data mart/warehousing project, preferably working in Financial Services sector

- Experience in traditional data warehousing / ETL tools (DataStage, MS SSIS, ODI, Talend, Pentaho, ELK)

- Good understanding of ETL & DW processes

- Experience in receiving, analysing and consulting on business

- Experience in traditional RDBMS ( Oracle, MySQL, PostgreSQL,MS SQL Server)

- Interest in Cloud platforms such as: Oracle Cloud, AWS, Azure, Google Platform