Informatica Expert - Singapore - HCT INFOTECH

Description

Job Title:
Informatica Expert (with Informatica Cloud)


Location:
North, Singapore

Experience: 5+ years


Domain:
Healthcare

Mode: 1 Year contract under us, extendable


Monthly Salary:
around S$

Interview Rounds: 1


Job Description:


Responsibilities:

• Collaborate with Solution Architects and Business Analysts to design endtoend solutions, evaluate IDMC services, and recommend suitable options.
• Utilize standard data modeling, data flow, and data documentation tools to analyze, document, and present data analysis work.
• Work collaboratively with team members to troubleshoot and resolve data and process issues.
• Plan and develop ETL (Extract, Transform, Load) processes, data preparation, and aggregation from various sources to MSSQL database/PostgreSQL DB.
• Create, maintain, and optimize ETL and other Informatica processes to adapt to evolving needs and requirements.
• Develop and manage Informatica configurable artifacts including code, environment, configuration files, and documentation.
• Plan Informatica ETL unit, SIT (System Integration Testing), and UAT (User Acceptance Testing) tests.
• Possess familiarity with stored procedures, functions, inline SQL, and database structures.
• Adhere to established standards and best practices while contributing to process improvements.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 5 to 8 years of experience in Informatica development.
• Current experience with Informatica PowerCenter v10.5+ is essential.
• Experience with migration of Informatica PowerCenter to IDMC.
• Proficiency in performance tuning of sources, mappings, targets, and sessions.
• Understanding of Data Architecture and Data Modeling concepts is advantageous.
• Familiarity with Microsoft SQL Server/PostgreSQL DB.
• Excellent understanding of T-SQL programming.
• Ability to collaborate with development and operations teams to optimize production queries for performance.
• Knowledge of git Source Control and CI/CD pipelines or deployment automation tools is preferred.
• Strong critical thinking and problemsolving abilities.
• Team player with excellent interpersonal and communication skills.
• Effective time management skills.

This is an exciting opportunity for an Informatica Expert to contribute to the healthcare domain while utilizing their expertise in Informatica PowerCenter and Informatica Cloud.

If you meet the qualifications and are looking for a challenging role in Singapore, we encourage you to apply.


Salary:
$7, $7,500.00 per month


Work Location:
In person