At least 5 - 6 years’ experience in developing, implementing and maintaining IT systems
Position Summary / Project Description
ETL (Informatica BDM/DEI) with Data Model experience. He/she will co-lead ETL developers.
Role and Responsibilities
- Involve in various stages of the systems development life cycle; adopting waterfall, agile or hybrid development methodology.
- Performs analysis, design and development of ETL processes to support project requirements
- Design and develop complex Informatica ETL mappings, sessions, workflows and maintain existing ETL/data warehouse processes.
- Prepare technical design specifications based on the projects and change request assigned.
- Conduct system integration testing and create test cases to ensure data quality prior to implementation.
- Resolve issues raised during user acceptance testing.
- Evaluate potential technical solutions and make recommendations to resolve business problems.
- Work with business partners during system implementation and manage post implementation support.
- Provide on-going support (24x7) to various applications running in the data warehouse if required.
Technical Skills:
ETL: Informatica Data Engineering Integration/Big Data Management, Informatica Powercenter, SAP BODS
Business Intelligence: Oracle Business Intelligence (OBIEE), Tableau
Databases: Oracle, Microsoft SQL Server, Teradata
- Degree in Computer Science, Information Technology, Computer Engineering or equivalent.
- Technical skills in order of priority: Informatica BDM/DEI, Informatica PowerCenter, Strong SQL, Oracle, SQL Server and Teradata Experience.
- Minimum Seven (7) to eight (8) years’ experience in ETL Development and Data Integration.
- Strong analytical and problem solving skills.
- Strong understanding of ETL Development best practices, strong understanding of Data Lake and Warehouse Concepts, Performance Tuning in SQL and Informatica
- Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.
- Outstanding ability to communicate, both verbally and in writing.
- Ability to develop complex mappings and workflows in accordance with requirements
- Exposure to hospital information / clinical systems is an added advantage.
- Experience in using business intelligence tools (e.g. OBIEE, Tableau, etc.) is an added advantage.
- Experience in Vendor Management is an added advantage.
Please note: Only shortlisted candidates will be contacted
EA Registration No. R1871815 (Saravanan)
EA License No. 01C4394
**By sending us your personal data and curriculum vitae (CV), you are deemed to consent to PERSOLKELLY Singapore Pte Ltd and its local and overseas subsidiaries and affiliates collecting, using and disclosing your personal data to prospective employers/companies based in any country for purposes of evaluating suitability for employment, conducting reference checks, administering employment related services, complying with Government’s COVID-19 health advisories and such other purposes stated in our privacy policy. Our full privacy policy is available at www.persolkelly.com.sg. If you wish to withdraw your consent, please drop us an email to let us know. Please feel free to contact us if you have any queries.**
