• Competitive
  • Singapour, Singapore
  • CDI, Plein-temps
  • OCBC Bank
  • 2018-06-22

Business Intelligence (SAS and Hadoop) Analyst - (BAU Support)

Business Intelligence (SAS and Hadoop) Analyst - (BAU Support)

The BI specialist will be a techno functional support team member for the Business Intelligence cluster under IT BAU team . He/she is responsible for ensuring system availability and timely deliverables for BI applications like SAS and Hadoop. The BI specialist, as the admin cum analyst expert within the IT team, will be the support staff who needs to closely co-ordinate and work with various team like Tech Infra, application services, solutioning, project and Business units in bank. He/she follows up to resolve issues reported by users and performs impact analysis on projects/enhancements that will impact the BI applications. This role is based in Singapore.

Roles/Responsibilities
  • Contribute to business requirement review for technical implementation as a subject matter expert for IT to ensure SDLC standards are met
  • Translate user requirements into functional and technical solutions for technical design team and developers
  • Conduct review of technical and functional solutions from enhancement/project team to ensure they conform to IT standards
  • Respond to and resolve issues by finding the root cause of the problem
  • Respond on time to the queries raised by various business units
  • Provide timely updates regarding production status and progress of issue resolution
  • Perform impact analysis of enhancements/projects that will impact supported systems
  • Responsible to provide BAU support for BI platforms SAS and Hadoop
  • Responsible to provide BAU support for financial fraud surveillance system in bank
  • Responsible to provide operational support and ensure SLI of system availability, online and batch deliverables.
  • Responsible for development, administration and troubleshooting on Hadoop technologies like HDFS, MapReduce, Hive, Sqoop, HBase, Kafka, Spark, etc.
  • Responsible to Monitor, Administrate and manage the Cloudera CDH Hadoop cluster in the bank
  • Fine tune applications and systems for high performance and higher volume throughput


Qualifications
  • Preferably 5 years of relevant experience in IT Finance within a banking/financial services industry
  • Experience in Financial Fraud Surveillance modules like SAS-ESP or Mantas is a must
  • Experience with Hadoop and SAS required
  • Experience in SAS tools Base SAS, Enterprise Guide, Data Integrator, Enterprise Miner, SMC are required
  • Experience with Hadoop Ecosystem including Spark, Storm, HDFS, Hive, HBase and other NoSQL databases
  • Familiar with programming paradigms such as distributed architectures and multi-threaded program design
  • Understanding Partitions, Hive Query optimization, Bucketing etc.
  • Experience in Sqoop for moving data between RDBMS and HDFS
  • Solid understanding of BigData, Datawarehousing, DataLake, Teradata, Oracle or other relational databases required
  • Has working knowledge in Unix/Unix scripting
  • Knowledge of .NET, Python, Scala, and Java programming and development experience a plus
  • Experience with MQ technologies (TIBCO EMS, Kafka, RabbitMQ) is a plus.
  • Understanding of ETL design using ETL tools or native scripts to extract data from heterogeneous data sources strongly preferred
  • Incident, problem and service outage management
  • Data Source Configuration and Maintenance
  • Experience with additional Business Intelligence tools a plus
  • Experience in developing dashboards and reports required
  • Strong system and application administration knowledge required
  • Experience building data visualization to user specification
  • Server Performance, capacity, utilization monitoring and Health monitoring
  • Strong analytical and statistical knowledge preferred
*LI-CY
Singapour, Singapore Singapour Singapore SG