• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 14th Nov 2025

This project aims to implement a semantic layer over multiple disparate data sources—Epicor, Shop Floor Connect, and Visibility—by leveraging Apache Calcite's schema discovery capabilities. The semantic layer will provide a unified, business-friendly view of the data, simplifying data access for end-users such as sales representatives, managers, and analysts.

Project Objectives:
• Automatic Detection of Data Structures: Utilize Apache Calcite's schema
discovery to automatically understand the structure of the underlying databases,
reducing manual ePort.
• Unified View of Disparate Systems: Create a unified logical schema that integrates data from Epicor, Shop Floor Connect, and Visibility.
• Mapping Business Concepts to Data: Map business concepts onto the underlying technical data structures to build a semantic layer.
• Simplifying Query Creation and Optimization: Provide an easy-to-use interface for querying data without needing technical knowledge.
• Federated Queries Across Multiple Data Sources: Enable retrieval and joining of
data from diPerent databases in a single query.
• Enhancing Flexibility and Scalability: Ensure the semantic layer adapts dynamically to changes in the underlying data schemas.

Project Scope:
• Data Sources:
o Epicor: Sales and financial data.
o Shop Floor Connect: Production data.
o Visibility: Business intelligence and reporting data.
• Technologies: Apache Calcite, database connectors, and ETL tools as needed.
• Deliverables: Operational semantic layer, documentation, training materials, and
deployment plans.