2 days ago
Bengaluru, IndiaSenior
Responsibilities
- Design and build batch and near-real-time ELT/ETL pipelines into Snowflake from Azure sources.
- Develop raw, curated, and consumption data models, Dynamic Tables, stored procedures, Snowpark transformations, and optimized SQL.
- Administer Snowflake accounts, databases, schemas, warehouses, resource monitors, and Dev/Test/Prod environments.
- Implement RBAC, network policies, SSO/SCIM, masking, row access policies, tagging, and data governance controls.
- Configure secure Azure integrations including Private Link, storage integrations, Key Vault, and VNet settings.
- Automate infrastructure provisioning and deployments with Terraform and CI/CD pipelines.
- Tune Snowflake performance and manage costs through warehouse sizing, clustering, query profiling, caching, and credit monitoring.
- Build data quality checks, pipeline monitoring, alerting, data protection, recovery, replication, and failover capabilities.
- Collaborate with architects, analysts, BI, and security teams; document standards and support production operations.
Requirements
- At least 7 years of experience.
- Strong hands-on Snowflake data engineering and platform administration experience.
- Advanced SQL and Python skills, including Snowpark and SnowSQL, or equivalent scripting experience.
- Azure experience with ADLS Gen2, Azure Data Factory, Entra ID, Key Vault, and Azure Monitor.
- Experience with Snowpipe, Streams, Tasks, Dynamic Tables, and Secure Data Sharing.
- Experience with Terraform, Git, and CI/CD pipelines.
- Solid understanding of data warehousing, dimensional modeling, and ELT patterns.
- Knowledge of data security, governance, and compliance practices.
Benefits
- Work location is Bangalore.
- Opportunity to work on transformation projects for international and local banks, insurance companies, payment service providers, and other financial-services clients.
- Open and inclusive workplace culture with opportunities for career growth.
Categories
Data EngineeringDevOps
About Capco
Capco is a global technology and management consultancy focused on financial services, helping banks, capital markets, insurance, and wealth firms with digital transformation, risk and compliance, and data/AI-enabled modernization. Founded in 1998 and headquartered in London, it operates as a Wipro company. Its business model centers on project-based consulting, managed services, and solution delivery across strategy, engineering, and platforms for regulated institutions.
