ETL 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

Job Summary

Our client is looking for ETL Analyst Developers to join their team. This role is responsible for all phases of the development process, including analysis, design, construction, testing, implementation, and providing application support while working with ETL technologies and Big Data solutions.

Job Description

• Consults with users, clients and other technology groups on issues and recommends advanced programming solutions.
• Accountable for all phases of development process, analysis, design, construction, testing and implementation.
• Provides user and operational support on applications to business users.
• Solves / works complex problems / projects through in-depth evaluation of business processes, system processes and industry standards; performs root cause analyses.
• Engages in post implementation analysis of business usage to ensure successful system design and functionality.
• Provides sound understanding of Big Data apps development concepts and principles and knowledge of concepts and principles in other technology areas.
• Provides evaluative judgment based on analysis of factual information in complicated and unique situations.
• Directly impacts the business by ensuring the quality of work provided by self and others. Impacts own team and closely related work teams. Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.
• Building/interpreting design documents.
• Building/interpreting mapping documents.
• Building/completing test documents.
• Participate in technical design & code reviews.
• Understand & adhere to ETL best practice.
• Develop & troubleshoot Informatica code.
• Convert SQL scripts from Teradata syntax to GaussDB (PostgreSQL) syntax.

Job Requirements

• Writes advanced SQL including some query tuning.
• Experience in the identification of data quality.
• Some database design experience is helpful.
• Experience designing and building complete ETL (moving and transforming data) in either of these technologies: - SSIS, ODS - ODI, Informatica - Hadoop, Kafka - Data warehousing - Teradata - Oracle - PostgreSQL
• Utilize ad-hoc techniques to perform on-the-fly analysis of data.
• Proficient in how to deploy to and debug a production environment.
• Experience with real time and batch data ingestion frameworks.
• Prefer Data management or data modeling experience within Big Data (Hive/Impala/Hbase).
• Hands on Experience with open source software platforms Linux.
• Agile development processes experience a plus.
• Strong leadership, interpersonal, influence, negotiation, and written and verbal communication skills required.