Data Developer

Krisvconsulting Services Pte Ltd; Kuala Lumpur; On-site; MYR 60,000 - 90,000; Full time

Job summary

A leading company in Kuala Lumpur is seeking a skilled Data Developer to design and maintain ETL processes using Informatica and manage Oracle databases. The ideal candidate will have 3-5 years of experience in data development, strong SQL skills, and a background in Master Data Management. This role involves ensuring data integrity and compliance, along with collaboration with teams to support data-related initiatives.

Qualifications

• 3-5 years of experience as a Data Developer.
• Proficiency in Informatica ETL and Oracle databases.
• Strong SQL skills for querying and performance optimization.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica.
• Manage Oracle databases including data modeling and performance tuning.
• Implement data quality checks and maintain technical documentation.

Skills

Informatica ETL

Oracle databases

ETL tools for Master Data Management

AS 400

Linux

SQL

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Technology

Tools

Informatica PowerCenter

Job description

Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

We are looking for a skilled Data Developer withexpertise in Informatica ETL, Oracle databases, ETL tools for Master Data Management (MDM), AS 400, Linux, and SQL.

Responsibilities:

• Design, develop, and maintain ETL processes using Informatica PowerCenter or similar tools to extract data from various sources, transform it according to business rules, and load it into target systems.
• Manage Oracle databases, including data modeling, schema design, performance tuning, and SQL query optimization.
• Implement and maintain ETL processes for MDM solutions, ensuring data accuracy, consistency, and reliability across the organization.
• Work with AS 400 and Linux systems for data integration, scripting, automation, and system administration tasks.
• Implement data quality checks, data profiling, and data governance processes to ensure data integrity and compliance with standards.
• Create and maintain technical documentation, including ETL process designs, data mappings, data dictionaries, and data lineage.
• Conduct unit testing, integration testing, and support user acceptance testing (UAT) for ETL processes. Provide ongoing support and troubleshooting for data-related issues.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 3-5 years of experience as a Data Developer with expertise in Informatica ETL, Oracle databases, ETL for MDM, AS 400, Linux, and SQL.
• Proficiency in Informatica PowerCenter or similar ETL tools for designing and developing ETL processes.
• Strong SQL skills for querying, data manipulation, and performance optimization.
• Experience with Oracle databases, including data modeling, SQL development, and performance tuning.
• Familiarity with Master Data Management (MDM) concepts and ETL processes for MDM solutions.
• Knowledge of AS 400 and Linux systems for data integration, scripting, automation, and administration.
• Understanding of data quality, data governance, and data warehousing concepts.
• Excellent communication and collaboration skills to work effectively with teams and stakeholders