JOB DESCRIPTION
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
Top Skills
What We Do
At Global Blue, we firmly believe that enhancing the shopping experience drives performance.
Our mission is to seamlessly connect shoppers and brands worldwide by simplifying the shopping experience and boosting retailer performance. With over 40 years of industry expertise, we have pioneered Tax Free Shopping and expanded into the Payment and Post-Purchase business.
As a technology partner, we lead our industries with innovative technology and data-driven insights, bringing unparalleled value at every touchpoint along the shopping journey. We support retailers in handling over 35 million Tax Free Shopping transactions every year and our payment partners in elevating the experience of more than 31 million transactions worldwide. Our post-purchase solutions also cater to the needs of over 47m e-commerce shoppers. Listed on the New York Stock Exchange, we generated €20bn Sales in Store and €311M revenue in FY 2022/23.
Our diverse community of over 2,000 employees represent more than 80 nationalities across 53 countries. At Global Blue, we cultivate a culture of empowerment, encouraging our teams to collaborate and support one another.
Together, we innovate, create, and strive towards a brighter future for the businesses we serve.
With Global Blue, enjoy the journey.
