Kamlax Global Technologies Hiring! Full Time SQL Developer in Federal Territory - Ricebowl

Experience: 5+ years

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 modelling 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

Category Details : SQL Development & Support

• Facilitate MFRS 17 and ITSR data aggregation and ensure alignment across systems.
• Develop and optimize scripts for ITSR reports to be published in SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services)
• Assist with data mapping activities related to ITSR.
• Design and setup new database for ITSR reporting purposes.
• Develop and configure scripts for report and file generation to support ITSR and MFRS 17 reporting requirements.
• Perform end-to-end testing for the newly developed databases, scripts, and reports.
• Collaborate with AmMetLife Architecture and Project Teams on the documentation and related activities.
• Analyse, Design and build PMACS to EDS SQL data replication for MFRS17 specific requirements.