Etl Engineer (Pentaho)

Esync Software Services; Selangor; On-site; MYR 60,000 - 85,000; Full time

Job summary

A software services company in Malaysia is seeking a professional to perform data extraction and loading. The ideal candidate will have experience with ETL processes and Pentaho, along with strong communication skills. This role involves providing technical expertise and designing data warehouse components. Applicants must possess a bachelor’s degree in computer science or a related field and have 3-5 years of experience.

Qualifications

• 3-5 years of experience in Pentaho.
• Experience running large scale web scrapes.
• Great communication skills in English.

Responsibilities

• Perform data extraction and loading while solving errors.
• Understand input, output, and connection to database.
• Provide expertise for data warehouse design and development.

Skills

Data extraction

Data loading

Salesforce basics

ETL processes

Communication skills

Education

Bachelor’s degree in computer science or related field

Tools

Pentaho

Web scraping tools

Job description

Responsibilities:

• Should be able to perform data extraction, data loading solving the errors, checking filter criteria.
• Understanding on the steps - input, output, and connection to database.
• Understanding on job/transformation, inspecting the data.
• Understanding on salesforce basics - fields, objects, and lookups.
• Knowledge on schema, database, views.
• Provide technical knowledge/expertise to support the requirements definition, design, and development of data warehouse components/subsystems, specifically Extract-Transform Load or Extract-Load-Transform technologies and implementations and/or Change Data Capture technologies and implementations.
• Getting fallout report and analyzing the bugs and errors, should understand how to get output file.
• Research, design, develop, and modify the ETL and related database functions, implementing changes/enhancements to the system.
• Design ETL processes and develop source to target transformations, and load processes.

Requirements:

• Bachelor’s degree in computer science or a related field or the equivalent demonstrated experience
• Must have at least 3 - 5 years of experience in Pentaho
• Experience running large scale web scrapes
• Experience with techniques and tools for crawling, extracting, and processing data.
• Great communication skills (written and Spoken in English)

Good to have:

• Familiarity with system monitoring/administration tools
• Familiarity with version control, open-source practices, and code review