[AIT] Production Support Analyst (Data Warehouse) (MAX 3879)

Location: Singapore
Salary: 7000 to 9000
Contact email: careersrise@bcg.com
Job ref: MAX 3879
Published: 24 days ago
Startdate: 20 May 2024 - 20 May 2024

​Job Title: Production Support Analyst (Data Warehouse) (MAX 3879)

Work Location: Central

Contract Type: 12 months contract

Headcounts: 1

Monthly salary: $7000 - $9000

Role: Production Support Analyst

Job Level: 3-5 years of relevant experience (L2)

Job Description

Support Analyst (Data – Datawarehouse) Singapore

Key Skills:

Unix/Linux, BI Tools (QLK/SAS/Power BI) Oracle, AS400, Informatica 9.x or 10.x,

Job Objectives

The Data Application Support team is within the Business Technology Services function, supporting the Bank’s suite of Data warehouse, ETL, BI and Big Data Application Systems. The team is responsible for the production stability of these applications and ensuring on going improvements in system availability, supportability & service levels over time.

The successful candidate will be working with Business, Support and Development teams to ensure a high quality service & swift resolution of issues

Key Responsibilities

· Provide application support to various business users. Attend to business queries and business requests promptly. Follow through the business requests to a proper closure

· Work on timely resolution for reported incidents so as to meet service level targets. Incidents include failures & queries reported by business users and technical staff; event alerts automatically detected and reported by event monitoring tool

· Perform root cause analysis to identify permanent solution so as to prevent recurring incidents and to minimize the impact of incidents that cannot be prevented

· Ensure all incidents and problems are proactively managed – Prioritizing numerous issues of varying severity and escalate issues as appropriate to necessary teams and management

· Collaborate with the development team in identifying resolutions and transitioning of releases into production environment

· Participate in BCM activities or infrastructure related upgrade

· Responsible of capacity management. To monitor & analyse current performance and capacity data and forecast the capacity required by the applications ahead

· Aside from day-to-day support duties, there will be requirements to undertake other

responsibilities such as management reporting & other centrally driven project initiatives as needed

Key Requirements

· Degree in computer science/engineering or related disciplines.

· Min 4 years of experience in application development and support environment in ETL, Data warehouse, and business intelligence

· Individual must have working experience in ETL, Data warehouse and various business intelligence tools on Unix/Windows platforms.

· Mandatory Technical skills : Informatica (Infra and data workflow tracing), BI Tools such as QLK, SAS, Power BI, Oracle, Unix/Linux, AS400, Control-M, Shell scripting

· Knowledge of ITIL of similar framework will be advantage

· Experiences in Quantexa, Teradata, Big Data using Cloudera (CDH 5.8 or above), Hive, Impala, HDFS, YARN, Sqoop, Oozie, Hbase, kafka, Map Reduce/Spark are optional and good advantageous

· Excellent communication, interpersonal and analytical skills

· Excellent knowledge of banking business data across various sectors

· Excellent & proven Incident/Problem Management and organization skills a must