ETL & Big Data Analyst Developer

Mission Consultancy Services Sdn. Bhd.; Kuala Lumpur; On-site; MYR 67,000 - 134,000; Full time

Job summary

Mission Consultancy Services Sdn. Bhd. is seeking an ETL Analyst Developer to join our client’s team in Kuala Lumpur.

The role covers analysis, design, construction, testing, implementation, and ongoing application support for ETL projects and Big Data solutions. You will work across ETL platforms, including SSIS, ODI, Informatica, Hadoop and Kafka, and translate Teradata/Oracle SQL into GaussDB/PostgreSQL syntax while ensuring data quality and performance.

Qualifications

• Writes advanced SQL including some query tuning.
• Experience in the identification of data quality.
• Experience designing and building complete ETL (moving and transforming data) in SSIS, ODI, Informatica.
• Experience with Hadoop, Kafka, and data warehousing (Teradata, Oracle, PostgreSQL).
• Hands-on Linux/open source platforms experience.
• Strong communication and leadership skills.

Responsibilities

• Consults with users, clients and other technology groups on issues and recommends advanced programming solutions.
• Accountable for all phases of development, analysis, design, construction, testing and implementation.
• Provides user and operational support on applications to business users.
• Solves complex problems by evaluating business and system processes and industry standards.
• Participates in technical design and code reviews.
• Develops and troubleshoots ETL code and tests documents.

Skills

Advanced SQL

Data quality

ETL development

Analytical thinking

Leadership

Communication

Tools

SSIS

Informatica

Hadoop

Kafka

Teradata

Oracle

PostgreSQL

Job description

Mission Consultancy Services Sdn. Bhd. is seeking an ETL Analyst Developer to join our client’s team in Kuala Lumpur.

The role covers analysis, design, construction, testing, implementation, and ongoing application support for ETL projects and Big Data solutions. You will work across ETL platforms, including SSIS, ODI, Informatica, Hadoop and Kafka, and translate Teradata/Oracle SQL into GaussDB/PostgreSQL syntax while ensuring data quality and performance.