
ETL Developer
RM 13,000 - RM 15,999 / month
Checking job availability...
Original
Simplified
Role and Responsibilities 1. Able to understand and analyze user requirement to perform development of new data marts or enhancements to existing data marts applications. 2. Perform design of simple data models and development of extraction, loading and transformation (ETL) rules based on user requirements 3. Prepare technical design specifications based on the projects and change request assigned 4. Assist in establishing a set of consistent BI skills, standards, and best practice as well as the evaluation of BI and analytical software 5. Evaluate potential technical solutions and make recommendations to resolve business problems. 6. Involvement in the system integration testing phase prior to implementation. 7. Liaise closely with business analysts and build good rapport. 8. Liaise closely with vendors in project implementation, application testing, supporting application patches and upgrades in accordance with project methodologies and policies. 9. Support the team in defining project requirements, tracking and documentation. 10. Provide guidance and coaching to junior team members. Requirements / Qualifications Strong skillset in ETL: Informatica PowerCenter. Database: Oracle. Linux scripting. Thorough understanding of data warehouse principles and dimensional design is also expected Prior work on ETL rules, data modelling and design with any of the BI Applications is strongly preferred Very strong SQL skills using Oracle and SQL Server databases Ability to diagnose and troubleshoot problems with ETL processes Experience in MS Windows environment & application support. Strong analytical skills and ability to work independently. Experience in healthcare industry is an added advantage. Degree in Computer Science, Computer Engineering or equivalent. Experience with any of the ETL tools preferably Informatica / SAP BODS and any BI reporting tools preferably OBIEE / Tableau