Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Develop complex SQL queries, joins, common table expressions (CTEs), views, stored procedures, and data transformations within Snowflake 2.
Leverage Snowflake Cortex AI Functions such as AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, AI_SENTIMENT, AI_EMBED, and AI_SUMMARIZE_AGG to build…
Work with structured and unstructured data in Snowflake, ensuring efficient data ingestion, transformation, and management 4.
Experience
2–4 years
Education
Bachelor's degree
Must-have skills
Data WarehousingSQLSnowflake
Work mode
Hybrid
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Pune, Maharashtra, India Department: AI & Data Engineering
Senior Data Engineer
Primary Skills
DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
Snowflake Engineering: Data Engineer
Job requirements
Experience Range: 2 to 4 years of hands-on experience in Snowflake engineering and advanced SQL development Key Responsibilities: 1. Develop complex SQL queries, joins, common table expressions (CTEs), views, stored procedures, and data transformations within Snowflake 2. Leverage Snowflake Cortex AI Functions such as AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, AI_SENTIMENT, AI_EMBED, and AI_SUMMARIZE_AGG to build AI-powered data processing and analytics solutions 3. Work with structured and unstructured data in Snowflake, ensuring efficient data ingestion, transformation, and management 4. Perform rigorous data validation, quality checks, and troubleshooting to maintain data integrity and reliability 5. Optimize SQL queries and Snowflake workloads for enhanced performance and reduced cost 6. Support development and deployment of Generative AI use cases, including summarization, classification, information extraction, and semantic search 7. Collaborate with data engineers, analysts, and business teams to gather requirements and deliver tailored Snowflake solutions Required Skills: 1. Advanced SQL skills, including joins, CTEs, views, and stored procedures 2. Strong understanding of Snowflake architecture and data warehousing concepts 3. Experience with Snowflake Cortex AI Functions 4. Knowledge of data transformation techniques within Snowflake 5. Ability to work with structured and unstructured data in Snowflake Preferred Skills: 1. Experience implementing generative AI use cases such as semantic search or information extraction in Snowflake 2. Familiarity with optimizing Snowflake workloads for analytics 3. Knowledge of data security and governance in cloud data platforms 4. Certification in Snowflake or cloud data engineering Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline 2. Snowflake SnowPro Core Certification 3. Relevant certification in SQL (e.g., Microsoft Certified: SQL Database Specialist)
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?