Job Description


(JD)

  • Experience in ETL development and implementation.
  • Development & Implementation experience of IBM DataStage Server &
Client Edition version 8.7 and above OR Other ETL tools
  • Experience on Linux/UNIX shell script programming
  • Development experience in SQL / PLSQL
  • Database programming experience in IBM DB2 (an added advantage)
EDW (Enterprise Data Warehouse) ETL developer is responsible to Develop
ETL jobs for projects using IBM Data stage tool as well as using PLSQL store
procedure and Unix/Linux shell scripting.
  • Develop Extract/Transform/Load (ETL) solution using IBM DataStage for
data movement / integration / cleansing and other data processing needs.
  • Develop ELT procedure using PL/SQL.
  • Develop Linux/UNIX shell scripts to manage file movement, table data
housekeeping, email notification of server info and statistic reporting.
  • Develop / perform SQL query extraction in DB2 / SQL DB.
  • Work closely with Modeler, System Analyst and Solution Architect in ETL
solution envisioning / design / development /delivery.
  • Perform unit testing, integration testing and provide support to users in
UAT phase.
  • Monitor ETL job operation, recovery / troubleshooting and performance
tuning.
  • Prepare technical documentation for ETL solutions.
  • Provides reviews of deliverables and identifies gaps /areas for
improvement
  • Identify opportunities to optimize the ETL environment, quality and
validation processes to ensure data accuracy and integrity
  • Analyze and translate functional specifications and change request into
technical specifications
Key Skills / Knowledge and Behaviors (if applicable)
  • Experience in SQL / PLSQL
  • Linux/UNIX shell script programming.
  • IBM DataStage Server & Client Edition version 8.7 and above
OR other ETL tools will be considered.
  • Database programming on DB2 / SQL
  • Banking knowledge will be added advantage

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD892406
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Kuala Lumpur, Malaysia
  • Education
    Not mentioned