KB PRASAC Bank Plc. (292)

ភ្នំពេញ 1 month ago
Data Warehouse Administration Officer
  • ប្រភេទការងារ
  • ព័ត៌មានវិទ្យា
  • មុខរបរលម្អិត
  • វិជ្ចាជីវៈ​ខាង​ផ្ទុក​ទិន្នន័យ និង​ត​បណ្តាញ មិន​បាន​ធ្វើ​ចំណាត់​ថ្នាក់
  • ទីតាំង
  • ភ្នំពេញ(2)
  • 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.

ឱកាសការងារផ្សេងទៀត