Data Warehouse Analyst Programmer (ETL)

Swing Consulting Ltd.; Hong Kong; On-site; HKD 334,800 - 502,200; Full time

Job summary

A data consulting firm in Hong Kong is seeking a Data Warehouse Analyst Programmer to conduct user requirement analysis, implement efficient data pipelines, and support user acceptance testing. The ideal candidate has a degree in Computer Science, at least 4 years of IT experience with 2 years in ETL development, and strong programming skills in Python and Java. Hands-on experience with ETL tools and cloud platforms is advantageous. This role offers a dynamic work environment and opportunities for growth.

Qualifications

• Minimum 4 years of IT experience with at least 2 years in data warehousing/ETL development.
• Hands-on experience with ETL tools such as Informatica PowerCenter and SSIS.
• Solid programming skills in Python/Java and Oracle PL/SQL.
• Experience in cloud platforms like AWS or GCP is an advantage.
• Experience in visualization tools like Tableau or Google Data Studio is an advantage.

Responsibilities

• Conduct user requirement analysis, design and implement data layer for analysis and reporting.
• Implement efficient data pipelines to transform data from multiple sources (ETLs).
• Support User Acceptance Testing.
• Provide ongoing user support on Data warehouse.

Skills

User requirement analysis

ETL development

Data transformation

User Acceptance Testing

Ongoing user support

Programming skills in Python

Programming skills in Java

Oracle PL/SQL

Education

Degree in Computer Science or equivalent

Tools

Informatica PowerCenter

SSIS

AWS

GCP

Tableau

Google Data Studio

QlikView

Job description

SW8354 |24 Aug 2022 Data Warehouse Analyst Programmer (ETL)

• Conduct user requirement analysis, design and implement data layer for analysis and reporting
• Implement efficient data pipelines to transform data from multiple data sources (ie ETLs)
• Support User Acceptance Testing
• Provide ongoing user support on Data warehouse

• Degree in Computer Science or equivalent
• Minimum 4 years of IT experience with at least 2 years in data warehousing/ ETL development
• Hands on experience with ETL tools such as Informatica PowerCenter, SSIS
• Solid programming skills in Python/Java and Oracle PL/SQL
• Experience in cloud platform would be an added advantage, e.g. AWS, GCP
• Experience in visualization tools would be an added advantage, e.g. Tableau, Google data studio, QlikView