This role provides regulatory data analytics using data from different geography. The primary responsibilities would be:
- Prepare Data model for Risk and Finance Data
- Support Source to Target transformation team(ETL)
- Coordinate with Data analysis team to prepare Logical data model Conceptual data model
- Prepare physical data model
- Perform model creation for large set of data which are being sourced to Big Data
Essentials
Expert in ETL (Extract Transform Load) development
Hands on experience in Big Data, HIVE, Pentaho (ETL Tool) architecture
Data Extraction from Teradata, HIVE, Oracle, and Flat files
Experience in Creating Mappings, Mapplets, and Transformations for loading Target tables
Desirable
- The successful candidate is expected to have a good working knowledge and delivery experience preferably within a Banking MI and Data Risk systems environment.
- Demonstrated ability to multi-task and work independently, as well as work collaboratively with other teams, some of which may be geographically distributed.
- Proven problem solving and analytical abilities including the ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details and apply sound business and technical domain knowledge.
- Knowledge of the reporting approaches to Risk Management Information.
- Experience of large global system infrastructure projects a business change environment and good understanding of data infrastructure and architecture would be an advantage. The latter may include exposure to solution or enterprise architecture.
- Experience of process re-engineering and process management.
- Knowledge of BCBS239, IFRS-9, Stress Testing or experience of any other Banking regulatory environment is a big plus.
- Communicate openly and honestly. Advanced oral, written and visual communication and presentation skills - the ability to communicate efficiently at a global level is paramount.
- Ability to deliver materials of the highest quality to management against tight deadlines.
- Ability to work effectively under pressure with competing and rapidly changing priorities