Product Support Specialist L2/L3 (Informatica, Teradata, Hadoop platforms)

Tentacle Technologies; Kuala Lumpur; On-site; MYR 80,000 - 110,000; Full time

Job summary

A leading technology solutions provider in Kuala Lumpur is seeking an experienced candidate for a support role focused on ETL processes and data warehousing. The ideal applicant will have 6-10 years of experience and strong skills in Informatica, Hadoop, and SQL, with hands-on experience in troubleshooting, shell scripting, and interaction with users. This position requires flexibility for long working hours and on-call support.

Qualifications

• 6-10 years of experience in a related field.
• Must be flexible for long working hours in a support model.

Responsibilities

• Monitor jobs/workflow and work with technical teams to derive permanent fixes.
• Build and troubleshoot Informatica mappings.
• Manage ETL processes and data warehousing platforms.
• Write, debug, and test shell scripts.
• Interact with technical and non-technical users and address their queries.

Skills

Informatica troubleshooting

Teradata utilities

Hadoop databases

SQL

Shell scripting

Analytical skills

Education

Bachelor's Degree in IT/Computer Science/Engineering

Tools

Oracle Data Integrator

Java

Python

Any Scheduling tool

Job description

Overview

Should be able to troubleshoot errors on Informatica, Teradata, Hadoop platforms and support applications built on top of it.

Strong problem solving knowledge on databases like Hadoop, Teradata & SQL.

Responsibilities

• Monitor jobs/workflow and work with technical teams to derive permanent fixes.
• Hands-on experience in building and troubleshooting Informatica mappings.
• Handle and manage ETL processes and data warehousing platforms.
• Hands-on experience in writing, debugging, and testing shell scripts.
• Hands-on experience in Teradata utilities like BTEQ, FastLoad, MultiLoad, TPT.
• Experience in writing, debugging, and testing Hive scripts.
• Hands-on experience in any scheduling tool.
• Ability to logically prioritize tasks and schedule work accordingly.
• Deep understanding of data warehouse concepts.
• Hands-on experience in processes like incident management, problem management and change management.
• Should be a good team player and an individual contributor.
• Should be able to interact with both technical and non-technical users and address their queries.
• Strong analytical and problem-solving skills.
• Good working experience in a support role.
• Should be flexible for long working hours and be ready to work in 16x7 shift or on-call support.

Qualifications

• Education: Bachelor Degree / Master in IT/Computer Science / Engineering or related discipline
• Experience: 6-10 years
• Job-specific skills & competencies: Must have hands-on Oracle Data Integrator, Big Data/Hadoop, Java/Python, UNIX Shell scripting, Any Scheduling tool, and be ready to work in a Support Model (16X7) on rotation basis.