Experienced Informatica Data Engineer: IDMC & ETL

ST Engineering Urban Solutions

Singapore

On-site

SGD 90,000 - 130,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

ST Engineering Urban Solutions is seeking an Informatica Developer in Singapore to design and optimize ETL processes, migrate from PowerCenter to IDMC, and work with cross-functional teams to ensure data quality and performance. You will tune SQL-based queries, participate in SIT/UAT, and provide post-production support.

The role expects 5–8 years of Informatica experience, strong T-SQL skills, and familiarity with CI/CD and Git.

Qualifications

  • 5 to 8 years of Informatica development experience.
  • Current experience with Informatica PowerCenter v10.5+.
  • Experience with migration of Informatica PowerCenter to IDMC.
  • Experience with performance tuning of sources, mappings, targets, and sessions.
  • Experience with Data Architecture and Data Modeling concepts is a plus.
  • Familiarity with Microsoft SQL Server/PostgreSQL DB.
  • Excellent understanding of T-SQL programming.
  • Ability to work with development and operations teams to tune production queries for optimal performance.
  • Knowledge of git Source Control and CI/CD pipelines or deployment automation tools.
  • Critical thinker and problem-solving skills.
  • Team player and good time management skills.
  • Great interpersonal and communication skills.

Responsibilities

  • Works with Solution Architect & BAs on end-to-end solution, evaluate and recommend suitable Informatica IDMC services.
  • Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
  • Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
  • Works cooperatively with others to resolve data and process issues.
  • Plans & develops ETL, Data preparation/aggregation processes from various sources to MSSQL database/PostgreSQL DB
  • Create, maintain, and optimize ETL and other informatica processes to adapt to changes in needs and requirements.
  • Responsible for developing and managing informatica configurable artifacts (code, environment, configuration files, documentation).
  • Plans Informatica ETL unit, SIT and UAT tests.
  • Familiar with stored procedures, functions, inline SQL, database structures
  • Provide post-production application support as required.
  • Follow established standards and best practices and provide input for improvement of those processes.
  • 1-Year Renewable Contract / Potential for conversion to Permanent role based on performance and project pipeline

Skills

Informatica development
PowerCenter v10.5+
Migration to IDMC
Performance tuning
T-SQL
Data modeling
Data architecture
Git
CI/CD pipelines
Communication

Tools

Informatica PowerCenter
Informatica IDMC
SQL Server
PostgreSQL
Git
CI/CD tooling

Job description

ST Engineering Urban Solutions is seeking an Informatica Developer in Singapore to design and optimize ETL processes, migrate from PowerCenter to IDMC, and work with cross-functional teams to ensure data quality and performance. You will tune SQL-based queries, participate in SIT/UAT, and provide post-production support.

The role expects 5–8 years of Informatica experience, strong T-SQL skills, and familiarity with CI/CD and Git.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Solutions Engineer - Informatica, Oracle & SQL
ETL Solutions Engineer - Informatica, Oracle & SQL

INTELLIMATICZ PTE. LTD. • Singapore

On-site
SGD 60,000 - 110,000
Senior Data Engineer: ETL, SQL & IDMC Expert
Senior Data Engineer: ETL, SQL & IDMC Expert

DIGITAL BIZ SOLUTIONS PTE. LTD. • Singapore

On-site
SGD 120,000 - 180,000
Informatica Developer
Informatica Developer

DBiz.ai • Singapore

On-site
SGD 120,000 - 170,000
Data Engineer
Data Engineer

DIGITAL BIZ SOLUTIONS PTE. LTD. • Singapore

On-site
SGD 120,000 - 180,000
Data Engineer (1-Year Contract – Renewable / Convertible)
Data Engineer (1-Year Contract – Renewable / Convertible)

ST Engineering Urban Solutions • Singapore

On-site
SGD 90,000 - 130,000
44086 Informatica Developer
44086 Informatica Developer

half the sky • Singapore

On-site
SGD 70,000 - 95,000
Flexible working arrangements
Generous salary and benefits package
Professional development opportunities
Data Engineer (AWS, Databricks & Informatica IDMC) | Path Infotech | Singapore
Data Engineer (AWS, Databricks & Informatica IDMC) | Path Infotech | Singapore

Tech Junction Ltd • Singapore

On-site
SGD 90,000 - 150,000
Informatica ETL Engineer — Flexible Work & Growth
Informatica ETL Engineer — Flexible Work & Growth

half the sky • Singapore

On-site
SGD 70,000 - 95,000
Flexible working arrangements
Generous salary and benefits package
Professional development opportunities
Software Engineer - MB007
Software Engineer - MB007

INTELLIMATICZ PTE. LTD. • Singapore

On-site
SGD 60,000 - 110,000
Senior Informatica Data Engineer – ETL, SQL & Data Modeling
Senior Informatica Data Engineer – ETL, SQL & Data Modeling

DBiz.ai • Singapore

On-site
SGD 120,000 - 170,000