 Design and develop SSIS ETL packages to process, transform, and deliver data as required.

 Provide support for SIT, UAT, DRH and Prod deployment.

 Collaborate with co-consultants and BAs regarding project details and requirements.

· Design, develop and enhance SQL scripts for data transformation

· Design and develop ETL packages (file to table, table to table data load)

· Collaborate with co-consultants and clients/users regarding project details and resolution.

· Perform end-to-end SIT (ETL – SSIS packages, Report – Microstrategy Dashboard)

· Support UAT; analyse issues, fix bugs/defects, resolution verification, provide status report

· Involve in rotational weekly rooster for providing daily batch job status and log OSS tickets

· Create and enhance Talend jobs

· Design, develop and enhance SQL scripts for data transformation for CCRIS

· Design and develop ETL packages (file to table, table to table data load) for CCRIS

· Support CCRIS’ monthly submission to Bank Negara Malaysia

· Exercise critical thinking to resolve several errors encountered in data submission of CCRIS

· Exercise critical thinking to resolve several errors encountered during UAT for CCRIS enhancement program

· Evaluated and implemented resolution needed to address user requests (enhancements, major/minor issues) needs issues

· Collaborated closely with upper management to drive strategy through development and implementation of new processes

· Improved CCRIS submission by enhancing and automating process

· Assessed business needs and problem areas to create focused solutions like automation of manual processes

· Create Functional Design, Technical Design, and Field Mapping Documents.

· Formulate and optimize SQL scripts imbedded into SSRS or SSIS for better performance.

· Participate in team project discussions. Create reusable presentations, facilitate knowledge transfer and system roll-out to team members.

· Create component test plan and perform component test execution.

· Create pre-deployment and deployment checklist. Support pre-deployment, UAT, deployment and stabilization activities.

· Monitor batch jobs via Control-M and report generation thru SSRT.

· Participate in post mortem sessions to discuss the highlights of the project.

· Create Functional Design, Technical Design, and Field Mapping as well as guideline documents to be used by team in future initiatives or projects as reference.

· Create and design ETL interfaces with MSBI – SSIS.

· Formulate easy to complex SQL scripts for ETL interfaces.

· Coordinated with multiple support teams to evaluate and improve issues related to delayed execution of reports, deployment of components into Staging and Production.

· Contributed ideas and suggestions in team meetings with the team and delivered updates on deadlines, designs and enhancements

· Mentor junior engineers and new hires to better improve competency and efficiency of all staff

· Develop useful and reusable interfaces in transforming data needed by stakeholders for report and analysis

· Monitor job executions via WCC and report generation thru SSRT subscriptions.

· Perform Component Test Execution.