Programmer/IT Analyst I-Oracle SQL Developer (1 year Contract)

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.

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.

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.

Documentation Compliance:Document database designs, ETL processes, and data management procedures.

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

Qualifications

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.

Additional Information

Renesas Electronics Corporation empowers a safer, smarter and more sustainable future where technology helps make our lives easier. The leading global provider of microcontrollers, Renesas combines our expertise in embedded processing, analog, power and connectivity to deliver complete semiconductor solutions. These Winning Combinations accelerate time to market for automotive, industrial, infrastructure and IoT applications, enabling billions of connected, intelligent devices that enhance the way people work and live. Learn more at www.renesas.com .

Renesas’ mission, To Make Our Lives Easier, is underpinned by our company culture, TAGIE. TAGIE stands for Transparent, Agile, Global, Innovative and Entrepreneurial. Our goal is to embed this unique culture in everything we do to succeed as a company and create trust with our diverse colleagues, customers and stakeholders.

Renesas Electronics is an equal opportunity and affirmative action employer, committed to supporting diversity and fostering a work environment free of discrimination on the basis of sex, race, religion, national origin, gender, gender identity, gender expression, age, sexual orientation, military status, veteran status, or any other basis protected by law. For more information, please read our Diversity Inclusion Statement .

Department Manufacturing

Location Bayan Lepas

Remote No

Requisition ID

20014311_2024-08-13

Apply

Shortlist