DB/SSIS Developer

2 weeks ago


Singapore OVERSEA-CHINESE BANKING CORPORATION LIMITED Full time
Roles & Responsibilities

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

  • 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.
Tell employers what skills you have

Technical Analysis
ArcGIS Server
Oracle
Interpersonal Skills
Architectural
System Testing
ETL
GIS
SQL
ArcGIS
SQL Server
Python
Time Management
SSIS
Visual C
  • Technical Lead

    3 weeks ago


    Singapore HCL SINGAPORE PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilities Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data...

  • Data Engineer

    3 weeks ago


    Singapore NTT DATA BUSINESS SOLUTIONS SINGAPORE PTE. LTD. Full time

    Roles & ResponsibilitiesYour career at NTT DATA Business SolutionsEmpowering You – to feel our passion for SAP / Analytic Solutions / ServiceNowAs NTT DATA Business Solutions, we are more than just a company. We are a team of innovative and passionate people who specialize in creating value-added SAP and Analytic solutions and guiding our customers on...


  • Singapore OCBC Full time

    About this RoleWe are seeking an experienced software developer to join our team as a Technical Lead Developer. As a key member of our team, you will play a crucial role in spearheading technical analysis, design, development, and system testing around OCBC's specific technology streams and its sub-system. Your expertise in MS SQL Server, SSIS, and MS Visual...

  • MSBI Developer

    3 weeks ago


    Singapore APAR TECHNOLOGIES PTE. LTD. Full time

    Roles & ResponsibilitiesJob DescriptionPositionIn a challenging and multicultural environment, we are looking for a Senior MS BI / MS SQL Developer to join a IT team in charge of Client Referential, Compliance, Risk or Finance. The team handles the development of transversal and international projects.Main responsibilitiesSSRS, SSAS Development:Design,...


  • Singapore TRINITY CONSULTING SERVICES PTE. LTD. Full time

    Roles & Responsibilities· At least 8 years of work experience in leading Microsoft BI projects, including SSRS, SSIS, and SQL Server.· Strong proficiency in T-SQL, including query optimization and stored procedures.· Hands-on experience with ETL processes and data integration using SSIS.· Good exposure and usage experience in CI/CD tools / processes·...

  • Developer -

    2 days ago


    Singapore OCBC Full time

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


  • Singapore JOBS DB SINGAPORE PTE LTD Full time

    Roles & ResponsibilitiesOur client is a premier integrated events company in Asia, specializing in conferences, exhibitions, incentives, cultural exchanges, and live shows. With a strong presence in Singapore, Sydney, Kuala Lumpur, Bangkok, Jakarta, Beijing, and Guangzhou, they deliver exceptional events for 10 to 5000 attendees. Their dedicated team excels...

  • MS BI Developer

    2 weeks ago


    Singapore SCIENTE INTERNATIONAL PTE. LTD. Full time

    Roles & ResponsibilitiesJob SummaryWe have an excellent opportunity to be part of a leading financial firm for a Senior MS BI Developer.Mandatory Skill-set:Degree in Information Technology, Computer Science, Computer Engineering or related discipline; At least 5 years of hands-on development experience in Business Intelligence/database design; Hands-on...

  • Net Developer

    3 weeks ago


    Singapore R SYSTEMS (SINGAPORE) PTE LIMITED Full time

    Roles & ResponsibilitiesRequirementFinancial technology background experience (Wealth Management, Investment Management, Asset Management, Investment Banking preferred) with strong development experience including past software development role as well as previous experience in the FinIQ solutions (preferred). At least 4 years of development experience with...


  • Singapore DBS Bank Limited Full time

    Our ExpectationsAs a Site Reliability Engineer at DBS Bank Limited, you will be expected to:Develop and maintain monitoring and onboarding guidelines for various applications using observability platform stacks;Drive observability standards, best practices, operations, and processes for the Enterprise in AppDynamics and other observability tools;Automate...

  • Software Developer

    3 weeks ago


    Singapore QUESSCORP SOLUTIONS PTE. LTD. Full time

    Roles & ResponsibilitiesRole:•Design, develop, and maintain scalable applications using Python, Java, Spring Boot, and PySpark.•Implement and optimize RESTful APIs for seamless integrations.•Work with RabbitMQ, Kafka, and Oracle Advanced Queues to manage messaging and event-driven architectures.•Develop PL/SQL scripts, stored procedures, and...

  • Design Manager

    3 weeks ago


    Singapore DB & B PTE LTD Full time

    Roles & ResponsibilitiesDevelop and implement workplace strategies that align with client business goals and evolving workplace trend Collaborate with design teams to translate strategic insights into meaningful design solutions. Lead discussions with clients to understand their workplace vision, organizational needs and culture dynamics. Foster strong...


  • Singapore DBS BANK LTD. Full time

    Roles & ResponsibilitiesDBS' Private Banking offers a one-stop, full-service touch-point for total banking requirements and provides the highest level of personalised banking. We have a team of dedicated, experienced investment advisors who identify opportunities in the various asset classes and employ the best strategies and product vehicles to cater to...

  • Technical Lead

    3 weeks ago


    Singapore HCL SINGAPORE PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilitiesParticipate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data...

  • ETL developer

    2 weeks ago


    Singapore CLPS TECHNOLOGY (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesMust have experience of Big Data and Talend Platform Implemented knowledge on Hive, Impala, HDFS, and Sqoop Experience on SQL for report development, usage of aggregate functions, views and Joins Worked on the Databases such as Oracle, MySQL and SQL Server Worked with AWS EC2, Lambda, and S3 Services Excellent team player with...


  • Singapore IDC TECHNOLOGIES (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesRequirement:Strong skills in Cobol programming, Unix environment, and DB script for report development. Min 2 years of experience in Cobol programming, SQL, and DB SQL script for report development is mandatory. At least 1-2 years of experience in Linux/Unix/AIX and VSAM. Experience in File handling/Reports Generation, Tools...


  • Singapore MANPOWER STAFFING SERVICES (SINGAPORE) PTE LTD Full time

    Roles & ResponsibilitiesJob Scope:We are seeking a Senior Software Developer and Application Support Specialist with at least 13 years of specialized experience in complex ETL workflows, data integration, and reporting systems. This highly specialized role requires deep expertise in Informatica, SSIS, and SSRS for optimizing large-scale, mission-critical...

  • Java Developer

    3 weeks ago


    Singapore CGS INTERNATIONAL SECURITIES SINGAPORE PTE. LTD. Full time

    Roles & ResponsibilitiesAbout the companyCGS International Securities Singapore Pte. Ltd is one of the leading integrated financial service providers in Asia. With a global presence in over 20 countries, and backed with an award-winning research team, the Company is well-positioned as Asia's leading financial gateway, providing well researched and in-depth...


  • Singapore IDC TECHNOLOGIES (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesRequirement: Strong skills in Cobol programming, Unix environment, and DB script for report development. Min 2 years of experience in Cobol programming, SQL, and DB SQL script for report development is mandatory. At least 1-2 years of experience in Linux/Unix/AIX and VSAM. Experience in File handling/Reports Generation, Tools...

  • Software Developer

    3 weeks ago


    Singapore QUESSCORP SOLUTIONS PTE. LTD. Full time

    Roles & ResponsibilitiesRole:•Design, develop, and maintain scalable applications using Python, Java, Spring Boot, and PySpark.•Implement and optimize RESTful APIs for seamless integrations.•Work with RabbitMQ, Kafka, and Oracle Advanced Queues to manage messaging and event-driven architectures.•Develop PL/SQL scripts, stored procedures, and...