Software Developer (MSSQL)

Competencies and Skills

• Bachelor's degree in computer science, information technology or a related study, or equivalent experience

• At least 4-6 years of experience in application development and SDLC processes. 

• Experience in application development and SDLC processes, preferably in a banking environment.

• Experience in project delivery

• Experience working in environments adhering to change management, compliance, and internal audit controls.

Key Responsibilities

•Solution Development and Customization

• Design, develop, and maintain applications within the Ambit Focus ecosystem.

• Develop data extraction, transformation, and reporting processes from Ambit Focus.

• Customize and configure Ambit Focus screens, workflows, forms, and reports.

• Collaborate with business users, analysts, and other developers to understand requirements.

• Integrate Ambit Focus with external systems using APIs, file-based interfaces, or middleware.

• Ensure compliance with coding standards, security, and data integrity requirements.

• Develop and support integrations with third-party systems and banking applications.

• System Support and Troubleshooting

• Provide expert-level production support, including troubleshooting issues, root cause analysis, and performance tuning.

• Troubleshoot production issues related to Ambit Focus and ensure timely resolution.

•

• Technical Design & Documentation

• Translate business requirements into detailed technical specifications.

• Develop comprehensive documentation for code, interfaces, and configurations to support audits and knowledge transfer.

• Maintain system documentation, technical specifications, and user guides.

•

• Collaboration and Stakeholder Engagement

• Collaborate with business analysts, project managers, and business users to ensure effective solution delivery.

• Work closely with DBA, infrastructure, and application teams to deploy and maintain solutions.

• Participate in project meetings and contribute to solution design discussions.

•

• Upgrade and Patch Management

• Participate in system testing, regression testing, and go-live support for version upgrades or patching cycles.

• Perform unit testing, system testing, and assist in UAT.

• Support data migration, upgrades, and patch deployments related to Ambit Focus.

•

• Governance and Best Practices

• Ensure all development follows change management, security, and coding standards aligned with banking regulatory and IT audit requirements.

• Adhere to secure coding practices, especially for financial and customer data protection.

• Mentoring and Leadership

• Collaborate effectively with team members and contribute to knowledge-sharing activities.

• Take ownership of assigned development tasks and deliver them within the agreed timelines.

• Any other responsibilities/tasks as assigned by the management from time to time.

Job Specifications

• Technical/ Functional skills

• Understand and follows Group Project Life Cycle and System Development Life Cycle.

• Understanding of the Business Enablers banking related businesses and technology.

• Knowledge of modern Web Technologies including security and best development practices

• Technical hands-on background in IT infrastructure, software development, access management and IT Security.

• Intermediate knowledge on systems programming & queries such as:

• MSSQL integration services

• MSSQL Analysis services

• T-SQL

• VB scripting

• PowerShell

• C#

• Windows command scripts

• Technical knowledge of IT systems and architecture.

• Technical hands-on knowledge on IT system / technologies / tools / architectures / Web and DB Servers

• Windows/Unix servers

• SQL databases

• Analysis and troubleshoot system issues/problems and provide solutions/prevention actions.

• Personal skills (Soft Competencies [Core/Leadership])

• Good analytical & problem-solving skills.

• Good skills in communication and collaboration with other on daily job basis.

• Able to work in a fast track environment with tight datelines, working under pressure and able to manage multiple tasks at one time.

• Commitment and determination in facing challenges to achieve desired results.

• Display good leadership qualities, high commitment and drive to complete assignments.

• Non-Technical Skills

• Customer and Service Oriented

• Stakeholder Management

• Change Management

• Troubleshooting, Investigation and Diagnostic

• Analytical

• Problem Solving

• Collaboration

• Communication