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. 1. Educational Qualifications
Graduate majoring related to IT or MIS
2. 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. 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. 4. Relevant Experiences
- At least 02 years of working experience in banking data processing or related fields in MIS,
- Data Warehouse
5. 5. Personal Characteristics
- Willing to learn more, adapt quickly to new things
- Proactive, hard work, careful, patient, friendly.