Chào bạn,

Đăng nhập xem việc làm phù hợp

Senior Data Warehouse & Cloud Specialist

FE CREDIT

3B Floor, Ree Tower, 9 Doan Van Bo, Dist. 4, HCMC

Ngày đăng: 12-11-2020

  • Kinh nghiệm

    4 - 0 Năm

  • Cấp bậc

    Trưởng nhóm / Giám sát

  • Lương

    Cạnh tranh

Mô tả Công việc

OBJECTIVE:

Senior Data Warehouse Management Specialist will be instrumental in enhancing and creating Data Warehousing Applications throughout responsible for the documentation, production support/troubleshooting, and the release of multiple new initiatives.

COMMUNICATION:
Internal:
IT, Reporting, Data Mart, IT Projects Team and other related business units in VPB FC - Business interaction involving the operating IT systems to retrieve database as well as ensure database quality, Coordinate with related business units to ensure the team’s work run smoothly

External: Vendors/ outstaff - Coordinate and work with vendors who in contracts with VPB FC/ outstaff in term of systems/ take over/ solution related to data warehouse management

KEY RESPONSIBILITIES:

  • Responsible for design, model and implementation of data warehousing activities like understanding all sources, getting data from the sources to the warehouse etc. Designing Datastages Sequences (a set of Datastage jobs in order) for expected data flows across source systems DB to EDW Cloud
  • Program and configure database information and provide support to warehouse users
  • Work with ETL Architect to define standards and procedures; refine methods and techniques for data extraction, transformation and loading (ETL).
  • Define robust well documented ETL design which is easy to understand and performs well
  • Design an efficient ETL job scheduling mechanism
  • Evaluate, determine root cause and resolve production issues. Identifying the long and high resource consuming ETL processes in the Datastage Server and Database Server. Then, investigating the root cause and resolving them. Tuning Datastage jobs or inefficient SQL scripts to resolve issues of bad performance.
  • Adopt usage of change and issue management tools such as Jira.
  • Work closely with other IT development groups to deliver coordinated software solutions
  • Identify and automate ETL processes to achieve high efficiency such as data re-conciliation, data availability alerts publication etc.
  • Scheduling Datastage Sequences to ensure the data which is required by BU available on time as SLAs.
  • Reviewing and Audit Cloud Batches using Datastage Web Console and Real Time SQL Monitoring of SQL Developer
  • Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases in cloud
  • Develop EDW Cloud data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Undertake other tasks assigned by Unit Head of Data Warehouse Management

Yêu Cầu Công Việc

  • University Graduate, major: Computer Science, IT or Business Management
  • At least 5 years’ experience working in Data mart/warehousing project, preferably working in Financial Services sector
  • Knowledge of Oracle Cloud Infrastructure basics ( ~ How ETL application works and interacts with other modules / other applications in Oracle cloud, ~ how to monitor the running processes in Oracle cloud)
  • In depth understanding of ETL & DW processes
  • Hands on experience with database and ETL technologies (IBM Netezza, Oracle, IBM Data Stage and SAS Enterprise Guide)
  • Expert command on PL-SQL & UNIX scripting
  • Basic understanding of the normalized and dimensional data modeling skills
  • Strong verbal & written communication skills • Strong time management skill
  • Ability to work under pressure

Thông tin khác

  • Hình thức: Nhân viên chính thức

Kỹ năng bạn nên có

Nộp hồ sơ ứng tuyển:

Thông tin liên hệ của bạn

Hồ sơ của bạn

Upload hồ sơ (Chỉ hỗ trợ định dạng *.doc, .*docx, *.pdf và dung lượng < 3 MB)

FE CREDIT

We were founded as Consumer Finance Division of Vietnam Prosperity Joint-Stock Commercial Bank (VPBank). In 2015, we successfully transferred to an independent company with the Brand FE CREDIT. Since then, we continuously have been enlarging and taking the leadership of consumer finance market in Vietnam. Our success is built on serving the best sake of our customers; we are keen on designing new products with add-on values to customers with our philosophy of Fast and Easy.

We have long nourished the determination to professionalise our operations. We embrace a strong organisational culture with a shared aspiration and values which allows us to act as a united and focused company.

FOCUS – UNITY – SIMPLICITY – OWNERSHIP

3B Floor, Ree Tower, 9 Doan Van Bo, Dist. 4, HCMC

https://career.fecredit.com.vn/

Qui mô công ty: 10.000 - 15.000

Người liên hệ: Vũ Thế Quang

Xem thêm việc làm