Data Mart Management Specialist (DataStage/ MS SSIS/ ODI/ Talend/ Pentaho/ ELK)

OBJECTIVES: Enhance and create Data Mart Applications throughout responsible for the documentation, production support/ troubleshooting, and the release of multiple new initiatives

COMMUNICATION:

• Internal: IT, Reporting, Data Warehouse, IT Projects Team and other related business units in VPB FC
• External: Vendors/ outstaff

KEY RESPONSIBILITIES

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
• Review and tunning system (jobs, procedure, package, etl process…)

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
• Mentor and help develop technical competency of assigned team members
• Define complex technical design/requirements for data marts projects
• 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.
• Implement best practices within the team

• Bachelor's degree in computer science, data management or related field​
• Experience in receiving, analysing and consulting on business
• Experience in traditional data warehousing/ ETL tools (DataStage, MS SSIS, ODI, Talend, Pentaho, ELK)
• Experience in traditional Relational Database Management System (RDBMS) - Oracle/ MySQL/ PostgreSQL/ MS SQL Server
• Expert command on PL-SQL & UNIX scripting
• Ability with building and maintaining large data sets
• Deep understanding of information security principles to ensure compliant handling and management of client data
• Interest in cloud platforms such as: Oracle Cloud, AWS, Azure, Google Platform
• Ability to work across structured, semi-structured and unstructured data, extracting information and identifying linkages across disparate data sets
• Knowledge of datamart optimization methods and best practices
• Knowledge of datamodel – Financial/ Sales/ Collection and reporting
• Strong time management skill
• Ability in working independently