Asia Commercial Bank - ACB

Overview of job

Designing, creating, and executing the process of ETL (Extract, Transform, Load) to the Data Warehouse system, ensuring on-time & reliable data source providing, serving management needs, and business operations of the bank.

MAIN RESPONSIBILITIES:

+ Receiving and understanding business requirements
+ Examine, analyze and evaluate source data
+ Do the mapping source data with Data Warehouse
+ Design, build, execute, and manage the data extraction process.
+ Design, build, and execute periodically & Adhoc reports
+ Compare & checking the data
+ Hand over source code, and jobs to extract data to Operation Department
+ Join IT project and perform assigned tasks within the project scope
+ Perform other tasks assigned by the team leader
+ Hand over source code, and jobs to extract data to Operation Department
+ Join IT project and perform assigned tasks within the project scope
+ Perform other tasks assigned by the team leader

1. Educational Qualifications
Graduate majoring related to IT or MIS

2. Relevant Knowledge / Expertise
Knowledge of banking (products, services, processes,..)
Knowledge of MIS, Data Warehouse
Knowledge of database management and data mining
Knowledge of Data Models, Dimensional Models
Proficient programming languages: C#, VB.NET, SQL, PL / SQL, Visual Fox
Proficient Database: Oracle, SQL Server, Visual Fox, MS Access
Proficient ETL tools: DataStage, SSIS, ODI, Informatica…
Can use Data Modeling tools: Erwin, Power Designer…

3. Skills
Foreign language: English (can read documents and communicate)
Skills to use the support software: Microsoft Office, Microsoft Project ...
Communications Capability
Problem Solving Capability
Skills to collect, filter, analyze and evaluate information.
Ability to teamwork

4. Relevant Experiences
At least 02 years of working experience in banking data processing or related fields in MIS,
Data Warehouse

5. Personal Characteristics
+ Willing to learn more, and adapt quickly to new things
+ Proactive, hard work, careful, patient, and friendly.