Oracle GoldenGate Engineer Middle - Real-Time Data Replication

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