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
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
- 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.
- 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.
- Elastic compute & cost optimization: Quantitative analytics and backtesting have clear periodic peaks; the platform should scale dynamically with load and schedule resources on demand.
- 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
- 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.
- Insufficient elasticity: The Spark cluster ran on fixed-spec VMs — insufficient at peaks, wasted at troughs.
- Cost control difficulty: Billing by fixed specs means paying for unused capacity; big-data compute costs stayed high.
- 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 Service | Purpose | Priority |
| Amazon EMR | Replaces the Spark cluster on GCP as the big-data compute core, supporting Spark, Hive, Presto and more | P0 |
| Amazon S3 | Replaces GCS as unified data-lake storage for 25TB of historical and incremental data | P0 |
| Amazon RDS (MySQL) | Replaces Cloud SQL, holding 20GB of structured business data while keeping the existing app interface | P1 |
| Amazon EC2 | Replaces Compute Engine, hosting the web server and application tier | P1 |
| Application Load Balancer | Replaces Cloud Load Balancing, providing L7 load balancing and health checks | P1 |
| Amazon CloudWatch | Monitors the running status and performance of EMR clusters, EC2 instances and RDS databases | P2 |
| AWS Lambda | Automated orchestration: data import/export, cluster start/stop, backup scheduling | P2 |
| Amazon Route 53 | DNS resolution and traffic management, supporting multi-region failover | P3 |
| AWS Certificate Manager | SSL certificate management, providing HTTPS encryption for regional services | P3 |
| AWS KMS | Data encryption key management, meeting financial data security and compliance | P1 |
| Amazon VPC | Network isolation, dividing private and public subnets, controlling access security | P1 |
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
- Unified data-lake storage: Data previously scattered across GCS and Cloud SQL is consolidated into S3 after migration, stored in Parquet/ORC format for direct EMR analysis, eliminating data silos.
- Compute-storage separation: The EMR cluster can scale independently, no longer bound to fixed VM specs — scale out at peaks, release at troughs.
- Multi-region deployment: Core business in the Tokyo region; overseas access served via CloudFront for static content, dynamic requests routed by Route 53 to the nearest region.
- Security & compliance: All data is encrypted in transit and at rest with KMS, and CloudTrail records all operation logs, meeting financial data security audit requirements.
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
| Risk | Impact | Mitigation |
| 25TB data migration takes long | Migration window exceeds plan | Use Snowball for cold data, DataSync for hot data; migrate in batches, recent data first |
| Spark task compatibility issues | Analytics function abnormal | Run all historical tasks in a test environment before migration, record and fix differences |
| Data inconsistency during migration | Data loss or duplication | Dual-write strategy during migration (GCP + AWS), verify consistency before cutover |
| Rollback needed | Business interruption | Keep 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
| Milestone | Time | Deliverable |
| Migration plan approved | Week 2 | Architecture design doc, migration plan |
| Data migration complete | Week 6 | Data consistency report |
| Application deployment complete | Week 9 | Environment acceptance, test records |
| Cutover go-live | Week 11 | Go-live confirmation, monitoring report |
| Project acceptance | Week 14 | Ops 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