Oracle SQL Developer

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.

1. 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.

2. 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.

3. 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.

4.Performance Optimization:

Monitor and optimize database performance, ensuring high availability and scalability.

Troubleshoot and resolve performance issues related to SQL queries and ETL processes.

5.Collaboration & Support:

Work 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.

6. Documentation & Compliance:

Document database designs, ETL processes, and data management procedures.

Ensure compliance with industry standards and best practices for data security and privacy.

Requirements

1.Education:

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

2.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.

3.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.

4.Soft Skills:

Excellent problem-solving and analytical skills.

Strong communication and collaboration abilities.

Attention to detail and commitment to high-quality work.