
In Progress
Posted
Paid on delivery
Project Title: Data Integration Engine & Job Core Subsystem (Industrial ERP Platform) Executive Summary We are seeking an experienced engineering team / full-stack developer to build an enterprise-grade Data Integration Engine & Job Core Subsystem for an industrial ERP platform. The primary objective is to create a resilient data backbone that ingests, normalizes, reconciles, and synchronizes real-time job data across four primary touchpoints into a unified Single Job View: Quotient Quotes (API & HMAC-verified webhooks) Microsoft SharePoint (MS Graph API file streaming & folder hierarchy) Purchase Orders (POs) (Version control & discrepancy detection algorithms) Email Notifications (Automated event-driven client alerts via SMTP/SMTP2Go) Technical Stack & Scope Overview Backend: Java (Spring Boot / JPA / PostgreSQL) Frontend: [login to view URL] (React / Tailwind CSS) APIs & Protocols: Quotient API, MS Graph API, Webhooks (HMAC SHA-256), SMTP/SMTP2Go Milestone Breakdown & Deliverables Milestone 1: Core Foundation, Schema & Quote Ingestion Engine Task 1: Core Data Model & Relational Schema Design PostgreSQL schema with JPA entities for Jobs, Customers, POs, Drawings, and SharePoint metadata. Rigid state-machine implementation for job workflow statuses with immutable audit logging. Task 2: Manual Job Creation Wizard & Validation Engine Multi-step [login to view URL] UI wizard with dynamic conditional logic (Needs Job Card, install flags). Java REST CRUD endpoints with Spring Data validation and duplicate checking. Task 3: Quotient Webhook Ingestion & Invariant Engine Secure HTTPS endpoint with HMAC SHA-256 signature verification. Atomic database locking on quotient_quote_id for idempotency and duplicate prevention. Milestone 2: File Integration (SharePoint) & Purchase Order Logic Task 4: SharePoint Automatic Folder Provisioning Engine MS Graph OAuth2 authentication, token caching, and auto-refresh mechanisms. Auto-provisioning standard sub-directory hierarchies (Drawings, Photos, POs) upon job creation. Task 5: SharePoint Large File Chunking & Photo Handler Resumable chunked byte-range upload sessions for large CAD/SmartCut files (>4Mb). Specialized photo routing and dynamic manual folder path overrides. Task 6: Purchase Order Versioning & Discrepancy Detection Engine Master job linkage with version tracking (v1,v2,v3) for amended POs. Variance detection engine comparing incoming PO values against original Quotient quote parameters. Milestone 3: Notifications, Unified Dashboard & End-to-End Resilience Task 7: Automated Email Notification Engine Event-driven status listeners triggering client email templates at key milestones. Administrative opt-in/opt-out notification toggles per client. Task 8: Reconciled Single Job View Dashboard & Sync Center Consolidated [login to view URL] dashboard unifying job metadata, SharePoint files, PO histories, and email logs. Real-time integration status badges with manual re-sync capabilities. Task 9: End-to-End Integration Testing & Resilience Engineering Cross-system failure simulation (API outages, network drops, payload edge cases). Performance tuning and response-time optimization. Key Technical Requirements & Qualifications Proven experience with Java backend architecture and multi-threaded background processing. Proficiency in [login to view URL] for building fluid, high-performance UI dashboards. Deep hands-on experience with Microsoft Graph API, chunked file streaming, and OAuth2 integration. Expertise in secure API design (HMAC SHA-256 validation, idempotency patterns, transactional safety). Ability to write robust unit, integration, and failure-mode test suites.
Project ID: 40617808
52 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi there, Four systems each holding part of the truth about a job — Quotient, SharePoint, POs, email — and nowhere they agree. The hard part here isn't any single integration; it's staying reconciled when one of them fails mid-sync. Here's how I'd handle the risky parts: - Quotient webhooks: HMAC SHA-256 verify, then a transactional upsert with a row lock on quotient_quote_id — so a replayed delivery can't double-create a job. - SharePoint: MS Graph OAuth2 with cached, auto-refreshed tokens, and resumable upload sessions for the >4MB CAD/SmartCut files, so a dropped connection resumes instead of restarting. - POs: a version chain per job, variance-checked against the original quote parameters and flagged for review — never auto-applied. - Job status as a real state machine over an append-only audit table. That's what makes the Single Job View trustworthy. I'd start with Milestone 1 alone, so you see the schema and quote ingestion running before you commit to the rest. About us: InnoAI Labs — AI systems and backends, with experience working alongside teams at eBay, Google and Microsoft. Work at [login to view URL] Every build includes 15 days of free post-delivery bug support. One question: do you already have an Azure AD app registration with admin consent for [login to view URL] on the target tenant? That single approval gates all of Milestone 2. Happy to jump on a quick call — when suits you? — Team InnoAI Labs
₹100,250 INR in 10 days
0.6
0.6
52 freelancers are bidding on average ₹91,812 INR for this job

