Snowflake Data Engineer

Experience- 7+ yearsLocation- Hyderabad (preferred), Pune, MumbaiJD-

We are seeking a skilled Snowflake Developer with 7+ years of experience in designing, developing, and optimizing Snowflake data solutions. The ideal candidate will have strong expertise in Snowflake SQL, ETL/ELT pipelines, and cloud data integration. This role involves building scalable data warehouses, implementing efficient data models, and ensuring high-performance data processing in Snowflake.

Key Responsibilities

1. Snowflake Development & OptimizationDesign and develop Snowflake databases, schemas, tables, and views following best practices.Write complex SQL queries, stored procedures, and UDFs for data transformation.Optimize query performance using clustering, partitioning, and materialized views.Implement Snowflake features (Time Travel, Zero-Copy Cloning, Streams & Tasks).2. Data Pipeline DevelopmentBuild and maintain ETL/ELT pipelines using Snowflake, Snowpark, Python, or Spark.Integrate Snowflake with cloud storage (S3, Blob) and data ingestion tools (Snowpipe).Develop CDC (Change Data Capture) and real-time data processing solutions.3. Data Modeling & WarehousingDesign star schema, snowflake schema, and data vault models in Snowflake.Implement data sharing, secure views, and dynamic data masking.Ensure data quality, consistency, and governance across Snowflake environments.4. Performance Tuning & TroubleshootingMonitor and optimize Snowflake warehouse performance (scaling, caching, resource usage).Troubleshoot data pipeline failures, latency issues, and query bottlenecks.Work with DevOps teams to automate deployments and CI/CD pipelines.5. Collaboration & DocumentationWork closely with data analysts, BI teams, and business stakeholders to deliver data solutions.Document data flows, architecture, and technical specifications.Mentor junior developers on Snowflake best practices.

Required Skills & Qualifications

· 7+ years in database development, data warehousing, or ETL.· 4+ years of hands-on Snowflake development experience.· Strong SQL or Python skills for data processing.· Experience with Snowflake utilities (SnowSQL, Snowsight, Snowpark).· Knowledge of cloud platforms (AWS/Azure) and data integration tools (Coalesce, Airflow, DBT).· Certifications: SnowPro Core Certification (preferred).Preferred Skills· Familiarity with data governance and metadata management.· Familiarity with DBT, Airflow, SSIS & IICS· Knowledge of CI/CD pipelines (Azure DevOps).