Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
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.
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
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.