Good to see this project, I will build the Data Integration Engine with Quotient webhook ingestion (HMAC SHA-256 verified), MS Graph API file streaming with chunked uploads for large CAD files, PO version tracking with variance detection, and the unified Single Job View dashboard in Next.js. On a similar Java/Spring Boot integration project, isolating each ingestion pipeline behind its own retry queue eliminated silent data loss during upstream API outages. Questions: 1) For the Quotient webhooks, do you already have a staging API key, or will I register a new integration app? 2) Is the PostgreSQL instance hosted (AWS RDS, Azure) or self managed? Share your current Quotient and SharePoint tenant details and I will map the schema design for Milestone 1 this week. Send me a message and we can go over the details. Best regards, Kamran
₹41,814 INR in 13 days
7.5
7.5

Hi, I’m a Senior Java Backend Developer with 11+ years of experience building enterprise-grade applications using Java, Spring Boot, JPA/Hibernate, PostgreSQL, REST APIs, and distributed backend systems. Your project aligns closely with the type of large-scale systems I've worked on. I have extensive experience designing scalable backend architectures, implementing secure REST services, integrating third-party APIs, handling complex business workflows, and building maintainable enterprise applications. My experience includes: * Java 17+, Spring Boot, Spring Data JPA * PostgreSQL, Liquibase, Hibernate * REST API development and API integrations * Secure authentication and authorization * Background jobs and asynchronous processing * JSON processing, SMTP/email integrations * Docker, Git, CI/CD * Enterprise application architecture and performance optimization I can take ownership of the backend implementation, including: * Designing robust database models * Building scalable Spring Boot services * Implementing secure webhook processing and API integrations * Developing reliable synchronization workflows * Creating production-ready REST APIs with proper validation and documentation * Writing clean, maintainable, and well-tested code I would be happy to discuss the existing architecture, review the project specification, and provide realistic estimates for each milestone.
₹37,500 INR in 7 days
7.3
7.3

Your SharePoint file chunking strategy will fail if you don't implement exponential backoff retry logic for MS Graph throttling errors. Without it, large CAD uploads will silently drop during peak API usage windows. Quick questions - are you enforcing row-level locking on the jobs table during concurrent PO version writes to prevent race conditions? And what's your target SLA for webhook processing latency from Quotient ingestion to database commit? Here is the architectural approach: - JAVA SPRING BOOT: Build idempotent webhook handlers with HMAC SHA-256 verification and distributed locks using PostgreSQL advisory locks to prevent duplicate quote ingestion during retry storms. - MS GRAPH API: Implement resumable upload sessions with chunk retry queues and OAuth2 token refresh middleware to handle 4MB+ SmartCut files without memory overflow or session expiration failures. - POSTGRESQL: Design append-only PO versioning schema with JSONB diff columns and trigger-based audit trails to track discrepancies between quote parameters and amended purchase order values across v1-v3 revisions. I've architected similar multi-source reconciliation engines for 2 manufacturing SaaS platforms processing 10K+ jobs monthly. Let's schedule a 20-minute technical call to validate your concurrency model before implementation starts.
₹50,630 INR in 21 days
7.1
7.1

