Hello,

Sign in to find your next job.

Senior Data Warehouse & Cloud Specialist

FE CREDIT

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

Posted date: 12-11-2020

  • Experience

    4 - 0 Years

  • Job level

    Team Leader / Supervisor

  • Salary

    Competitive

Job Description

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

Job Requirement

  • 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

More Information

  • Working time: Permanent

You should be skill

Apply for:

Your Contact Information

Your resume

Upload resume (Only supports *.doc, .*docx, *.pdf and less than 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/

Company size: 10.000 - 15.000

Contact person: Vũ Thế Quang

View more