Overview

Group Operations & Technology Division

DB/SSIS Developer – (25000074)

Description

 

The position entails designing and driving the implementation of development best practices, while playing a crucial role in spearheading technical analysis, design, development, and system testing around the bank’s specific technology streams and its sub-system.

Responsibilities

  • Act as the SME, responsible for the architecture design, roadmap, and implementation of all change initiatives on the platform.
  • Ensure timely delivery, perform inspections to ensure quality of the relevant documentation, artifact and work packages in accordance with the Bank’s SDLC and Agile processes.
  • Work with the solution architects / solution managers / project managers to provide consultancy advice, inputs, and effort estimates to projects/CRs.
  • Technical document preparation, technical feasibility assessment and coordination with internal team member to accomplish the task.
  • Collaborate with the Run-the-Bank organization to provide 3rd level support, engaging them to gather input on operational, non-functional requirements to ensure resilience, scalability, and high performance.
  • Utilize programming methodologies and languages and adhere to coding standards, procedures and techniques while contributing to the technical code documentation.
  • Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.
  • Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow and understand and comply with Project Life Cycle Methodology in all planning steps.
  • Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules.
  • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation.

 

Qualifications

 

Qualifications

  • 12 -14 years of hands-on experience with MS SQL Server, SSIS and MS Visual C#.
  • Deep Knowledge of SQL language with common database platforms such as SQL Server and Oracle.
  • Deep Knowledge of SQL language concepts like database modelling, tables/views, stored procedures, cursor, trigger, functions, indexes and complex queries.
  • Expertise in solving SQL Server performance issues.
  • Knowledge and experience in complex SSIS packages development to perform ETL operations from various data sources.
  • Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
  • Expertise in SSIS deployment and troubleshooting.
  • Knowledge and experience with Control M Scheduler is a plus.
  • Knowledge and experience with DevOps practice and tools is a plus.
  • Knowledge and experience with Banking business is a plus.
  • Knowledge and experience in Python are plus.
  • Bachelor’s degree in computer science, Management Information Systems, Engineering, or a related field.

Skills and Abilities

  • Motivated and demonstrates initiative.
  • Able to critically think and be solution oriented.
  • Strong interpersonal skills and able to work easily with project members.
  • Works well independently and within a team.
  • Great organizational, time management and problem-solving skills.
  • Able to work in fast-paced environment.
  • Possesses a professional demeanor.

 

Primary Location

: Singapore

Job

: Information Technology

Organization

: Group Operations & Technology Division

Schedule

: Permanent

: Full-time

Job Posting

: 09-Feb-2025, 6:51:48 AM

Tagged as:

About OCBC Bank

OCBC is the longest established Singapore bank, formed in 1932 from the merger of three local banks, the oldest of which was founded in 1912. It is now the second largest financial services group in Southeast Asia by assets and one of the world’s most highly-rated banks, with an Aa1 rating from Moody’s. Recognised for its financial strength and stability, OCBC is consistently ranked among the World’s Top 50 Safest Banks by Global Finance and has been named Best Managed Bank in Singapore by The Asian Banker.

OCBC and its subsidiaries offer a broad array of commercial banking, specialist financial and wealth management services, ranging from consumer, corporate, investment, private and transaction banking to treasury, insurance, asset management and stockbroking services.

OCBC’s key markets are Singapore, Malaysia, Indonesia and Greater China. It has more than 570 branches and representative offices in 19 countries and regions. These include about 300 branches and offices in Indonesia under subsidiary Bank OCBC NISP, and over 90 branches and offices in Mainland China, Hong Kong SAR and Macau SAR under OCBC Wing Hang.

OCBC’s private banking services are provided by its wholly-owned subsidiary Bank of Singapore, which operates on a unique open-architecture product platform to source for the best-in-class products to meet its clients’ goals.

OCBC's insurance subsidiary, Great Eastern Holdings, is the oldest and most established life insurance group in Singapore and Malaysia. Its asset management subsidiary, Lion Global Investors, is one of the largest private sector asset management companies in Southeast Asia.