Hello, I trust you're doing well. I am well experienced in machine learning algorithms, with nearly a decade of hands-on practice. My expertise lies in developing various artificial intelligence algorithms, including the one you require, using Matlab, Python, and similar tools. I hold a doctorate from Tohoku University and have a number of publications in the same subject. My portfolio, which showcases my past work, is available for your review. Your project piqued my interest, and I would be delighted to be part of it. Let's connect to discuss in detail. Warm regards. please check my portfolio link: https://www.freelancer.com/u/sajjadtaghvaeifr
₹66,250 INR in 7 days
4.5
4.5

Hello, I have reviewed your project requirements and understand that you are looking for a robust Java Spring Boot-based data integration subsystem for your ERP platform. I have experience working with Java, Spring Boot, REST APIs, JPA, MySQL/PostgreSQL, JSON, and backend application development. I focus on writing clean, scalable, and maintainable code while following industry best practices. I can contribute to developing secure REST APIs, database design, data validation, API integrations, and backend business logic. I also understand the importance of transactional safety, performance optimization, and clear documentation for enterprise applications. I am available to start immediately and would be happy to discuss the architecture, milestones, and implementation approach in more detail. Thank you for your time and consideration. I look forward to working with you. Best Regards, Abhijit
₹56,250 INR in 7 days
0.0
0.0

i can build this as i have expertise in fullstack developement springboot microservices,react js,REST, system design for more details please connect and i will me doing this in quality standards.
₹90,000 INR in 60 days
0.0
0.0

Hello Sir/Madam, we are a team of senior AI ML Full Stack Web and Mobile App Developers. Please, send me a message to discuss the work and finish in no time. Thanks Ashish Kumar.
₹56,250 INR in 7 days
0.0
0.0

Hi, Your project is exactly the type of enterprise integration work I specialize in. I have 6+ years of experience building scalable Java applications using **Java 17, Spring Boot, JPA/Hibernate, PostgreSQL, REST APIs, OAuth2/JWT, asynchronous processing, and secure API integrations**. I've worked on enterprise platforms involving document management, workflow automation, data synchronization, audit logging, webhook integrations, and third-party API connectivity. My focus is on building resilient, maintainable systems with idempotent processing, transactional integrity, comprehensive testing, and performance optimization. Your requirements around **SharePoint (Microsoft Graph API), HMAC-verified webhooks, PO versioning, unified dashboards, and event-driven notifications** closely match the type of backend architecture I've delivered. I follow clean architecture, CI/CD best practices, and provide well-documented, production-ready code. A few questions: * Is this a new ERP module or an enhancement to an existing platform? * Do you already have the SharePoint folder hierarchy and naming conventions finalized? * Should failed integrations support automatic retries with dead-letter handling? * Are API contracts/UI designs available, or will they be finalized during development? I'd love to discuss the architecture and deliver a robust, scalable solution with clear milestones. Looking forward to hearing from you!
₹56,250 INR in 7 days
0.0
0.0

Lucknow, India
Payment method verified
Member since May 18, 2025
₹37500-75000 INR
₹1500-12500 INR
₹1500-12500 INR
₹750-1250 INR / hour
₹1500-12500 INR
₹600-1500 INR
$15-25 USD / hour
₹1500-12500 INR
₹750-1250 INR / hour
₹37500-75000 INR
$250-750 USD
₹75000-150000 INR
$250-750 USD
₹37500-75000 INR
£75-76 GBP / hour
$15-25 USD / hour
₹1500-12500 INR
₹250000-500000 INR
₹250000-500000 INR
$15-25 USD / hour
₹37500-75000 INR
₹400-750 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour