Data Engineer - D07 Golden Mile, Middle Road, SG

Roles & Responsibilities

Data Engineer

POSITION OVERVIEW : Industry Consulting Consultant

POSITION GENERAL DUTIES AND TASKS :

Position Summary : Person will be working on :

On-prem : As a Developer to work on new requirement and Change requests in BRAIN COSY project which involves changes to be done either Database Oracle source scripts, PowerCenter Informatica as ETL tool and SQL server as On-prem Database. Healix Migration : to be involved in end-to-end migration activity to migrate the ETL code from PC Informatica to IDMC and SQL Server to AWS RDS SQL Server. Involves the SFTP process to transfer the files and also PGP encryption for the files. Identify business needs :

• Collaborate with stakeholders to understand business needs and information management requirements across all systems, platforms and applications
• Identify users’ information seeking behaviour
• Determine inter-system interface design based on requirements.
• Recommend types of data needed to measure and predict outcomes
• Oversee the development of design and specification proposals
• Guide feasibility and functional studies
• Influence integration of data from across the enterprise
• Set guidelines for appropriate structuring and enrichment of data

Design information architecture

Develop information systems

Analyse Data

Guide implementation

Requirements / Qualifications :

Informatica PowerCenter - 8 to 10 years

Database RDMS Oracle - 7 to 8 years

Database RDMS Sql Server - ? 5years

OBIEE Reporting tool – Preferred

Tableau – Preferred

AWS IDMC, S3, EC2 – Preferred

AWS RDS – Preferred

Databricks - Preferred

Tell employers what skills you have

Tableau

OBIEE

RDS

Oracle

Data Analysis

AWS

Informatica

ETL

Data Quality

Databricks

Data Design

EC2

SQL

SQL Server

Data Architecture

S3

Linux