Senior Data Engineer — ETL, SQL & Data Architecture

ST Engineering Urban Solutions; Hong Kong; On-site; HKD 600,000 - 900,000; Full time

Job summary

ST Engineering Urban Solutions in Hong Kong is seeking an experienced Data Specialist to join the data platform team. You will work with Solution Architect and BAs on end-to-end data solutions, evaluate data behavior for non-technical stakeholders, and optimize ETL processes using SQL Server/PostgreSQL.

You will review database changes, perform performance tuning, and support migration from Informatica PowerCenter to IDMC, applying best practices in data architecture and modeling.

Qualifications

• Must have 5 to 8 years of T-SQL programming.
• Must have 2 to 3 years of Informatica development experience.
• 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.
• Familiarity with Microsoft SQL Server/PostgreSQL DB.
• Knowledge of git Source Control and CI/CD pipelines or deployment automation tools.
• Critical thinker and problem-solving skills.
• Team player.
• Good time management skills.
• Great interpersonal and communication skills.

Responsibilities

• Works with Solution Architect & BAs on end-to-end solution, evaluate and develop high-quality data solutions.
• 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.
• Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
• Plan & develop ETL, Data preparation/aggregation processes from various sources to MSSQL database/PostgreSQL DB
• Maintain, and optimize ETL and other ETL processes to adapt to changes in needs and requirements.
• Participate in MS SQL code reviews and provide guidance on best practices.
• Review new database schema changes.
• Familiar with T-SQL, stored procedures, functions, inline SQL, database structures
• Analyze existing SQL queries for performance improvements.
• Monitor code migration and database change management through various stages of the development cycle.
• Design & Develop procedures and scripts for data migration.
• Develop, implement, maintain policies and procedures, and document database architecture to ensure security and integrity of the databases.
• 1-Year Renewable Contract / Potential for conversion to Permanent role based on performance and project pipeline

Skills

T-SQL programming

Informatica development

IDMC migration

Performance tuning

Data architecture

Data modeling

Microsoft SQL Server

PostgreSQL

Git source control

CI/CD pipelines

Critical thinker

Team player

Time management

Communication skills

Tools

Git Source Control

Informatica PowerCenter

IDMC

CI/CD pipelines

Job description

ST Engineering Urban Solutions in Hong Kong is seeking an experienced Data Specialist to join the data platform team. You will work with Solution Architect and BAs on end-to-end data solutions, evaluate data behavior for non-technical stakeholders, and optimize ETL processes using SQL Server/PostgreSQL.

You will review database changes, perform performance tuning, and support migration from Informatica PowerCenter to IDMC, applying best practices in data architecture and modeling.