Informatica Developer
Salary undisclosed
Apply on
Original
Simplified
Job Type: Permanent
Location: Malaysia
Responsibilities
- Design, develop, and implement ETL processes using Informatica PowerCenter.
- Ensure accurate extraction, transformation, and loading of data from various source systems into target databases.
- Develop and optimize SQL queries and stored procedures in Oracle.
- Perform data modeling and database design to support ETL processes.
- Create and maintain Unix shell scripts to automate ETL workflows and data processing tasks.
- Monitor and troubleshoot Unix-based ETL jobs.
- Schedule, monitor, and manage ETL jobs using Control-M.
- Ensure timely execution and completion of ETL processes.
- Implement data quality checks and validation routines to ensure data integrity.
- Maintain documentation for ETL processes, data mappings, and transformations.
- Collaborate with business analysts, data architects, and other stakeholders to understand data requirements.
- Provide support for ETL processes, including troubleshooting and performance tuning.
- Proven experience as an ETL Developer with Informatica PowerCenter.
- Strong proficiency in Oracle SQL and PL/SQL.
- Experience with Unix/Linux operating systems and shell scripting.
- Familiarity with Control-M or similar job scheduling tools.
- Excellent problem-solving skills and attention to detail.
Similar Jobs