Data Engineer
Core
Designing and implementing data pipelines and managing Oracle-based data environments to support end-to-end BI processes in semiconductor manufacturing.
Role type
Data Engineer
Builds
Data pipelines, data marts, and dimensional models for manufacturing analytics
Domain
Semiconductor manufacturing / Industrial data systems
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data warehousing concepts, ETL best practices, Relational database management (Oracle, SQL Server, MySQL, PostgreSQL), Stored procedures and PL/SQL, ETL tools (Pentaho Kettle, Informatica, Talend), Power BI development, Data validation and replication
Preferred skills
Semiconductor or manufacturing systems knowledge (ERP, MES, SPC, FDC), Data replication frameworks (Oracle Golden Gate, SharePlex, AWS Glue), Cloud-based data warehouses (Snowflake, Redshift, Synapse), Giga Report
Technologies
Oracle, SQL Server, MySQL, PostgreSQL, Pentaho Kettle, Informatica, Talend, Power BI, Tableau, Qlik, Oracle Golden Gate, SharePlex, AWS Glue, Snowflake, Redshift, Synapse, Giga Report
Responsibilities
Design and create robust data models for efficient querying and reporting; Design, develop, and maintain data pipelines and ETL workflows for manufacturing data; Implement and optimize database logic including stored procedures and PL/SQL scripts; Build and manage staging schemas, data validation processes, and data transformation logic; Develop and maintain data marts and dimensional models to support analytics and reporting; Collaborate with BI developers and analysts to deliver Power BI dashboards, KPI reports, and visual analytics
Seniority
Mid-level, hands-on IC
