LEAD PROGRAMMER

mc consulting pte. ltd.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

mc consulting pte. ltd. is seeking an experienced IT professional to lead the design, development, and maintenance of enterprise applications and ETL solutions in a Singapore-based role.

You will design and optimize ETL workflows with Informatica and SSIS, develop databases (SQL Server/Oracle), and build impactful reports via SSRS and Power BI. You will also support CI/CD pipelines and mentor junior developers in a fast-paced environment.

Qualifications

• Experience designing and implementing ETL solutions and data integration.
• Strong SQL skills including stored procedures, views, functions and triggers.
• Experience with BI reporting tools such as SSRS and Power BI.
• Experience in DevOps and CI/CD pipelines.
• Proficiency in programming languages including C#, ASP.NET, VB.NET, Groovy.

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 SDLC processes and coding standards.
• Provide technical guidance and mentor junior developers.

Skills

ETL Tools

Databases

SQL Programming

Reporting BI

DevOps CI/CD

Programming

Web Technologies

Data Migration

SDLC & Testing

Tools

Informatica

SSIS

SSRS

Power BI

SSAS

Jenkins

Bitbucket

Artifactory

SonarQube

Veracode

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 managemultiple projects and production support activities.