ETL Developer

The role primarily involves overseeing end-to-end ETL (Extract, Transform, Load) development for multiple projects, ensuring smooth integration. Responsibilities include designing, documenting, and implementing ETL processes and data pipelines, as well as conducting testing and debugging. Collaborating with stakeholders, translating requirements into technical solutions, and addressing challenges alongside technical teams are key aspects. The role also entails coding complex applications, optimizing data pipelines, and establishing best practices. Reporting development progress to management and mentoring junior staff are additional duties. 

• Mandarin speaking is a MUST.
• At least 10 years of working experience in ETL development.
• MUST HAVE Data Extraction, Transformation and Loading (ETL) using Talend (good to have experience in other similar tools such as Informatica 9.x/10.x Power Center, DataStage, SSIS or related technologies) which include hands-on experience of the mentioned areas.
• Advanced understanding of relational databases (Oracle, MySQL, SQL Server, Teradata).
• Expertise in theoretical and practical knowledge of data warehousing and data modelling.
• Highly skilled in SQL technologies (writing, reviewing, and tuning).
• NICE TO HAVE experiences in AWS or similar cloud computing technologies (Microsoft Azure, Google Cloud Platform).
• Expertise in Data Analysis, Data Profiling and SQL Tuning.
• Excellent problem-solving skills, logical process thinking and end-to-end system concepts.
• Broad experience in OLAP/OLTP concepts and terminology.
• UNIX Scripting.

• Primary responsibilities include end-to-end ETL development assignments for multiple integrations/projects.
• Responsible for supporting stakeholders by designing, developing, and documenting ETL processes, technical architecture, and data pipelines.
• Responsible for unit testing, system testing and user acceptance testing and debugging new highly complex software solutions or enhancement to existing software in a maintenance capacity.
• Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.
• Work with technical staff to understand challenges and resolve them.
• Design and code complex applications using routine and/or other advanced technologies.
• Engineer, optimize, fine-tune, and maintain efficient, secure, and reliable data pipelines to clean, ingestion and consolidate data from various sources into the analytics systems.
• Create or enhance administrative, operational, and technical policies and procedures as well as adopting best practice guidelines, standards and procedures.
• Provide development status and process updates to management or leadership.
• Recognized as a technical expert by internal and external peers by demonstrating broad knowledge of technical solutions.
• Assists less experienced/training software development staff.
• May design and create prototype applications, assist, or lead in development of a particular software technical solution.

• Hybrid working arrangement (3 days per month)
• Flexible working hours
• Work-life balance
• Health insurance coverage (including spouse and children)
• Transport allowance
• Integration activity
• Opportunities for promotion (reviewed every year)
• Professional development
• Optical coverage reimbursement
• Additional 2 days of annual leave upon completion every 1 year in Billennium.

Senior/Architect

ETL, Talend, Cloud (AWS/Azure)