I will write, optimize, and fix sql queries for mysql,oracle, and hive

China

I speak Chinese, English

Data Engineer

Data engineer with 8 years of experience in finance-grade production systems. What I deliver: ✅ SQL development & query tuning (MySQL, Oracle, Hive) ✅ ETL pipelines & data warehouse design ✅ Python au...
About this Gig

Im a data engineer with 8 years building production systems in the securities industry, where accuracy and deadlines are non-negotiable.

WHAT YOU GET:

  • Production-ready ETL/ELT pipelines for trade, position, market, reference, or P&L data built in Python/SQL and orchestrated with Airflow, dbt, or cloud-native tools.
  • Clean, documented schemas and data models designed for reconciliation, audit trails, and downstream reporting.
  • Data-quality checks and exception reports to catch breaks, duplicates, missing fields, stale prices, and timing issues before they hit production.
  • Automation or performance tuning that reduces manual Excel work, cuts runtime, and makes daily/periodic loads repeatable.

WHY ME:

8 years delivering data pipelines and reporting for securities firms, including trade processing, positions, market data, and ops/regulatory reporting. I build for accuracy, traceability, and deadlines not just it runs.

REQUIREMENTS please provide:

  • Sample data or anonymized extract (CSV/Excel/JSON/API response)
  • Source and target schema, or field mapping if available
  • Expected output format and business rules (e.g., reconciliation logic, identifiers, timestamps)
  • Delivery deadline and preferre

Database type:

Non-relational database

•

Relational database

Platform:

MySQL

•

Oracle

•

PL/SQL

•

SQLite

Expertise:

Big data

•

Design

•

SQL

•

Query optimization