Migration ETL Developer

LYNEER CORP (SINGAPORE) PTE. LTD.; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

A financial services firm in Singapore is seeking an experienced ETL Developer to design and maintain robust workflows using Informatica. The ideal candidate will have 7-10 years of experience in ETL development, particularly within enterprise banking environments. Responsibilities include data profiling, data migration, and troubleshooting job failures. Candidates should possess strong SQL skills and familiarity with DevOps practices. This role is critical for ensuring data integrity and compliance with regulatory standards.

Qualifications

• Minimum 7-10 years of ETL development experience in banking or financial services environments.
• Hands-on expertise with Informatica PowerCenter and cloud integration.
• Experience in troubleshooting performance bottlenecks and job failures.

Responsibilities

• Design and maintain ETL workflows for data migration.
• Collaborate with Business Analysts and Data Architects.
• Conduct data profiling and validate migrated datasets.

Skills

Informatica PowerCenter

SQL

PL/SQL

Data profiling

Relational databases (Oracle, SQL Server, DB2)

Dimensional modelling

DevOps practices

CI/CD pipelines

Tools

Informatica Cloud

Powerexchange

Git

Job description

• Design, develop, and maintain robust ETL workflows using Informatica (on-premise and cloud - IDMC ) to support large-scale data migration from heterogeneous source systems.
• Experience in using Powerexchange to access Mainframe source system would be an added advantage.
• Implement scalable data integration jobs covering extract, transform, cleanse, enrich, and load (ETL/ELT) processes within both batch and near-real-time environments.
• Conduct data profiling to assess source data quality, uncover inconsistencies, duplicates, missing values, and structural anomalies affecting migration integrity.
• Collaborate with Business Analysts and Data Architects to interpret mapping specifications and translate them into executable ETL logic.
• Perform reconciliation and delta analysis between source and target systems to validate completeness, accuracy, and consistency of migrated datasets.
• Troubleshoot and resolve performance bottlenecks, connectivity issues, and job failures across development, testing, and production environments.
• Securely handle client-sensitive data in line with banking regulations (FIDLEG, MAR, GDPR) and Julius Baer’s internal data protection policies.
• Document ETL designs, data lineage, interface specifications, and support operational handover post-go-live.
• Participate in agile sprints, code reviews, testing cycles (SIT/UAT), and production cutover activities.
• Essential Qualifications - Minimum 7-10 years of ETL development experience in enterprise banking or financial services environments.
• Proven hands-on expertise with Informatica PowerCenter and Informatica Cloud (IDMC preferred), including connectors, taskflows, and monitoring dashboards.
• Strong skills in SQL, PL/SQL, and relational databases (Oracle, Microsoft SQL Server, DB2).
• Demonstrated experience in data profiling, quality assessment, and reconciliation techniques.
• Solid understanding of dimensional modelling, metadata management, and CDC (Change Data Capture) concepts.
• Familiarity with DevOps practices, CI/CD pipelines, and version control (Git).
• Preferred Attributes- Prior involvement in core banking migrations (e.g.,to T24, FinSuite, or equivalent).
• Exposure to cloud platforms (AWS, Azure) and integration with IDMC.
• Basic knowledge of banking domains: client master, accounts, holdings, transactions, limits

Technical Accountabilities

• Deliver high-performance, well-documented ETL solutions meeting functional and non-functional requirements.
• Ensure all data movements are auditable, reversible, and error-handled according to bank standards.
• Guarantee successful end-to-end data reconciliation across migration waves.