Data Warehouse Administration Officer

ផុតកំណត់: 31/07/2024

Job Location:

  • Head Office, Phnom Penh

Main Duties and Responsibilities:

  • Manage 24/7 Data Warehouse in Production.
  • Manage data warehouse plan for a product, such as: design data model, define data metric, data governance and so on.
  • Install ETL software for extracting data changes of core banking database, switching database, etc… in real time and loading it in data warehouse.
  • Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures.
  • Monitor ETL Job for data loading in data warehouse.
  • Monitor Job in Control-M.
  • Create SIT test cases SQL queries and scripts test data.
  • Migration of core-banking and channel system data for operating daily and monthly reporting.
  • Consider Data migration of Heterogeneous Databases of data warehouse Areas when MIS database type may be different type of a Core banking DBMS.
  • Monitor data warehouse work and provide subject matter expertise.

Key Selection Criteria and Qualification:​

  • Bachelor’s Degree in Information Technology/Information.
  • At least 1 year of experience in development data warehouse.
  • Knowledge of SQL language.
  • Knowledge in Data mapping on ETL tool.
  • Make a deep relationship with related team.
  • Good communication and documentation skill.
  • Ability to provide 24/7 on-call support.
  • Good in English language, both spoken and written.
  • Good integrity, positive attitude, helpful, high commitment, competence and motivation.
  • Certification in Oracle, SQL Server, PostgreSql, MongoDB, Mariadb.
  • Demonstrated and troubleshooting and administrative skills using ETL, Control-M, Oracle database, SQL Server, PostgreSql, MongoDB, Mariadb.

Interested candidates are requested to fill Employment Application Form and attach the relevant documents including 4X6 photos (01 sheet), family book, birth certificate, National ID card and other diplomas (photocopies only) to the Head Office in Phnom Penh, located at № 212, St. 271, Toul Tumpung 2, Chamkarmorn, Phnom Penh or by E-mail: recruitment@kbprasacbank.com.kh or Scan QR code to Apply.

Note: For more information, please contact via phone: 023 962 062 / 010 739 690. Only shortlisted candidates will be contacted via phone for writing test or interview.

ដាក់ពាក្យ​