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#J-18808-Ljbffr