Informatica Developer

DBiz.ai

Singapore

On-site

SGD 120,000 - 170,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

DBiz.ai in Singapore is seeking an Informatica Data Lead/Senior Engineer to partner with Solution Architects and Business Analysts, delivering end-to-end data solutions, leading ETL design and database engineering across MS SQL Server and PostgreSQL.

You will optimize ETL pipelines, review code and schemas, and ensure security, data quality, and governance while coordinating with cross-functional teams through the project lifecycle.

Qualifications

  • 5-8 years hands-on T-SQL programming experience.
  • 2-3 years Informatica development experience.
  • Experience migrating PowerCenter to IDMC.
  • Strong performance tuning across sources, mappings, targets, and sessions.
  • Solid understanding of Data Architecture and Data Modeling concepts.
  • Working experience with Microsoft SQL Server and/or PostgreSQL.
  • Familiarity with Git source control.
  • Knowledge of CI/CD pipelines and/or deployment automation tools.

Responsibilities

  • Collaborate with Solution Architect and BAs to deliver end-to-end data solutions.
  • Explain data behavior to non-technical stakeholders.
  • Resolve data and process issues across teams to ensure timely delivery.
  • Analyze data outputs using standard modeling and documentation tools.
  • Plan and develop ETL and data prep from sources into SQL Server or PostgreSQL.
  • Maintain and optimize ETL pipelines to evolving requirements.
  • Participate in MS SQL code reviews and promote best practices.
  • Review database schema changes for downstream impact.
  • Develop and optimize T-SQL components and work with database structures.
  • Analyze SQL queries and ETL jobs for performance and scalability.
  • Monitor code migration and DB change management through lifecycle stages.
  • Design procedures/scripts for data migration and cutover activities.
  • Maintain database policies, procedures, and architecture docs for security and integrity.

Skills

T-SQL programming
Informatica development
Performance tuning
Data modeling
Data architecture
MS SQL Server
PostgreSQL
Git
CI/CD

Tools

Informatica IDMC migration
MS SQL Server
PostgreSQL
Git
CI/CD pipelines
AWS

Job description

The Informatica Data Lead/Senior Engineer partners with Solution Architects and Business Analysts to deliver end-to-end data solutions for client projects. This role leads ETL design and development, database engineering, data modeling, performance tuning, and data governance practices across MS SQL Server and PostgreSQL environments.

Key Duties & Responsibilities
  • Collaborate with Solution Architect and BAs to design, evaluate, and deliver high-quality end-to-end data solutions for client engagements.
  • Engage non-technical subject matter experts to understand and explain data behavior, patterns, and characteristics in an accessible way.
  • Work cross-functionally to resolve data and process issues, ensuring timely delivery and quality outcomes.
  • Use standard data modeling, data flow, and documentation tools to analyze, document, and present data analysis outputs.
  • Plan and develop ETL and data preparation/aggregation processes from multiple sources into MS SQL Server and/or PostgreSQL databases.
  • Maintain and optimize ETL pipelines to meet evolving requirements and changing upstream/downstream dependencies.
  • Participate in MS SQL code reviews and guide SQL and ETL best practices.
  • Review and validate database schema changes to ensure alignment with data architecture and downstream impacts.
  • Develop and optimize T-SQL components (stored procedures, functions, inline SQL) and work confidently with database structures.
  • Analyze existing SQL queries and ETL jobs for performance improvements and scalability.
  • Monitor code migration and database change management across development lifecycle stages (dev/test/uat/prod).
  • Design and develop procedures/scripts for data migration and cutover activities.
  • Develop, implement, and maintain database policies, procedures, and architecture documentation to ensure data security, integrity, and compliance.
Required Qualifications & Experience
  • 5-8 years of hands-on T-SQL programming experience.
  • 2-3 years of Informatica development experience.
  • Experience migrating Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC).
  • Strong experience in performance tuning across sources, mappings, targets, and sessions.
  • Solid understanding of Data Architecture and Data Modeling concepts.
  • Working experience with Microsoft SQL Server and/or PostgreSQL.
  • Familiarity with Git source control.
  • Knowledge of CI/CD pipelines and/or deployment automation tools.
Preferred / Advantageous Experience
  • Delivered ETL and/or data modeling projects for enterprise clients with sizeable scope (e.g., multi-year delivery or large-budget programmes).
  • Demonstrated interest in modern ETL/data processing solutions (e.g., Apache Flink) and continuous learning in data engineering.
  • Strong AWS experience, including managed services such as:Amazon RDSETL services/toolsStream processing solutions
  • Broad AWS cloud delivery experience in client-facing environments.
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
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
Assistant Lead Analyst - Informatica (Engineering)
Assistant Lead Analyst - Informatica (Engineering)

Synapxe • Singapore

On-site
SGD 120,000 - 160,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
Software Engineer - MB007
Software Engineer - MB007

INTELLIMATICZ PTE. LTD. • Singapore

On-site
SGD 60,000 - 110,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
ETL Informatica Developer
ETL Informatica Developer

VUI SYSTEMS PTE. LTD. • Singapore

On-site
SGD 60,000 - 110,000
Data Engineer
Data Engineer

ZENITH INFOTECH (S) PTE LTD. • Singapore

On-site
SGD 120,000 - 180,000
ETL Developer / ETL Engineer / ETL Development Manager
ETL Developer / ETL Engineer / ETL Development Manager

hayleys mobility • Singapore

On-site
SGD 70,000 - 100,000
Manager - Data & Cloud Engineer (DNA)
Manager - Data & Cloud Engineer (DNA)

Synapxe • Singapore

On-site
SGD 90,000 - 120,000