Senior Informatica Data Engineer – ETL, SQL & Data Modeling

DBiz.ai

Singapore

On-site

SGD 120,000 - 170,000

Full time

7 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

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
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, Data Pipelines & BI Automation
Senior Data Engineer | ETL, Data Pipelines & BI Automation

EM Services Pte Ltd • Singapore

On-site
SGD 60,000 - 100,000
Senior Data & SQL BA | Agile, cross-team impact
Senior Data & SQL BA | Agile, cross-team impact

EPAM Systems Inc • Singapore

On-site
SGD 120,000 - 180,000
Great Place to Work Certification (EP)
Mentoring programs
Online courses and libraries
Data Engineer
Data Engineer

DIGITAL BIZ SOLUTIONS PTE. LTD. • Singapore

On-site
SGD 120,000 - 180,000
Senior Data & AI Platform Engineer
Senior Data & AI Platform Engineer

DSTA • Singapore

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

DBiz.ai • Singapore

On-site
SGD 120,000 - 170,000
Senior Data Engineer - AML Data Platform & APIs (Singapore)
Senior Data Engineer - AML Data Platform & APIs (Singapore)

Infosys • Singapore

On-site
SGD 120,000 - 180,000
Data Engineer – Azure, Databricks, ETL & AI Pipelines
Data Engineer – Azure, Databricks, ETL & AI Pipelines

PHAIDON INTERNATIONAL (SINGAPORE) PTE. LTD. • Singapore

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

Tap Growth ai • Singapore

On-site
SGD 90,000 - 130,000