Data Warehouse Support Engineer - Singapore - ANTAS PTE. LTD.

ANTAS PTE. LTD.

Verified Company

Singapore

2 weeks ago

Posted by:

Wei Jie

beBee Recruiter

Description

POSITION OVERVIEW :
Datawarehouse Support Engineer (EDW)

POSITION GENERAL DUTIES AND TASKS:

The support specialist will be a techno functional support team member for the Enterprise Datawarehouse (EDW) under IT BAU team.

He/she is responsible for ensuring system availability and timely deliverables for datamarts for various business unit like Finance, regulatory, Campaign.

Roles/Responsibilities

Responsible to provide BAU support for Enterprise Datawarehouse
Responsible to provide operational support and ensure SLI of system availability, batch deliverables
Respond on time to the queries raised by various business units
Provide timely updates regarding production status and progress of issue resolution
Conduct review of technical and functional solutions from enhancement/project team to ensure they conform to IT standards
Perform impact analysis of enhancements/projects that will impact supported systems
Identify the underlying problems, analyse the root causes, provide possible solutions/fixes, and respond to users within SLA
Support relevant software/platform/database upgrade for the systems
Work with delivery team for smooth transition from projects/enhancements to BAU Mode
Incident, problem, and service outage management experience
Participate in Disaster Recovery and Business Continuity exercises
Able to support relevant software/platform/database upgrade for the systems
Server Performance, capacity, utilization monitoring and Health monitoring
Collaborate with diverse cross functional teams within IT and Business to Independently drive outcomes
At least 3+ years of relevant experience in banking/financial services industry
Experience with Teradata FSLDM and data mapping
Handson technologist, strong in SQL, UNIX and Teradata tools and technologies
Experience in designing high throughput fault tolerant data pipelines for Batch (ETL/ELT)
Experience in GL Data reconciliation between systems, datamarts & report and Knowledge of the ledger balance reporting is an added advantage
Experience in Performance Tuning on Teradata or other MPP data pipeline
Hands On Experience within the Hadoop Tool Sets Hive, Hue, Spark, Kafka is a plus