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