JOB OVERVIEW:
We are seeking a highly skilled Oracle SQL Developer to support semiconductor production master data management and ETL (Extract, Transform, Load) tool development. You will play a key role in building reliable, scalable, and efficient data systems that power mission-critical production processes.
KEY RESPONSIBILITIES:
1. Database Design & Development
- Design and implement Oracle SQL database schemas for semiconductor production master data.
- Develop and optimize complex SQL queries, stored procedures, and functions to meet business requirements.
2. ETL Development
- Design, build, and maintain ETL pipelines for accurate and efficient data extraction, transformation, and loading.
- Collaborate with architects and engineers to ensure seamless integration with existing systems.
3. Data Management
- Ensure data integrity, consistency, and accuracy across production databases.
- Perform data profiling, cleansing, and transformation to maintain high-quality data.
4. Performance Optimization
- Monitor and fine-tune database performance for high availability and scalability.
- Troubleshoot SQL/PLSQL and ETL performance issues.
5. Collaboration & Support
- Work closely with semiconductor production teams to understand data needs and provide effective solutions.
- Offer technical guidance, documentation, and training as needed.
6. Documentation & Compliance
- Document database structures, ETL workflows, and data processes.
- Ensure compliance with industry standards and data security best practices.
REQUIREMENTS:
Education
- Bachelor's Degree in Computer Science, Information Technology, or a related field.
Experience
- Proven experience as an Oracle SQL Developer (semiconductor industry experience is a strong advantage).
- Hands-on experience with ETL development and data integration initiatives.
Technical Skills
- Strong proficiency in Oracle SQL and PL/SQL.
- Solid understanding of database design, data modeling, and data warehousing concepts.
- Experience with ETL tools (Informatica, Talend, or custom ETL frameworks).
Soft Skills
- Excellent analytical and problem-solving skills.
- Strong communication and teamwork abilities.
- Detail-oriented with a focus on quality and accuracy.
BENEFITS:
- Medical & insurance coverage
- Annual leave, medical leave & public holidays
- Professional development
- Supportive, collaborative work culture
- Career growth
