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.

• 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

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, Informatica…
• 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 of 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.