Company Name

Oracle India Pvt Ltd ( Bangalore,Mumbai )

Job Description

• Responsibilities:
  • Snowflake Data Modeling & Architecture: Design and implement scalable Snowflake data models using best practices such as Snowflake Data Vault methodology.
  • Real-Time Data Replication & Ingestion: Utilize Oracle GoldenGate for Big Data to manage real-time data streaming and optimize Snowpipe for automated data ingestion.
  • Cloud Integration & Management: Work with AWS services (S3, EC2, Lambda) to integrate and manage Snowflake-based solutions.
  • Data Sharing & Security: Implement SnowShare for data sharing and enforce security measures such as role-based access control (RBAC), data masking, and encryption.
  • CI/CD Implementation: Develop and manage CI/CD pipelines for Snowflake deployment and data transformation processes.
  • Collaboration & Troubleshooting: Partner with cross-functional teams to address data-related challenges and optimize performance.
  • Documentation & Best Practices: Maintain detailed documentation for data architecture, ETL processes, and Snowflake configurations.
  • Performance Optimization: Continuously monitor and enhance the efficiency of Snowflake queries and data pipelines.
  Mandatory Skills:
  1. Strong expertise in Snowflake architecture, data modeling, and query optimization.
  2. Proficiency in SQL for writing and optimizing complex queries.
  3. Hands-on experience with ETL Pipeline  
  4. Knowledge of Snowpipe for automated data ingestion.
  5. Familiarity with AWS / Any cloud services and their integration with Snowflake.  
  6. Experience with CI/CD tools (e.g., Jenkins, GitLab) for automating workflows.
  Good to Have Skills:
  1. Exposure to Databricks for data processing and analytics.
  2. Knowledge of Python or Scala for data engineering tasks.
  3. Familiarity with Terraform or CloudFormation for infrastructure as code (IaC).
  4. Experience in data governance and compliance best practices.
  5. Understanding of ML and AI integration with data pipelines.
  6. Working knowledge of Snowflake Data Vault methodology.
  7. Good to have knowledge on Oracle Golden Gate.

Job Details

Education Summary

Contact Details