Oracle SQL Developer

Verinon Technology Solution; Penang; On-site; MYR 70,000 - 90,000; Full time

Job summary

A leading technology firm is seeking an experienced Oracle SQL Developer in Penang, Malaysia. The role involves designing, developing, and maintaining SQL solutions while focusing on semiconductor production data management. The ideal candidate will have strong knowledge of Oracle SQL, ETL processes, and experience within a semiconductor environment. Strong analytical and communication skills are essential. Competitive compensation and professional growth opportunities are provided.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Proven experience as an Oracle SQL Developer, preferably in semiconductor production.
• Hands-on experience with ETL tool development and data integration projects.

Responsibilities

• Design and implement Oracle SQL database schemas for semiconductor production.
• Develop and optimize SQL queries and stored procedures.
• Design, develop, and maintain ETL processes and tools.
• Ensure data integrity and perform data profiling.
• Monitor and optimize database performance.

Skills

Oracle SQL programming

ETL development

Data integration

Database design

Analytical skills

Problem-solving

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica

Talend

Job description

We are seeking a highly skilled Oracle SQL Developer to join our team, focusing on semiconductor production master data management and the development of ETL (Extract, Transform, Load) tools. In this role, you will be responsible for designing, developing, and maintaining SQL-based solutions to ensure the integrity, efficiency, and scalability of our semiconductor production data processes. You will work closely with cross‑functional teams to support data‑driven decision‑making and enhance the overall efficiency of our production systems.

Job Responsibilities

• Database Design & Development:
  • Design and implement robust Oracle SQL database schemas for semiconductor production master data.
  • Develop and optimize complex SQL queries, stored procedures, and functions to support business requirements.
• ETL Tool Development:
  • Design, develop, and maintain ETL processes and tools to ensure accurate and efficient data extraction, transformation, and loading.
  • Collaborate with data architects and engineers to integrate ETL tools with existing data systems.
• Data Management:
  • Ensure data integrity, consistency, and accuracy across all production databases.
  • Perform data profiling, cleansing, and transformation tasks to maintain high data quality standards.
• Performance Optimization:
  • Monitor and optimize database performance, ensuring high availability and scalability.
  • Troubleshoot and resolve performance issues related to SQL queries and ETL processes.
• Collaborate closely with semiconductor production teams to understand data requirements and provide effective solutions.
• Provide technical support and training to end‑users and other team members.
• Documentation & Compliance:
  • Document database designs, ETL processes, and data management procedures.
  • Ensure compliance with industry standards and best practices for data security and privacy.

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience

• Proven experience as an Oracle SQL Developer, preferably in a semiconductor production environment.
• Hands‑on experience with ETL tool development and data integration projects.

Technical Skills

• Proficiency in Oracle SQL and PL/SQL programming.
• Strong understanding of database design principles and data modeling.
• Experience with ETL tools such as Informatica, Talend, or custom ETL solutions.
• Knowledge of data warehousing concepts and methodologies.

Soft Skills

• Excellent problem‑solving and analytical skills.
• Strong communication and collaboration abilities.
• Attention to detail and commitment to high‑quality work.