ASIAPOWER OFFICE TIMING: 10.00 AM TO 6.30 PM (MONDAY TO SATURDAY)
Job Purpose:
The purpose of this role to plan, design, build, test, and maintain the integrations and web services between Company group applications and data lake to meet the needs of critical business processes for Company business users.
Key Accountabilities:
Responsibilities:
-Responsible for delivering data warehouse and analytic solutions by writing ETL packages, developing visualizations, performing data and statistical analyses, and administering systems to deliver information to the health system.
-Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures.
-Works collaboratively with and supports multi-departments efforts and projects.
-Evaluates data quality and interprets results in a clear, concise manner.
-Develops documentation on requirements, decisions, design, modifications, and any associated maintenance.
-Develop quality standards to ensure data quality and integrity across various database systems.
-Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.
-Develop data integration standards according to the organization’s data policies as well as best practices.
-Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
-Follow Company guidelines for programming and documentation.
-Prepare reports and presentations to share insights and findings with business units.
-Any other tasks as may be assigned from time to time
Qualifications & Experience:
Qualifications
-Bachelor’s Degree in Computer Science, Applied Mathematics, Statistics, Engineering, Physics with A Quantitative Emphasis.
-Professional Qualification / Certification From Related Professional Body Is Preferred.
Experience
-Minimum 5 years of experiences with ETL, database and business intelligence analytics.
-Experience using SQL for data extraction, manipulation, and reporting.
-Strong knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures.
-Experience in reporting and data visualization tools like Oracle Data Visualization, Microsoft Power BI, Tableau etc.
-At least 3 years of experience in data integration tools like Oracle Data Integrator (ODI), SSIS and Talend.
-Experience in designing and implementing the E-LT architecture that is required to build a data warehouse, including source-to-staging area, staging-to-target area, data transformations, and EL-T process flows.
-Exposure towards Oracle Cloud Infrastructure (OCI) is preferable.
-Knowledge in Oracle Analytics Cloud to Explore data through visualizations, load, and model data.
-Hands-on experience of ODI 12c would be an added advantage.
-Good understanding of SAP ERP and processes.
Skills:
-Proficient in Arabic and English (Spoken & Written).
-Working knowledge of Oracle Data Integrator (ODI) and OAC
-Working knowledge of the Programming Languages like .Net, PHP, Java.
-Ability to work on multiple projects simultaneously and with minimal supervision.
-Familiarity with RPA tools like Automation Anywhere is a plus.
-Strong analytical, problem-solving and diagnostics skills
-Ability to work under tight timelines, in cases for multiple project deliveries.
-Evidence of self-motivation for continuous development.
-Team player & open minded