
Software Developer
RM 13,000 - RM 15,999 / month
Checking job availability...
Original
Simplified
SKILL SET 1. Experience using SQL (Structured Query Language) to interact with the database, including querying, updating, and managing data 2. Experience in conceptualizing and implementing structure of a database. Understand how to organize data and define tables, columns, data types, and relationships between tables. 3. Experience in data modeling techniques such creating a visualization of the data and its relationships within a database. And also involve defining how data is connected and how it will be stored and accessed. 4. ETL (Extract, Transform, Load) experience. Experience in extracting data from different sources, transforming it into a suitable format, and loading it into a database or data warehouse 5. To rewrite existing SQL code to optimize database performance 6. To debug stored procedures or view via the SQL Server Management Studio, allowing you to rectify functional issues JOB SCOPE No Category Details 1 Data Ingestion a. Able to import/export data from • Database to Database • Manual files file to Database b. Import Data as per the format and then transform the imported data into the required format. c. Able to keep ingesting data and mark latest copy while keeping data grouped and archived even with multiple re-runs 2 Data Tabulation Able to generate SQL Scripts and logic in order to a. Classify all required values from different sources b. Calculate all the required values according to the formula table c. Able come out with logic to tabulate values and to come out with reports on the basis of data values and availability in multiple sources of data. 3 Data Reconciliation and Reporting a. Able to come out with logic to perform data validation. To set the ‘engine’ to assist on the validation. b. Able to product reports for all parameter items. 4 File generation a. Able to generate Output data file from the database as per Bank Negara data specification document b. Able to generate exceptional report to check on any duplicate values. 5 API development a. To have both application development and database experience b. To develop an application and connect establish connectivity with Bank Negara API as per the specification c. Experience in OAuth Access Token d. Able to store all variable configurations in a config. file e. Able to store all the inbound and outbound information sent and received from BNM in the database f. Experience in building logics to ensure the following items : • To check on required status before sending any data to BNM • Auto resend the data to BNM after fail response o Number of tries (set a limit and internals) • Able to log the response from BNM and notify users with an email. g. To ensure the all the tracking is logged in daatabase so that when the application can be killed and restarted to continue where it left off.