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 WarehouseKnowledge of database management and data miningKnowledge of Data Model, Dimensional ModelProficient programming languages : C#, VB.NET, SQL, PL / SQL, Visual FoxProficient Database : Oracle, SQL Server, Visual Fox, MS AccessProficient 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 CapabilityProblem Solving CapabilitySkills to collect, filter, analyze and evaluate information.Ability to teamwork4. 4. Relevant Experiences
At least 02 years of working experience in banking data processing or related fields in MIS,Data Warehouse5. 5. Personal Characteristics
Willing to learn more, adapt quickly to new thingsProactive, hard work, careful, patient, friendly.