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
Educational qualification
B.E. / B.Tech / MCA / M.Sc in Computer Science, Information Technology, or a related discipline.
