Job Description

Why are they awesome?

• USA Based independent pharmaceutical data & analytics company
• Healthcare efficiency and safety solutions provider to US-based and global clinical businesses
• HQ based in Philadelphia, US - with regional offices in Abu Dhabi, UK and KL
• World\'s largest set of medical & patient safety data + technology decision support

• Embark on a thrilling journey of data transformation, seamlessly integrating information from over a thousand diverse sources into various dynamic systems
• Developed SQL queries to collect and retrieve information such as hospital data (patient details, appointment scheduling, billing related information) and create customized reports.
• Perform Data Analysis and Data Profiling using complex SQL queries using Oracle, Teradata and XML.
• Prepared ETL technical Mapping Documents & test cases to maintain Software Development Life Cycle (SDLC).

• Strong knowledge in SQL relational knowledge
• Familiarity with data imports such as XML, spreadsheets, etc
• Knowledge in ETLs
• Healthcare or MNC business experience preferred.

• Understanding of the Software Development Life Cycle
• Experience using tracking tools to manage the release process
• Knowledge in ETL (Extract, Transform and Load) data mapping, warehouse, extraction and Business Intelligence (BI) tools like Tableau / Business Objects, IBM Cognos.
• MS Visio for UML modeling (Use Cases, Activity Diagrams, Workflows, Swimlane Diagrams, Screen Mockups)

• Mid-level (2-3 years++)
• Reporting to Lead based in the US

• Work from Home* (Need to come to KL office 1-2 days per month max / working normal KL Hours)
• 13th month salary

Capcon Asia