- Coimbatore, Tamil Nadu, India
- Mid
- 5+ years
Design, implement, and maintain robust data models and data exchange solutions supporting manufacturing and plant logistics operations.
Responsibilities
- Design, implement, and maintain logical and physical data models, dimensional schemas (star/snowflake), and data vault structures using Oracle Data Modeler or equivalent tools.
- Actively contribute to and execute end-to-end data modeling and engineering implementation and rollout lifecycles for business-critical operational applications.
- Develop and maintain stored procedures, packages, functions, and triggers in Oracle PL/SQL tailored to business requirements and operational logic.
- Design and implement robust data interface and delta-capture mechanisms, ETL routines, and automated file exchange processes (SFTP/FTP) between ERP, WMS/MES, and downstream data repositories.
- Perform query optimization, indexing strategies, debugging, and execution-plan tuning to ensure high performance and data accuracy.
Requirements
- B.E. / B.Tech / MCA / M.Sc in Computer Science, Information Technology, or a related discipline
- Nice to have: Databricks
- Nice to have: Oracle APEX
- Nice to have: PowerBI