Talent.com
This job offer is not available in your country.
Snowflake Data Engineer - ETL

Snowflake Data Engineer - ETL

Renovision Automation Services Pvt.Ltd.Hyderabad
30+ days ago
Job description

We are seeking a skilled Snowflake Developer with 8+ 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 :

Snowflake Development & Optimization :

  • Design 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).

Data Pipeline Development :

  • Build 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.

    • Data Modeling & Warehousing :

  • Design 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.

    • Performance Tuning & Troubleshooting :

  • Monitor 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.

    • Collaboration & Documentation :

  • Work 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 :

  • 8+ 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).

    • (ref : hirist.tech)

    Create a job alert for this search

    Data Engineer Snowflake • Hyderabad