Principal Data Integration Architect: Cloud ETL Mastery

ADVANCE SOFTWARE ENGINEERING PTE. LTD.; Singapore; On-site; SGD 260,000 - 420,000; Full time

Job summary

ADVANCE SOFTWARE ENGINEERING PTE. LTD. in Singapore seeks a Principal Data Integration Architect to lead massive-scale ETL/ELT infrastructure.

Master Informatica IDMC, IICS and PowerCenter to engineer flawless, high-throughput hybrid cloud data pipelines across AWS and Databricks. The role demands relentless performance tuning, strict data governance, and architectural resilience, with responsibility for real-time and batch processes, complex mappings, and end-to-end data quality.

Qualifications

• Heavyweight, battle-tested experience with IDMC, IICS (CDI, CAI, CDQ), and PowerCenter.
• Deep SQL/PLSQL expertise and operational experience with Databricks, AWS Glue, Oracle, Redshift, and PostgreSQL.
• Proven track record in data governance and metadata management.
• Elite scripting ability in Python, Spark, or advanced Shell for automation.
• Bachelor's Degree in Computer Science is required.

Responsibilities

• Architect, deploy, and optimize real-time and batch ETL/ELT pipelines using Informatica IDMC and IICS.
• Lead hybrid cloud data integration, enabling zero-downtime on-prem to cloud migrations with AWS and Databricks.
• Drive performance optimization, pushdown techniques, parallel processing, and SQL session tuning.
• Engineer robust data flows across databases, cloud storage, APIs, RESTful services, and streaming frameworks.
• Enforce data governance, RBAC, encryption, audit trails, and data lineage.
• Provide technical leadership and documentation across BI and cloud teams.

Skills

SQL proficiency

PL/SQL

Python/Spark scripting

Data governance

Bachelor's in CS

Education

Bachelor's Degree in Computer Science

Tools

Informatica IDMC

Informatica IICS

PowerCenter

Databricks

AWS

Oracle

Redshift

PostgreSQL

Job description

ADVANCE SOFTWARE ENGINEERING PTE. LTD. in Singapore seeks a Principal Data Integration Architect to lead massive-scale ETL/ELT infrastructure.

Master Informatica IDMC, IICS and PowerCenter to engineer flawless, high-throughput hybrid cloud data pipelines across AWS and Databricks. The role demands relentless performance tuning, strict data governance, and architectural resilience, with responsibility for real-time and batch processes, complex mappings, and end-to-end data quality.