Software Engineer (Python)

1. Position Summary We are looking for a Software Engineer to join our team and contribute to a major project within the semiconductor manufacturing domain. The role involves designing and implementing data pipelines, managing Oracle-based data environments, and supporting end-to-end BI processes — from data ingestion to visualization. This position is based on-site at our partner’s advanced manufacturing facility, offering hands-on exposure to large-scale industrial data systems. 2. Key Responsibilities Design, develop, and maintain Python-based applications and APIs to extract, transform, and deliver data in JSON format. Design and create robust data models to support efficient querying and reporting. Define relationships, hierarchies, and calculated columns/measures that align with business logic. Design, develop, and maintain data pipelines and ETL workflows for manufacturing data (ERP, MES, SPC, FDC, etc.). Implement and optimize database logic, including stored procedures, functions, 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. Ensure data accuracy, consistency, and completeness across multiple source systems. Support data governance, documentation, and performance tuning efforts. Partner with internal and external stakeholders to ensure timely and high-quality data delivery for business use. Perform any ad-hoc duties assigned by the Company as and when required. 3. Qualifications& Skills Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field. Minimum 3 years of experience in data engineering, data integration, or BI development. Proficient in Python programming, specifically for data extraction, API development, and JSON data manipulation. Strong understanding of data warehousing concepts, schema design, and ETL best practices. Solid working experience with relational databases (e.g. Oracle, SQL Server, MySQL, PostgreSQL), including stored procedures and query optimization. Proficient with ETL tools such as Pentaho Kettle, Informatica, Talend, or similar. Experience developing reports and dashboards in Power BI (or Tableau/Qlik). Familiarity with SQL pipelines, data validation, and data replication tools. Strong analytical and problem-solving mindset with attention to data quality and performance. Ability to work collaboratively with business, IT, and engineering teams in fast-paced environments. Excellent documentation and communication skills. 4. Preferred /Additional Experience in semiconductor or manufacturing systems (ERP, MES, SPC, FDC) preferred. Exposure to data replication frameworks (Oracle Golden Gate, SharePlex, AWS Glue) is an advantage. Experience developing custom Python applications/APIs for data extraction and familiarity with JSON data structures is highly preferred. Familiarity with cloud-based data warehouses (Snowflake, Redshift, Synapse) and Giga Report is a plus Knowledge of data governance frameworks, metadata management, and data security best practices.