ETL Engineer

ETL Engineer

Business Unit/Function: Added Value Payment Solutions

Reports to: Micro Strategy Lead

Location: Kuala Lumpur - Malaysia

Job type: Permanent

Workload: 100%

Nature and aim of the position

As a ETL Engineer, your primary responsibilities will be to support the Micro Strategy and the database team and to coordinate with other IT and development teams working on solutions for the business. Therefore, a commitment to collaborative problem solving and quality product is essential.

You will be working as part of the Micro Strategy (BI) SCRUM team (an UoV – Unit of Value).

Main duties and responsibilities

• ETL activities to support the report creation
• Analyse specifications, match new ideas to existing structures
• Ensure the best possible performance, quality, and responsiveness
• Identify bottlenecks and bugs, and suggest & implement solutions to these problems
• Help maintain database/data quality, organization, and automatization
• Work as part of a product development SCRUM team

Reporting and collaboration

• The holder of the position reports to a Micro Strategy Lead.
• The holder of the position manages and works daily with UoV team
• The holder of the position collaborates with the other stakeholders, developers QA testers and Business Units

Key competencies

• Should be well versed with Schema Designs like Star Schema and Snow flake Schema .
• Proficient with DWH concepts like SCD’s, Dimensions, Types of Tables and aggregations .
• Lead, design and develop data warehouse solutions using different architecture, design and modeling techniques.
• Should be proficient with ETL tools like Informatica , Talend , SSIS .
• Design, build, and maintain physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration strategies.
• Recommend improvements to enhance existing ETL and data integration processes to enable performance and overall scalability.
• Strong experience in advanced SQL programming . Good to have PLSQL .
• Should be able to create scripts (Shell ) or Python for Automating the jobs .
• Should be well versed with the RDBS concepts , Json file Transformation and other formats from Source System to Target System loading .
• Should be well versed with On Premise as well as cloud systems.

Preferable skills and competencies

• Demonstrates a strong customer orientation - actively seeks innovative ways to improve processes, products, and user experience
• Proven ability to quickly learn new applications, processes, and procedures
• Good verbal and written communication skills
• Ability to effectively collaborate with others to reach mutually agreeable outcomes
• Ability to work independently as well as with a team.
• Possess a "can do" attitude and positive outlook, minimizing negative behaviours
• Ability to communicate effectively in a multicultural, multinational environment and mobilize cross-functional high-performance teams
• Knowledge Business intelligence Solutions
• Added advantage to have knowledge of payment infrastructure & data structures
• Fluent in English

Education and qualifications

• Computer Science or Engineering degree or relevant work experience
• Solid understanding of Agile (SCRUM) development processes

Experience

• 5+ years of experience in a similar position