This site uses cookies. To find out more, see our Cookies Policy

IT Developer, Analytics/ BI in Singapore at Great Eastern

Date Posted: 10/30/2018

Job Snapshot

  • Employee Type:
  • Location:
  • Date Posted:
  • Job ID:

Job Description

Job ID: 000794

Job Purpose

  • To support development and maintenance of enterprise data warehouse on Netezza PDA.
  • To be part of new initiatives that bring data into the EDW as well as establish new data marts.
  • To perform production support and maintenance of existing datamarts in EDW.

The Job

  • Design; develop ETL jobs based on requirements and data mappings from source to EDW and to Data marts.
  • Perform Data Collection, cleansing, transformation and loading into EDW and Data Marts.
  • To perform batch production support.
  • Understand the goals and risks associated with technical and business requirements and align data solutions accordingly.
  • Involve in performance tuning of SQL and keep the EDW and Data marts functioning optimally.

Job Requirements

Our Requirements

  • A Bachelor’s degree in IT
  • Min 8 years’ experience in Data Warehouse / Data Marts.
  • 6 years of experience in Datastage
  • 3 years of Netezza experience
  • Hands-on experience with ETL tool - Data Stage with FlatFiles (Unix Environment) is a must.
  • Proficient in developing Datastage parallel jobs and shell scripts.
  • Proficient in SQL to design datamarts in Netezza.
  • Familiar with Data Modeling/Mapping, Data Architecture and Integration.
  • Should be well versed with all BI and DWH concepts and architecture.

To all recruitment agencies: Great Eastern does not accept unsolicited agency resumes. Please do not forward resumes to our email or our employees. We will not be responsible for any fees related to unsolicited resumes.