← Back to Cases
Quantitative Finance

Jinghe Information

Deeply engaged in financial big data — migrating from GCP to AWS and building an elastic data lake to power global quantitative analytics and backtesting.

Project Overview

Jinghe Information is a high-tech company focused on financial big data, with its core product being a quantitative financial data platform. Its data spans stocks, funds, research reports, patents, social media and financial news, serving investment institutions, research institutions, academic bodies and regulators around the clock, 365 days a year.

The platform originally ran on GCP, building a data lake on Apache Spark and storing about 25TB of financial data while maintaining a structured database of about 20GB. As the business grew and went global, GCP's cross-region latency, limited elasticity and cost-control issues became increasingly apparent. Jinghe decided to migrate the entire platform to AWS — replacing the Spark cluster with Amazon EMR, using S3 for the data lake, and leveraging AWS's global infrastructure to improve overseas access.

Industry
Quantitative Finance
Services
GCP → AWS Migration
Since
2025

Design DocumentMigration Plan from GCP to AWS

1. Client Introduction

Shanghai Jinghe Information Technology Co., Ltd. focuses on financial big data, providing comprehensive data products and analysis services to the capital market through its self-developed quantitative financial data platform. Its core business includes developing database and software products based on the capital market, as well as offering financial big-data mining, modeling and analysis services.

Jinghe has built a leading financial data warehouse and analytics platform covering stocks, funds, research reports, patents, social media and financial news, with continuous real-time updates. Its products and services are widely used by investment institutions, research institutions, academic institutions and regulators, helping users access timely, accurate and complete financial data and analysis results around the clock.

The platform originally ran on GCP, combining VM clusters and object storage to build a data lake that handled core tasks such as real-time market-data ingestion, historical data cleansing and archiving, quantitative strategy backtesting, and end-user interactive analytics. As the business expanded, issues such as global access latency, insufficient elasticity and cost pressure became prominent.


2. Project Background

Customer Requirements

  1. Migrate entirely to AWS: Move the quantitative financial data platform from GCP to AWS, building an elastic, highly available, cloud-native data infrastructure with global service capabilities.
  2. Strengthen data security & compliance: The platform handles massive market data, trade orders and sensitive financial data, requiring AWS's permission management, encryption and auditing to meet fintech compliance.
  3. Elastic compute & cost optimization: Quantitative analytics and backtesting have clear periodic peaks; the platform should scale dynamically with load and schedule resources on demand.
  4. Global low-latency access: As services extend to overseas financial institutions and research users, multi-region deployment and disaster recovery are needed to ensure end-user experience.

Source Architecture (GCP)

Current GCP Architecture Components
Load Balancing Cloud Load Balancing (global HTTP(S) load balancer), supporting high availability for the front-end web servers and application tier
Application Three-tier architecture; web server and application server deployed on Compute Engine VMs, spec n2-standard-8 (8 vCPU / 32GB RAM)
Database Cloud SQL for MySQL, 8 vCPU / 32GB RAM, highly available primary-standby; total database size ~20 GB
Analytics Based on the Apache Spark open-source framework on GCP VMs, combined with Cloud Storage (GCS) as the data lake, storing market, trade and sentiment data, total ~25 TB

3. Business Requirements

3.1 Core Pain Points

  1. Cross-region latency: GCP has nodes in Japan, but its coverage of Europe, America and Southeast Asia is less dense than AWS, leading to a poor experience for overseas users.
  2. Insufficient elasticity: The Spark cluster ran on fixed-spec VMs — insufficient at peaks, wasted at troughs.
  3. Cost control difficulty: Billing by fixed specs means paying for unused capacity; big-data compute costs stayed high.
  4. Data silos: Structured data in Cloud SQL and unstructured data in GCS meant two storage systems with high management overhead and cross-system retrieval for analytics.

3.2 Optimization Goals

Goal: Build a unified data lake around Amazon EMR + S3, achieving compute-storage separation, elastic scaling and global low-latency access, while meeting financial data security and compliance requirements.

4. AWS Service Mapping

AWS ServicePurposePriority
Amazon EMRReplaces the Spark cluster on GCP as the big-data compute core, supporting Spark, Hive, Presto and moreP0
Amazon S3Replaces GCS as unified data-lake storage for 25TB of historical and incremental dataP0
Amazon RDS (MySQL)Replaces Cloud SQL, holding 20GB of structured business data while keeping the existing app interfaceP1
Amazon EC2Replaces Compute Engine, hosting the web server and application tierP1
Application Load BalancerReplaces Cloud Load Balancing, providing L7 load balancing and health checksP1
Amazon CloudWatchMonitors the running status and performance of EMR clusters, EC2 instances and RDS databasesP2
AWS LambdaAutomated orchestration: data import/export, cluster start/stop, backup schedulingP2
Amazon Route 53DNS resolution and traffic management, supporting multi-region failoverP3
AWS Certificate ManagerSSL certificate management, providing HTTPS encryption for regional servicesP3
AWS KMSData encryption key management, meeting financial data security and complianceP1
Amazon VPCNetwork isolation, dividing private and public subnets, controlling access securityP1

