Data Engineer (1-Year Contract – Renewable / Convertible)

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

  • 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

Requirements
  • Must have 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 Knowledge of CI/CD pipelines or deployment automation tools.

  • Critical thinker and problem-solving skills.

  • Team player.

  • Good time management skills.

  • Great interpersonal and communication skills.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

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
Assistant Lead Analyst - Informatica (Engineering)
Assistant Lead Analyst - Informatica (Engineering)

Synapxe • Singapore

On-site
SGD 120,000 - 160,000
Experienced Informatica Data Engineer: IDMC & ETL
Experienced Informatica Data Engineer: IDMC & ETL

ST Engineering Urban Solutions • Singapore

On-site
SGD 90,000 - 130,000
Software Engineer - MB007
Software Engineer - MB007

INTELLIMATICZ PTE. LTD. • Singapore

On-site
SGD 60,000 - 110,000
Manager - Data & Cloud Engineer (DNA)
Manager - Data & Cloud Engineer (DNA)

Synapxe • Singapore

On-site
SGD 90,000 - 120,000
ETL Informatica Developer
ETL Informatica Developer

VUI SYSTEMS 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
Data Engineer
Data Engineer

ZENITH INFOTECH (S) PTE LTD. • Singapore

On-site
SGD 120,000 - 180,000
IT Data Engineer (12 months Agency Contract)
IT Data Engineer (12 months Agency Contract)

PERSOL • Singapore

On-site
SGD 60,000 - 120,000