Description
A top-tier financial institution is seeking an:
**Oracle GoldenGate Engineer Middle** to design, implement, and maintain real-time transactional data replication solutions targeting Big Data and Kafka platforms.
Location: Lomas de Chapultepec, CDMX
Modality: Hybrid
Responsibilities:
* **Design and configure GoldenGate solutions (Extract, Pump, Replicat, Trails)**
* Capture changes from transactional sources with precise filters and mappings
* Implement streaming integrations: **Kafka, Confluent, Big Data handlers**
* Manage schema changes: impact assessment, mapping adjustments, testing
* Execute reconciliation, recovery, controlled replays, and re-synchronization
* Verify checkpoints and resolve discrepancies in replication flows
* Collaborate with engineering teams on defining data/event contracts
* Develop technical runbooks and procedural documentation
* Monitor lag, throughput, and error handling
**Requirements (MANDATORY):**
***3–4 years of production experience with Oracle GoldenGate***
Expertise in Extract, Pump, Replicat, and Trail configuration
GoldenGate for Big Data: Kafka/Confluent handlers
Data modeling and understanding of transactional logs
JSON/Avro serialization
Shell scripting for automation
Comparison and reconciliation tools
**English B2 (Intermediate–Advanced)**
Troubleshooting capability in complex environments
Desirable:
Experience in Wealth Management or banking
Experience managing complex schema changes
**Knowledge of Big Data platforms (BigQuery, Spark, etc.)**
Experience in high-availability environments
We offer:
Salary: MXN $60,000–$80,000 gross per month
Modality: Hybrid
Dedicated team assignment
Collaborative environment within a Fortune 500 institution
Opportunity to work with modern data technologies
Salary: $30,000.00–$45,000.00 per month
Benefits:
* Option for indefinite-term contract
* Medical expense insurance
* Major medical expense insurance
* Life insurance
Experience:
* Oracle GoldenGate in production: 3 years (Desirable)
* Extract, Pump, Replicat, and Trail configuration: 2 years (Desirable)
* GoldenGate integrations with Kafka/Confluent: 2 years (Desirable)
Language:
* English Intermediate–Advanced (B2) (Mandatory)
Workplace: Hybrid remote work in Lomas de Chapultepec, CDMX