Epicareer Might not Working Properly
Learn More
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)