Snowflake Developer - R01568220 at Brillio (Bengaluru, India)
Brillio· Bengaluru, India·
Role details
Work type
Hybrid
Job description
Data Specialist
Primary Skills
- Snowflake, Airflow, DBT
Specialization
- Snowflake Lead Developer
Job requirements
Key Responsibilities
Project Type: L3 Support
Flexibility to shift working is Mandatory.
Development Responsibilities
- Design and develop scalable data pipelines and modern data architectures using Snowflake.
- Lead migration initiatives from legacy databases to Snowflake.
- Build and optimize ELT frameworks using DBT.
- Develop and orchestrate workflows using Apache Airflow.
- Design and implement data models, including Star Schema and Snowflake Schema.
- Develop ingestion pipelines for structured and semi-structured data.
- Create reusable frameworks for data validation, reconciliation, auditing, and monitoring.
- Optimize Snowflake objects, including:
- Virtual Warehouses
- Clustering Keys
- Materialized Views
- Streams & Tasks
- Dynamic Tables
- Develop technical design documents and migration runbooks.
- Perform code reviews and enforce engineering best practices.
Migration Responsibilities
- Assess and migrate data from legacy platforms, including:
- Oracle
- SQL Server
- Teradata
- Netezza
- DB2
- SAP HANA
- On-Prem Data Warehouses
- Perform source system analysis and database rationalization.
- Design migration strategies, including:
- Full Data Loads
- Incremental Loads
- CDC (Change Data Capture)
- Historical Data Migration
- Conduct data reconciliation and validation during migration.
- Optimize transformed workloads for Snowflake architecture.
- Execute cutover planning and post-migration stabilization.
Good to have:
AMS / Production Support Responsibilities
- Provide L3 support for Snowflake data platforms and pipelines.
- Monitor and manage production data workloads.
- Troubleshoot data failures, performance issues, and pipeline disruptions.
- Perform root cause analysis (RCA) and implement permanent fixes.
- Support incident, problem, change, and release management activities.
- Work closely with business users and stakeholders to resolve production issues.
- Ensure adherence to SLA and operational support commitments.
- Participate in production releases and deployment activities.
Why work at Brillio
- Culture: Rated 4.0/5.0 on Glassdoor (2,264 reviews) and 4.0/5.0 on LinkedIn; 80% would recommend to a friend; Great Place to Work® certified in the USA.
- Work environment: Engineers get meaningful ownership within clear guardrails – autonomy to make architecture and trade-off calls on their workstreams.
- Learning & growth: Brillio Academy, hackathons, personalized career development framework; exposure to cutting-edge GenAI and agentic AI projects.
- Remote / hybrid / office: Not explicitly stated, but global delivery locations suggest a mix of on-site and remote (roles posted across multiple countries).
- Benefits: “BYou” wellness program built on four pillars of wellness – personal and professional well-being and development.
- Interview process: Focus on software fundamentals, LLMs, RAG, agents, evaluation, and a design or debugging exercise; candidates should be ready to walk through a real system they shipped.