Lead Programmer

IOTALENTS PTE. LTD.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

IOtalents PTE. LTD. in Singapore is seeking a senior ETL/BI engineer to design, develop, and maintain enterprise applications and complex data workflows. You will optimize ETL pipelines using Informatica and SSIS, support SQL Server and Oracle databases, and build reports with SSRS and Power BI.

The role requires strong collaboration with stakeholders, adherence to SDLC, and mentorship of junior developers in a fast-paced financial services environment.

Qualifications

• Experience designing enterprise ETL solutions across banking/financial services domains.
• Experience delivering data warehouse and enterprise reporting.
• Exposure to Microsoft BI technologies and large-scale ETL implementations.
• Experience working in Agile or structured SDLC environments.

Responsibilities

• Lead design, development, and maintenance of enterprise applications and ETL solutions.
• Design, develop, and optimize ETL workflows using Informatica and SSIS.
• Develop and maintain SQL Server and Oracle databases, including stored procedures, functions, views, triggers, and complex SQL queries.
• Perform database performance tuning, query optimization, and data migration activities.
• Design and develop reports and dashboards using SSRS and Power BI.
• Support and maintain CI/CD pipelines using DevOps tools such as Jenkins, Bitbucket, Artifactory, SonarQube, and Veracode.
• Collaborate with business stakeholders to analyze requirements and deliver technical solutions.
• Perform application integration, testing, deployment, and production support.
• Ensure adherence to SDLC processes and coding standards.
• Provide technical guidance and mentor junior developers.

Skills

ETL Design

SQL Proficiency

BI Reporting

CI/CD Automation

Mentoring

Stakeholder Comms

Tools

Informatica

SSIS

Power BI

SSRS

SSAS

Jenkins

Bitbucket

Artifactory

SonarQube

Veracode

C#

Job description

Key Responsibilities:

• Lead the design, development, and maintenance of enterprise applications and ETL solutions.


• Design, develop, and optimize ETL workflows using Informatica and SSIS.


• Develop and maintain SQL Server and Oracle databases, including stored procedures, functions, views, triggers, and complex SQL queries.


• Perform database performance tuning, query optimization, and data migration activities.


• Design and develop reports and dashboards using SSRS and Power BI.


• Support and maintain CI/CD pipelines using DevOps tools such as Jenkins, Bitbucket, Artifactory, SonarQube, and Veracode.


• Collaborate with business stakeholders to analyze requirements and deliver technical solutions.


• Perform application integration, testing, deployment, and production support.


• Ensure adherence to software development lifecycle (SDLC) processes and coding standards.


• Provide technical guidance and mentor junior developers.

Required Technical Skills:

• ETL Tools: Informatica, SSIS


• Databases: Microsoft SQL Server, Oracle, IBM DB2


• SQL Programming: T-SQL, Stored Procedures, Views, Functions, Triggers, Query Optimization


• Reporting & BI: SSRS, Power BI, SSAS


• DevOps & CI/CD: Jenkins, Bitbucket, Artifactory, SonarQube, Veracode


• Programming: C#, ASP.NET, VB.NET, Groovy


• Web Technologies: WCF, Web Services


• Data Migration and Performance Tuning


• SDLC, Application Support, Integration Testing, Regression Testing

Preferred Experience

• Experience in Banking and Financial Services projects.


• Experience delivering enterprise reporting and data warehouse solutions.


• Exposure to Microsoft BI technologies and large-scale ETL implementations.


• Experience working in Agile or structured SDLC environments.

Key Competencies

• Technical Leadership


• Problem Solving and Analytical Skills


• Stakeholder Communication


• Team Collaboration and Mentoring


• Quality and Performance Focus


• Ability to manage multiple projects and production support activities.