Snowflake Data pipeline & Integration Engineer - Senior Manager

STATE STREET CORPORATION; Bengaluru; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

STATE STREET CORPORATION is seeking an AVP – Data Pipeline, Integration & Snowflake Administration Engineering to own and support large-scale data ingestion and Snowflake platform administration. This role focuses on GoldenGate replication, cloud-native pipelines, Snowflake data platform engineering, Databricks BAU support, and production issue triage.

The candidate will design and manage data pipelines, administer Snowflake accounts, implement RBAC and security policies, and optimize

Qualifications

• Strong, hands‑on Snowflake administration and platform management.
• Experience with RBAC, security, data governance.

Responsibilities

• Own and support large-scale data ingestion and replication pipelines.
• Design, build, and support pipelines on Snowflake.
• Provide BAU support for pipelines (ReplHub, GG, DMS, Snowflake).
• Develop data processing components using Python.
• Support Databricks pipelines and workloads.
• Administer Snowflake accounts, warehouses, databases, and schemas.
• Manage RBAC, user provisioning, and security policies.
• Monitor Snowflake performance and query tuning.
• Manage compute/storage cost optimization (auto-suspend, scaling).
• Handle data sharing, replication, failover, and disaster recovery.

Skills

Snowflake admin

RBAC

Performance tuning

GoldenGate

DMS

Python

Databricks

AWS/Azure

Data warehouse architecture

Production triage

Tools

GoldenGate (GG)

DMS

Job description

Job Summary

We are looking for an AVP – Data Pipeline, Integration & Snowflake Administration Engineering to own and support large-scale data ingestion, replication, and Snowflake platform administration. This role will focus on GoldenGate-based replication, cloud-native pipelines, Snowflake data platform engineering & administration, Databricks BAU support, and production issue triage.

Key Responsibilities

• Data Engineering & Pipeline Ownership
• Own and support data ingestion and replication pipelines using GoldenGate (GG), DMS
• Design, build, and support data pipelines and integrations on Snowflake
• Provide BAU support for pipelines (ReplHub, GG, DMS, Snowflake, etc.)
• Develop and maintain data processing components using Python
• Support and enhance Databricks pipelines and workloads
• Snowflake Administration: Administer and manage Snowflake accounts, warehouses, databases, implementation ci/cd deployments and schemas
• Implement and manage role-based access control (RBAC), user provisioning, and security policies
• Monitor and optimize Snowflake performance, query tuning, and workload management
• Manage compute/storage cost optimization strategies (auto-suspend, scaling policies)
• Handle data sharing, replication, failover, and disaster recovery configurations
• Ensure data governance, masking, encryption, network policies and compliance controls
• Manage Snowflake upgrades, configurations, and platform health monitoring
• Integration of SSO for Snowflake, key management DR, failover and replication capabilities for Snowflake Operations & Reliability
• Lead production support, troubleshooting, and root cause analysis for pipeline and platform issues
• Coordinate with cloud teams for performance, scalability, and reliability improvements
• Monitor pipelines and Snowflake workloads for SLAs and operational health
• Support testing, validation, and release activities across environments
• Collaborate with application/business teams for pipeline enhancements and issue resolution

Required Skills & Experience

• Strong, hands‑on experience with Snowflake (MANDATORY) including administration and platform management
• Proven experience in Snowflake administration: RBAC, security, data governance
• Performance tuning and query optimization, Warehouse and cost management, Backup, replication, and DR setup
• Strong experience with GoldenGate (GG) and DMS
• Hands‑on experience with Python
• Experience supporting Databricks in production environments
• Strong understanding of AWS/Azure cloud services
• Experience building and managing data warehouse/lakehouse architectures
• Proven ability to triage and resolve production issues in large-scale data platforms

Preferred Qualifications

• Experience with enterprise‑grade Snowflake platform administration at scale
• Knowledge of data security, governance, lineage, and auditing frameworks
• Familiarity with monitoring/observability tools (e.g., Snowflake Resource Monitors, Query History, etc.)
• Experience in financial data domains and regulatory environments
• Exposure to data quality, reconciliation, and operational monitoring frameworks

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work‑life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work‑life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement