Senior Oracle GoldenGate Data Engineer

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Design, develop, and maintain scalable data pipelines focused on ingestion through CDC (Change Data Capture) utilizing Oracle GoldenGate;

• Configure and oversee real-time and near-real-time data replication between source systems and cloud environments;

• Ensure data consistency, integrity, and synchronization between source and target systems;

• Monitor ingestion pipelines, troubleshoot issues, and enhance CDC process performance;

• Support both full and incremental (delta) load strategies;

• Develop and maintain data processing pipelines leveraging Azure and Databricks (Spark);

• Implement transformations following contemporary data architecture patterns utilizing Bronze, Silver, and Gold layers;

• Optimize pipelines for performance, scalability, and cost efficiency;

• Work with structured and semi-structured data for analytical purposes, reporting, and AI/ML initiatives;

• Collaborate with data architects to outline modern Lakehouse architectures;

• Support initiatives related to data governance, data cataloging, lineage, and compliance;

• Ensure data availability, reliability, security, and quality for downstream usage.

⛳️ Requirements

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related discipline;

• Hands-on, demonstrable experience with Oracle GoldenGate for data ingestion and CDC (Change Data Capture), including both real-time and near-real-time replication;

• Experience in developing, supporting, and optimizing scalable, distributed data pipelines;

• Familiarity with the Microsoft Azure ecosystem, including Azure Data Factory, Azure Data Lake, and Azure Data Lake Storage Gen2;

• Strong understanding of Databricks and distributed processing with Spark;

• Experience with modern data architectures such as Lakehouse, particularly relating to Bronze, Silver, and Gold layers;

• Experience with full and incremental (delta) loads, ensuring data integrity, consistency, and synchronization;

• Knowledge of pipeline monitoring, troubleshooting, performance tuning, and cost optimization in cloud environments;

• Experience handling structured and semi-structured data for analytics, reporting, and AI/ML initiatives;

• Understanding of data governance, data cataloging, lineage, security, and corporate architecture best practices;

• Ability to collaborate effectively with data architects, analytics teams, and business stakeholders.

🏝️ Benefits

• Comprehensive health and wellness benefits;

• Opportunities for professional development and continuous learning;

• Flexible work arrangements to support work-life balance;

• Collaborative and inclusive work environment.