Data Developer

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