Snowflake Integration Engineer / Senior Engineer (Openflow, dbt & Native Snowflake)

Latentbridge; India; Remote; INR 3,000,000 - 5,400,000; Full time

Job summary

LatentBridge is seeking a hands-on Snowflake engineer/architect for a remote role focused on designing and implementing integration and transformation patterns. You will evaluate Snowflake-native processing, Openflow, and Openflow-enabled patterns to replace Informatica PowerCenter workloads where applicable.

Responsibilities include designing ingestion, transformation, and orchestration patterns, performing migration POCs, and optimizing for performance, concurrency, and cost.

Qualifications

• Strong hands-on Snowflake engineering experience.
• Advanced SQL skills and deep understanding of Snowflake architecture and performance.
• Experience migrating workloads from Informatica PowerCenter to Snowflake.
• Knowledge of data orchestration, monitoring, and recovery practices.

Responsibilities

• Assess Informatica workloads proposed for migration into Snowflake.
• Design Snowflake-centric ingestion, transformation and orchestration patterns.
• Implement migration POCs demonstrating Snowflake-based solutions.
• Evaluate Snowflake Openflow integration and when to use it.
• Optimize workloads for performance, concurrency and cost.
• Document reusable implementation patterns from architecture reviews.
• Provide effort estimates and steady-state operating costs.

Skills

Snowflake

SQL

Snowflake Architecture

Data Orchestration

Openflow

Informatica Migration

CDC/Replication

Salesforce Integration

CI/CD for Snowflake

dbt Workloads

Job description

At LatentBridge, we make digital transformation work—without the noise.

We help enterprises simplify the complex, using AI orchestration and intelligent automation to solve real operational challenges. Our focus is on the parts of the business that are often overlooked—compliance, audit, policy, and risk—where precision, scalability, and accountability matter most.

Our products—Epic AI and IntellixCore—are built for this depth.Epic AI delivers enterprise-grade search and knowledge assistance directly inside the tools people already use—making access to information instant and intuitive.

IntellixCore is a platform to build, deploy, and scale intelligent agents across critical workflows—seamlessly integrating with existing systems.

We work with global banks, financial institutions, and legal firms—teams navigating constant change, regulatory pressure, and operational complexity.

In 2024, we were named one of the Deloitte UK Technology Fast 50, recognised for our growth and the tangible impact we deliver.

What sets us apart is not just what we build, but how we build it—grounded in enterprise realities, delivered with clarity, and always focused on outcomes that matter.

Job Description

This is a remote position.

Role Purpose

We are looking for a hands-on Snowflake engineer/architect capable of designing and implementing integration and transformation patterns that can replace appropriate Informatica PowerCenter workloads.

The role will evaluate when workloads should use Snowflake-native processing, dbt, Openflow or adjacent Snowflake capabilities rather than an external integration platform.

Key Responsibilities

• Assess Informatica workloads proposed for migration into the Snowflake ecosystem.
  
• Design Snowflake-centric ingestion, transformation and orchestration patterns.
  
• Implement representative migration POCs.
  
• Design patterns for:
  
• Database/data movement
  
• Batch processing
  
• Micro-batch processing
  
• ELT transformations
  
• Evaluate and implement Snowflake Openflow where appropriate.
  
• Optimize workloads for performance, concurrency and consumption cost.
  
• Design error handling, restart/recovery, reconciliation and observability.
  
• Support approximately 15-minute micro-batch processing scenarios where appropriate.
  
• Evaluate when processing should remain within Snowflake instead of routing through MuleSoft or another middleware layer.
  
• Participate in architecture reviews and document reusable implementation patterns.
  
• Provide implementation effort and steady-state operating-cost inputs.
  

Required Skills

• Strong hands-on Snowflake engineering experience.
  
• Advanced SQL skills.
  
• Strong understanding of Snowflake architecture and performance characteristics.
  
• Experience with:
  
• Tasks
  
• Streams
  
• Stored procedures
  
• File formats and stages
  
• Data sharing
  
• Security and role design
  
• Experience designing production-grade batch and micro-batch processing.
  
• Strong understanding of data orchestration, monitoring and recovery.
  
• Experience optimizing Snowflake consumption and warehouse sizing.
  

Strongly Preferred

• Hands-on experience with Snowflake Openflow.
  
• Experience migrating workloads from Informatica PowerCenter.
  
• Experience with CDC/data replication technologies.
  
• Experience with message/event-driven integration.
  
• Experience with Salesforce/Snowflake integration or Salesforce Data Cloud.
  
• Experience implementing CI/CD for Snowflake and dbt workloads.
  

Experience Level

7-10+ years in data engineering, with at least 4-5 years of significant Snowflake implementation experience.

Requirements

Required Skills

• Strong hands-on Snowflake engineering experience.
  
• Advanced SQL skills.
  
• Strong understanding of Snowflake architecture and performance characteristics.
  
• Experience with:
  
• Tasks
  
• Streams
  
• Stored procedures
  
• File formats and stages
  
• Data sharing
  
• Security and role design
  
• Experience designing production-grade batch and micro-batch processing.
  
• Strong understanding of data orchestration, monitoring and recovery.
  
• Experience optimizing Snowflake consumption and warehouse sizing.
  

Strongly Preferred

• Hands-on experience with Snowflake Openflow.
  
• Experience migrating workloads from Informatica PowerCenter.
  
• Experience with CDC/data replication technologies.
  
• Experience with message/event-driven integration.
  
• Experience with Salesforce/Snowflake integration or Salesforce Data Cloud.
  
• Experience implementing CI/CD for Snowflake and dbt workloads.
  

Experience Level

7-10+ years in data engineering, with at least 4-5 years of significant Snowflake implementation experience.