HO - ETL Specialist

Designing, creating, executing the process of ETL (Extract, Transform, Load) to the Data Warehouse system, ensuring on-time & reliable data source providing, serving for management needs, 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, execute periodically & Adhoc reports

- Compare & checking data

- Hand over source code, 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, 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.

REQUIREMENTS:

1. Educational Qualifications

Graduate majoring related to IT or MIS

2. Relevant Knowledge / Expertise

Knowledge of banking (products, services, process,..)

Knowledge of MIS, Data Warehouse

Knowledge of database management and data mining

Knowledge of Data Model, Dimensional Model

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, Infomatica…

Can using 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 working experience in banking data processing or related fields in MIS,

Data Warehouse

5. Personal Characteristics

Willing to learn more, adapt quickly to new things

Proactive, Hard work, careful, patient, friendly.