5. Architecture Design

The target architecture is built in the AWS Tokyo region (ap-northeast-1), adopting a compute-storage separated data-lake pattern to support multi-region global access.

Target Architecture Layers
Access Layer
Route 53 ACM Certificate CloudFront (Global CDN) ALB
Application Layer
EC2 (Web/App Server) Auto Scaling VPC Private Subnet
Data Layer
Amazon RDS MySQL Amazon S3 Data Lake AWS KMS Encryption
Compute Layer
Amazon EMR Spark / Hive Spot Instances for Cost Elastic Scaling
Operations & Monitoring
CloudWatch CloudTrail Audit Lambda Automation

Key Design Decisions


6. Non-Functional Requirements

Availability

Core services target 99.9%; EMR clusters support multi-AZ deployment, RDS enables multi-AZ HA, S3 provides 99.99% durability.

Performance

Real-time market data latency from ingestion to queryable < 5 minutes; batch backtests run in parallel; EMR peak throughput handles TB-scale data.

Security

VPC isolation, Security Group least-privilege, KMS encryption, CloudTrail audit — compliant with financial data security standards.

Cost

EMR uses Spot instances for batch jobs and on-demand for real-time; S3 intelligent tiering auto-archives cold data — estimated 30–40% lower compute cost.

Maintainability

Infrastructure as code (CloudFormation/Terraform), automated backup and recovery, monitoring/alerting across all key components.

Scalability

S3 capacity is unlimited; EMR nodes scale dynamically; application-layer Auto Scaling responds automatically to traffic changes.


7. Migration Plan

The overall migration is divided into five phases, expected to complete in 14 weeks. Migrate non-core data first, then core business, and finally cut over traffic.

Phase 1 · Preparation (Week 1-2)
Environment Setup & Baseline Assessment
Set up VPC, subnets and security groups on AWS; create RDS instances with backup strategy; assess current GCP resource usage and data volume, and produce a detailed migration checklist.
Phase 2 · Data Migration (Week 3-6)
Historical Data Migration
Migrate 25TB of data from GCS to S3 using AWS DataSync or AWS Snowball in batches; migrate 20GB from Cloud SQL to RDS via logical backup + incremental sync, ensuring data consistency.
Phase 3 · Application Migration (Week 7-9)
Service Deployment & Integration
Deploy web server and application tier on EC2; build the EMR cluster and verify Spark task compatibility; complete connectivity tests with RDS and S3; update DNS to point to the AWS environment.
Phase 4 · Cutover (Week 10-11)
Traffic Switch & Validation
Gradually shift traffic from GCP to AWS via Route 53 — read traffic first, then write traffic; monitor data consistency and availability throughout, keeping GCP as a rollback backup.
Phase 5 · Wrap-up (Week 12-14)
Optimization & Ops Handover
Tune EMR specs and Auto Scaling; configure CloudWatch alarms; complete ops documentation and contingency plans; decommission GCP once billing stops.

Migration Risks & Mitigations

RiskImpactMitigation
25TB data migration takes longMigration window exceeds planUse Snowball for cold data, DataSync for hot data; migrate in batches, recent data first
Spark task compatibility issuesAnalytics function abnormalRun all historical tasks in a test environment before migration, record and fix differences
Data inconsistency during migrationData loss or duplicationDual-write strategy during migration (GCP + AWS), verify consistency before cutover
Rollback neededBusiness interruptionKeep GCP running 30 days after AWS is stable, switchable back at any time

8. Project Team

Project Manager
Zhang Mingyuan
Oversees project schedule, coordinates client and internal resources
Architect
Li Haoran
AWS architecture design, EMR data-lake solution, migration technical review
Big Data Engineer
Wang Qihang
Spark task migration adaptation, EMR cluster build and tuning
DevOps Engineer
Chen Xiaowei
Automated migration scripts, monitoring/alerting, ops handover

Key Milestones

MilestoneTimeDeliverable
Migration plan approvedWeek 2Architecture design doc, migration plan
Data migration completeWeek 6Data consistency report
Application deployment completeWeek 9Environment acceptance, test records
Cutover go-liveWeek 11Go-live confirmation, monitoring report
Project acceptanceWeek 14Ops documentation, project summary

Need cloud migration or architecture optimization?

We can run a free architecture assessment for you and find cost-saving opportunities.

Contact Us