ETL Developer

  • Job Category
    Information Technology
  • Job level
  • Contract type
  • Location
  • Salary
    S$6500 - S$8000

Job Description

Years of Experience

At least 5 - 10 years’ experience in developing, implementing and maintaining IT systems

Position Summary / Project Description

ETL (Informatica BDM/DEI) with Data Model experience. He/she will co-lead ETL developers.

Role and Responsibilities

(a) Involve in various stages of the systems development life cycle; adopting waterfall, agile or hybrid development methodology.

(b) Performs analysis, design and development of ETL processes to support project requirements

(c) Design and develop complex Informatica ETL mappings, sessions, workflows and maintain existing ETL/data warehouse processes.

(d) Prepare technical design specifications based on the projects and change request assigned.

(e) Conduct system integration testing and create test cases to ensure data quality prior to implementation.

(f) Resolve issues raised during user acceptance testing.

(g) Evaluate potential technical solutions and make recommendations to resolve business problems.

(h) Work with business partners during system implementation and manage post implementation support.

(i) Provide on-going support (24x7) to various applications running in the data warehouse if required.

Technical Skills:

ETL: Informatica Data Engineering Integration/Big Data Management, Informatica Powercenter, SAP BODS

Business Intelligence: Oracle Business Intelligence (OBIEE), Tableau

Databases: Oracle, Microsoft SQL Server, Teradata

(a) Degree in Computer Science, Information Technology, Computer Engineering or equivalent.

(b) Technical skills in order of priority: Informatica BDM/DEI, Informatica PowerCenter, Strong SQL, Oracle, SQL Server and Teradata Experience.

(c) Minimum Seven (7) to eight (8) years’ experience in ETL Development and Data Integration.

(d) Strong analytical and problem solving skills.

(e) Strong understanding of ETL Development best practices, strong understanding of Data Lake and Warehouse Concepts, Performance Tuning in SQL and Informatica

(f) Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.

(g) Outstanding ability to communicate, both verbally and in writing.

(h) Ability to develop complex mappings and workflows in accordance with requirements

(i) Exposure to hospital information / clinical systems is an added advantage.

(j) Experience in using business intelligence tools (e.g. OBIEE, Tableau, etc.) is an added advantage.

(k) Experience in Vendor Management is an added advantage.

Closing on 12 Nov 2021