Key Responsibilities
- Design, develop, and maintain scalable data pipelines using Snowflake and DBT.
- Build, optimize, and maintain complex SQL queries for data extraction, transformation, and loading.
- Develop and manage DBT models, including transformations, testing, documentation, and deployment.
- Implement data modeling techniques such as star schema, snowflake schema, and dimensional modeling.
- Design and optimize ETL/ELT workflows for structured and semi-structured data.
- Ensure data quality by implementing validation, testing, and monitoring processes.
- Optimize Snowflake performance, storage, and query execution for cost and efficiency.
- Collaborate with data analysts, business stakeholders, and engineering teams to deliver data solutions.
- Maintain version control using Git and follow CI/CD best practices.
Required Skills
- Strong hands-on experience with Snowflake as the primary cloud data warehouse.
- Advanced proficiency in SQL, including query optimization and performance tuning.
- Hands-on experience with DBT (Data Build Tool) for data transformation, modeling, testing, and documentation.
- Solid understanding of ETL/ELT concepts and data integration.
- Experience with Data Warehousing and Data Modeling principles.
- Proficiency with Git or other version control systems.
- Strong analytical, troubleshooting, and problem-solving skills.
Pay: ₹2,000,000.00 - ₹3,000,000.00 per year
Work Location: In person
