Ms SQL Developer - Singapore - Horizon Corp

Horizon Corp

Verified Company

Singapore

1 week ago

Posted by:

Wei Jie

beBee Recruiter

Role - MS SQL Developer

Location - Singapore

Duration - Long term contract

Job description

To enhance and develop projects/Change Requests related changes and to ensure deliverables are in good quality
To develop functionalities to cater for business requirements using Unix/PLSQL
To design and build the Control-M jobs for batch processing
To carry out unit testing and SIT on the developed functions
To support UAT cycle, troubleshoot the issues and provide bug fixes
To raise remedy ticket for required changes in controlled environments
To migrate deliverables objects using Aldon migration tools to UAT/Production environment
To provide proper documentation for all the deliverables
To ensure the design & build is in line with the standard and all deviations are clearly articulated and agreed. The scope should be from sourcing from upstream till the final report generation
Review the code to ensure it does not break / Lead to performance issue
Prepare necessary documents to facilitate and deliver the project (Release checklist, UAT results, etc.)

Requirements:

Good understanding in SDLC phases
Working experience of CRS reporting
Capability in requirement analysis and functional design skills
Capability of selflearning and a quick learner
Be adaptable, flexible and be able to thrive in a challenging, fastpaced of a growing organization / environment
Experience with project management best practices/ methodologies/ project lifecycle
Developer experience in SQL Server. Strong knowledge on MS SQL developer and should be able to write sql queries
Good knowledge of SQL database
Proficient with Batch & Power Shell scripting
Good understanding in Data Warehouse and Data Mart concept
Experience in Performance tuning of queries
Good knowledge on SSIS & SSRS
ETL transformation & Reporting purposes