T
Oracle Hadoop ETL Developer - Banking Sector
RM 9,000 - RM 13,000 / month
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Original
Simplified
Oracle Hadoop ETL Developer.
Experience:
- 6+ years’ experience in ETL Development.
Skills:
- Hadoop (Hive or Impala)
- Oracle Data Integrator (ODI)
- Shell Scripting.
Job description:
- Understand & Interpret upstream and downstream data flow, do data profiling, data mapping and check data quality from source to target.
- Perform impact analysis of new systems, new interfaces & integration. Work on impact analysis to reference data (domain/dimension; data elements/properties; base members/data sets; hierarchies) to ensure compliance with Data Governance principles.
- Implement high-quality solutions by translating business requirements into integration specifications, working with ETL developers to oversee the implementation of ETL designs.
- Responsible to develop ETL architectural and design patterns, considerations, solution options, and impact.
- Design, develop, and implementation ETL solutions using ODI v12.2.1.4 tool.
- Ability to analyse, map, transform, and transfer data between varieties of data formats.
- Experience in writing PL/SQL, stored procedures, views, and optimizing database queries
- Ability to conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues.
- Facilitation and definition of reporting and analytics business requirements.
- Provide post-production batch support.
- Conduct unit test, SIT, and provide UAT support.
Functional Skills:
- Banking domain experience.
Technical Skills:
Hands-on experience on:
- Oracle Data Integrator (ODI v12.2.1.4)
- Oracle Big Data Appliance (CDH v6.3.4)
- SQL Query (Hadoop) – Intermediate / Advance
- Oracle – PL/SQL, SQL-Loader.
Ideal to have but not pre-requisite:
- Unix AIX basic command & shell scripts
- ASG-ZENA (Job scheduler).
Job Type: Full-time
Pay: RM9,000.00 - RM13,000.00 per month
Experience:
- Banking Sector: 2 years (Required)
- ETL Development: 2 years (Required)
- Hadoop (Hive or Impala): 3 years (Required)
- Oracle Data Integrator (ODI v12.2.1.4): 3 years (Preferred)
- Oracle Big Data Appliance (CDH v6.3.4): 3 years (Preferred)
- SQL Query (Hadoop) – Intermediate / Advance: 3 years (Preferred)
- Oracle – PL/SQL, SQL-Loader.: 3 years (Required)
- Unix AIX basic command & shell scripts: 3 years (Preferred)
- ASG-ZENA (Job scheduler).: 3 years (Preferred)
Similar Jobs