Snowflake Developer
Share
Job Location:
Monthly Salary:
Posted on:
5 hours ago
Vacancies:
1 Vacancy
Job Summary
Overview:
TekWissen is a global workforce management provider throughout India and many other countries in the world. The below job opportunity is to one of our clients who is a part of a trusted global innovator of IT and business services headquartered in Tokyo. We help clients transform through consulting industry solutions business process services IT modernization and managed services. This client enables us to move confidently into the digital future. This client committed to Long Term success and combine global reach with local client attention to serve them in over 50 Countries.
Position: Snowflake Developer
Location: Bangalore/Hyderabad
Work Type: Hybrid
Job Type: Full Time
Job Description:
- We are seeking an experienced ETL Developer with strong expertise in DBT Snowflake and modern Data Warehouse (DWH) practices.
- The ideal candidate will design develop and optimize data pipelines manage Snowflake assets (dynamic tables semantic models tasks streams) and ensure high performance scalable datasets for analytics and reporting.
Key Responsibilities
ETL / ELT Development:
- Design build and maintain ETL/ELT pipelines using DBT and other modern tools.
- Develop modular testable DBT models (staging intermediate marts).
- Implement CI/CD pipelines for DBT job deployments.
- Monitor pipeline performance and ensure high data quality.
Snowflake Development
- Build and manage:
- Dynamic Tables
- Semantic Views
- Stored Procedures (SP)
- Tasks and scheduling workflows
- Streams for change data capture (CDC)
- Implement Snowflake resource optimization including clustering partitioning caching and warehouse sizing.
- Use Query Profile for performance tuning and troubleshooting.
- Manage Snowflake security (RBAC) data governance and cost optimization.
Data Warehousing:
- Design and enhance DWH structures using dimensional modeling (Star/Snowflake schema).
- Work with business stakeholders to translate requirements into scalable data models.
- Ensure reliability data quality lineage and metadata documentation.
Performance Tuning
- Optimize SQL queries DBT models and Snowflake compute usage.
- Identify performance bottlenecks using Snowflake Query Profile and DBT artifacts.
- Implement best practices for incremental loads and materializations.
Required Skills & Experience
Technical Skills
Technical Skills
- Strong SQL (complex joins window functions query optimization)
- Hands on expertise with DBT Core / DBT Cloud
- Advanced experience with Snowflake:
- Dynamic Tables
- Semantic Views
- Streams & Tasks
- Stored Procedures (JavaScript/Python)
- Snowflake Performance Tuning
- Query Profile analysis
- Experience with ETL/ELT pipeline design
- Familiarity with Airflow or similar orchestration tools (preferred)
- Understanding of CDC frameworks
- Strong understanding of data warehousing concepts (Kimball/Inmon)
Soft Skills
- Strong analytical and problem solving skills
- Excellent communication and documentation abilities
- Ability to work in Agile environments
- Ownership mindset with attention to detail
TekWissen Group is an equal opportunity employer supporting workforce diversity
