Data Consultant - Logistics

TigerHire

Coimbatore District

On-site

INR 1,000,000 - 1,800,000

Full time

13 days ago

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TigerHire is seeking a mid-level Data Consultant to design, implement, and maintain robust data models and data exchange solutions for manufacturing and plant logistics operations. You will translate operational workflows into logical, physical, and dimensional models while developing Oracle PL/SQL mechanisms and data integration pipelines.

The role requires 5+ years of hands-on experience in data modeling, engineering, and database development, with a focus on data integration and performance

Qualifications

  • 5+ years of hands-on experience in data modeling, engineering and database development.
  • Experience in manufacturing operations, supply chain, or plant logistics domain preferred.
  • Strong knowledge of dimensional modeling, data vault structures, and data integration concepts.

Responsibilities

  • Design, implement, and maintain logical and physical data models including dimensional schemas (star/snowflake).
  • Develop and maintain Oracle PL/SQL mechanisms, stored procedures, packages, and triggers.
  • Build robust data interfaces, ETL workflows, and delta-capture mechanisms (SFTP/FTP) between ERP, WMS/MES, and downstream repositories.
  • Perform query optimization, indexing strategies, and execution-plan tuning for data accuracy and performance.
  • Utilize utilities like SQL*Loader and Data Pump for initial loads and migrations.
  • Collaborate with cross-functional teams to gather requirements and define data dictionaries.

Skills

Data Modeling
Oracle PL/SQL
ETL
Data Vault
Star/Snowflake Schemas
SQL Tuning
Stakeholder Communication

Education

B.E./B.Tech / MCA / M.Sc in CS/IT

Tools

Oracle Data Modeler
SQL*Loader
Data Pump

Job description

Overview We are seeking a mid-level Data Consultant to design, implement, and maintain robust data models and data exchange solutions supporting manufacturing and plant logistics operations. In this role, you will work hands-on with business and functional teams to translate operational supply chain workflows into logical, physical, and dimensional models, while developing the underlying Oracle PL/SQL mechanisms and data integration pipelines.

  • Data Modeling & Architecture: Design, implement, and maintain logical and physical data models, dimensional schemas (star/snowflake), and data vault structures using Oracle Data Modeler or equivalent tools.
  • Implementation Projects: Actively contribute to and execute end-to-end data modeling and engineering implementation and rollout lifecycles for business-critical operational applications.
  • Database Programming & Customization: Develop and maintain stored procedures, packages, functions, and triggers in Oracle PL/SQL tailored to business requirements and operational logic.
  • Data Integration & Exchange: 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.
  • Performance Tuning & Debugging: Perform query optimization, indexing strategies, debugging, and execution-plan tuning to ensure high performance and data accuracy.
  • Data Movement & Utilities: Leverage database utilities such as SQL*Loader, Data Pump, and export/import tools for initial loads, migrations, and regular feeds.
  • Stakeholder Consulting: Work closely with cross-functional logistics teams and business analysts to gather requirements, establish data dictionaries, and validate business rules.
Experience

5+ years of hands-on experience in data modeling, engineering and database development, including participation in at least 1–2 implementation projects.

Title: Data Consultant – Data Modeling Experience Level: 4 – 6 Years (5+ years preferred) Domain: Manufacturing Operations, Supply Chain & Plant Logistics Practice Area: Data Solutions & Consulting (Application/Solution Modeling)

Mandatory/requires Skills
Data Modeling Paradigms

Strong conceptual and practical knowledge of dimensional, logical, and physical data modeling; understanding of Data Vault architecture is a strong plus.

Practical proficiency with Oracle Data Modeler or equivalent modeling tools

Oracle & SQL Development

Strong hands-on proficiency in SQL and advanced PL/SQL (stored procedures, packages, functions, triggers).

Strong RDBMS fundamentals, schema design, and constraints management.

Solid working knowledge of SQL*Loader, Data Pump, and data movement utilities.

Proven debugging techniques and query/performance tuning methodologies.

Integration & Automation: Experience building data interfaces, ETL workflows, SFTP/FTP data transfer mechanisms, and basic automation scripting.

Domain Knowledge (Preferred): Working knowledge or exposure to manufacturing logistics, plant supply chain, inventory movement, or warehousing (WMS/ERP interfaces).

Interpersonal Skills: Strong oral and written communication skills with the ability to articulate technical data designs to business and functional teams.

Preferred Skills
  • Databricks, Oracle APEX, PowerBI
  • B.E. / B.Tech / MCA / M.Sc in Computer Science, Information Technology, or a related discipline.
  • Bosch Global Software Technologies Private Limited is a 100% owned subsidiary of Robert Bosch GmbH, one of the world's leading global supplier of technology and services, offering end-to-end Engineering, IT and Business Solutions. With over 27,000+ associates, it’s the largest software development center of Bosch, outside Germany, indicating that it is the Technology Powerhouse of Bosch in India with a global footprint and presence in the US, Europe and the Asia Pacific region.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Consultant - Logistics
Data Consultant - Logistics

Bosch Group • Coimbatore District

On-site
INR 1,200,000 - 1,800,000
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Pradeepit Global Consulting Private Limited • Bengaluru

Hybrid
INR 1,800,000 - 3,000,000
Engineer Data Engineering & Analytics
Engineer Data Engineering & Analytics

Vishay Israel • Pune

On-site
INR 1,500,000 - 2,300,000
Technical Consultant-Data Modeler
Technical Consultant-Data Modeler

Titan Company • Bengaluru

Hybrid
INR 1,800,000 - 3,000,000
Data Technology Consultant
Data Technology Consultant

EPAM Systems Inc • Coimbatore District

On-site
INR 4,500,000 - 8,500,000
Data Technology Consultant
Data Technology Consultant

EPAM Systems Inc • Hyderabad

On-site
INR 400,000 - 700,000
Powerful data tooling experience
Data Engineering & Agentic AI
Data Engineering & Agentic AI

Bosch • Karnataka

On-site
INR 1,200,000 - 2,400,000
Data Engineer
Data Engineer

CapeStart • Chennai

On-site
INR 900,000 - 1,400,000
Data Architect
Data Architect

Techdome • Hyderabad

On-site
INR 2,500,000 - 4,200,000
Data Technology Consultant
Data Technology Consultant

EPAM Systems Inc • Maharashtra

On-site
INR 4,000,000 - 6,500,000