Senior ETL & Data Platform Lead

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

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.