Company Description
TuTeck Technologies is a global technology leader, empowering enterprises to transform through data-driven insights and digital innovation. With a presence in London, Kolkata, and Delaware, our team of over 200 consultants. Recognized by NASSCOM with the SME Inspire Award (2024), TuTeck is committed to excellence and holds SOC Type2, ISO 9001:2015 & ISO 27001:2022 certifications. We specialize in AI & ML engineering, data management, business intelligence, digital engineering, and cloud adaptation, helping organizations streamline processes and drive growth.
Job Requirement:
Experience: 5 to 8 years
Location: Kolkata
Work Mode: Work from Office
Employment Type: Full-time
Immediate Joiner Preferred
Role Description
This is a full-time, on-site role in Kolkata for a Senior Snowflake Developer/Architect. The professional should have strong hands-on experience in building and supporting data pipelines, transformations, and reporting solutions on Snowflake. The ideal candidate should have excellent SQL skills, a strong understanding of Snowflake features, and the ability to develop reliable, efficient, and secure data solutions. This role will work closely with data engineering, analytics, and architecture teams to support business data needs. Day-to-day responsibilities include designing scalable data models, building and maintaining pipelines, improving data governance, and collaborating with cross-functional teams to ensure efficient data workflows. Additional responsibilities will include troubleshooting, addressing performance issues, and implementing best practices for data security and compliance.
Key Responsibilities
- Develop and maintain data pipelines and transformation workflows in Snowflake.
- Write efficient SQL queries, views, stored procedures, and reusable components.
- Load, transform, and manage structured and semi-structured data in Snowflake.
- Support data ingestion and processing using Snowpipe, Streams, and Tasks.
- Optimize query performance, warehouse usage, and job execution.
- Support data modeling activities for analytics and reporting requirements.
- Implement secure data access using roles, grants, masking policies, and secure views.
- Troubleshoot pipeline failures, data quality issues, and production support incidents.
- Participate in code reviews, testing, and deployment activities.
- Collaborate with business and technical teams to translate requirements into implementation.
Mandatory Skills
- Strong hands-on experience in Snowflake development.
- Strong SQL development and debugging skills in Snowflake.
- Experience with Snowflake objects such as databases, schemas, tables, views, virtual warehouse
- Hands-on experience with Snowpipe, Snowspark, Streams, Tasks, Dynamic Tables or Materialized Views.
- Experience in writing and maintaining stored procedures, UDFs, and views.
- Experience with Snowflake data sharing and replication.
- Experience with CI/CD pipelines for Snowflake deployments, Git, DevOps practices, and Infrastructure as Code.
- Experience with ETL/ELT processes, data integration, and building data pipelines.
- Good understanding of query optimization and performance tuning in Snowflake.
- Experience handling semi-structured data such as JSON, Avro, Parquet, or ORC in Snowflake.
- Experience with Snowflake security and access control concepts, including roles, grants, masking policies, and secure views.
- Experience with Time Travel and Zero-Copy Cloning.
- Strong understanding of data loading, transformation, and operational support in Snowflake.
- Ability to troubleshoot and resolve Snowflake-related development issues independently.
- Good communication and collaboration skills.
- Experience working in agile teams.
Good to Have
- Experience with dbt, Matillion, Informatica, or Airflow.
- Exposure to cloud platforms such as AWS, Azure, or GCP.
- Experience with Python scripting.
- Exposure to data quality frameworks and automated testing.
- SnowPro Core certification.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 5 to 8 years of overall experience in data engineering, SQL development, or cloud data platforms.
- Proven hands-on experience in Snowflake development.
- Ability to build scalable and maintainable data solutions.
- Strong analytical and troubleshooting skills.
- Ability to work independently as well as in a team environment.
