Oracle

Senior Snowflake & Oracle Golden Gate Data Engineer

Job Description

Responsibilities:

  • Snowflake Data Modeling & Architecture:
    Design, develop, and implement scalable and high-performing Snowflake data models and solutions tailored to meet business and data analytics needs. Implement best practices for Snowflake Data Vault methodology and other Snowflake-specific features.
  • Real-Time Data Replication & Ingestion:
    Manage and optimize data replication using Oracle GoldenGate for Big Data to facilitate real-time data streaming and transformation into Snowflake. Leverage Snowpipe for efficient and automated data ingestion from various sources into Snowflake.
  • Cloud Integration & Management:
    Work with AWS cloud services (e.g., S3, EC2, Lambda) to manage and deploy Snowflake-based data solutions, ensuring smooth integration of cloud resources with Snowflake.
  • Data Sharing & Security:
    Utilize SnowShare to securely share Snowflake data across teams and external partners. Implement robust data security measures, including role-based access control (RBAC), data masking, and encryption, to ensure compliance with industry standards.
  • CI/CD Implementation:
    Implement and manage CI/CD pipelines for Snowflake development and deployment processes, streamlining the delivery of new data models, transformations, and features.
  • Collaboration & Troubleshooting:
    Collaborate with cross-functional teams (data analysts, data scientists, business intelligence teams) to understand data requirements and troubleshoot any data-related issues within Snowflake. Provide support in the resolution of data pipeline challenges.
  • Documentation & Best Practices:
    Develop and maintain comprehensive documentation for data architecture, data flows, ETL processes, and Snowflake configurations to ensure knowledge sharing and alignment across the team. Stay updated on emerging trends and best practices in data engineering and Snowflake technologies.
  • Performance Optimization:
    Continuously optimize the performance of data pipelines, queries, and overall Snowflake architecture for better efficiency and reduced costs.
 

Requirements:

  • Experience:
    4+ years of experience as a Data Engineer or Snowflake Developer, with a focus on Snowflake architecture, data modeling, and data pipeline management.
  • Technical Skills:
    • Proficiency in SQL for writing and optimizing complex queries in Snowflake.
    • Strong experience with Oracle GoldenGate for Big Data for real-time data replication.
    • Knowledge of Snowpipe for automating data ingestion into Snowflake.
    • Familiarity with Snowflake Data Vault methodology for designing data models.
    • Experience with AWS cloud services (S3, EC2, Lambda, IAM) and integrating Snowflake with AWS tools.
    • Knowledge of CI/CD tools (e.g., Jenkins, GitLab) for automating data engineering workflows.
    • Experience with Databricks for data processing and analytics is a plus.
  • Problem-Solving & Communication:
    • Excellent problem-solving skills with a keen attention to detail.
    • Strong communication skills to collaborate effectively with both technical and non-technical stakeholders.
  • Collaboration & Documentation:
    • Ability to work in a team environment and share knowledge with peers.
    • Proven track record in maintaining clear and comprehensive documentation for data architecture, pipelines, and processes.

Career Level - IC3


Jobs at Mumbai

Capgemini

Staffing Manager - D

Experienced Professionals

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

Amazon

GFO Tech, GFO

Freshers/Experienced

Mumbai, Maharashtra

View Details

Last Date: Feb. 11, 2025

Oracle

Senior Advanced Services Engineer, …

Professional

Mumbai, Maharashtra

View Details

Last Date: March 19, 2025

KPMG

KPMG India : Risk-Contract Manageme…

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

KPMG

Technology Consulting-TE Dev - Solu…

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

Amazon

FSI Solutions Arch, FSI Solutions A…

Freshers/Experienced

Mumbai, Maharashtra

View Details

Last Date: Feb. 11, 2025

IBM

Process Analyst- Finance and Admini…

Entry Level

Mumbai, Maharashtra

View Details

Last Date: Feb. 14, 2025

KPMG

Risk Advisory Business Analyst Seni…

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 27, 2025

KPMG

Technology Enablement SAP-GRC Manag…

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

KPMG

Risk Advisory Internal Audit Analyst

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

KPMG

KPMG India: Risk Management : Assis…

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025

KPMG

Executive - SAP-ABAP

KI Professional

Mumbai, Maharashtra

View Details

Last Date: Feb. 5, 2025




More Jobs at Oracle

Oracle

Product Manager/Strategy 1-ProdDev

Campus

Bengaluru, Karnataka

View Details

Last Date: June 8, 2025

Oracle

Principal Member of Technical Staff

Professional

Bengaluru, Karnataka

View Details

Last Date: April 16, 2025

Oracle

Principal Member of Technical Staff

Professional

Bengaluru, Karnataka

View Details

Last Date: May 17, 2025

Oracle

Systems Analyst 2-IT

Professional

Bengaluru, Karnataka

View Details

Last Date: June 16, 2025

Oracle

Oracle Database Administrator

Professional

Bengaluru, Karnataka

View Details

Last Date: May 4, 2025

Oracle

Oracle Database Administrator

Professional

Bengaluru, Karnataka

View Details

Last Date: May 4, 2025

Oracle

Senior Consultant

Professional

Mumbai, Maharashtra

View Details

Last Date: May 4, 2025

Oracle

Senior Principal Oracle DBA with Pe…

Professional

Noida, Uttar Pradesh

View Details

Last Date: March 17, 2025

Oracle

Consulting Technical Manager-Core B…

Professional

Bengaluru, Karnataka

View Details

Last Date: July 5, 2025

Oracle

Principal Member Technical Staff

Professional

Bengaluru, Karnataka

View Details

Last Date: April 1, 2025

Oracle

Senior Quality Assurance Analyst-Pr…

Professional

Hyderabad, Telangana

View Details

Last Date: May 3, 2025

Oracle

Core Banking Implementation/Develop…

Professional

Bengaluru, Karnataka

View Details

Last Date: March 7, 2025