WebEx Events ↔ HubSpot Integration Platform
Cloud-based integration system synchronizing WebEx Events (GraphQL) with HubSpot (REST) using AWS infrastructure
Overview
Designed, developed, and maintained a cloud-based integration platform that synchronized data between WebEx Events (GraphQL) and HubSpot (REST) using AWS infrastructure. Served as the sole developer and backend architecture designer, responsible for building and maintaining the full synchronization system, including infrastructure, pipelines, reliability systems, and client-facing documentation.
Responsibilities
- AWS infrastructure management
- Synchronization pipeline development
- Retry and recovery systems
- Error and response-status handling
- Monitoring and logging systems
- QA test design and validation workflows
- Technical documentation for internal teams and clients
- Webhook implementation
Challenges
Rolling ID Synchronization Drift
- GraphQL system used rolling IDs causing relational instability
- Continuous mapping drift between systems over time
Third-Party API Constraints
- Incomplete and outdated API documentation
- Unclear edge-case behavior in external systems
Rate Limiting Constraints
- Aggressive API rate limits impacting synchronization throughput
- Need for optimized request batching and tracking
Schema Normalization
- Mismatch between GraphQL and REST data models
- Required unified schema layer for consistent synchronization
Human Configuration Error
- Inconsistent label naming during manual configuration
- Need for resilience against user-side data entry mistakes
Solutions
- Built reconciliation database to track and map unstable identifiers
- Developed synchronization tracking system to reduce redundant API calls and mitigate rate limits
- Created normalized schema layer using label-based property mapping
- Implemented fuzzy-matching validation to handle human input inconsistencies
- Designed detailed client-facing documentation covering workflows, troubleshooting, and system limitations
Results
- Reduced synchronization failure rates by up to 95%
- Reduced processing time by approximately 60%
- Simplified operational workflows for clients and internal teams
- Supported synchronization of several thousand records daily
- Improved system resilience and recovery from partial failures
Tech Stack
Python • Node.js • GraphQL • REST APIs • AWS • DynamoDB