Position Summary / Project Description :

ETL (Informatica Big Data Management/ Data Engineering Integration) with Data Model experience. 

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

Requirements / Qualifications : 

Technical skills of :

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.
• Minimum 5 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.