Onix Datametica is Hiring Snowflake DW Engineers....!!!

Job Summary

Data Engineer with strong expertise in Snowflake and Data Warehouse (DW) architecture

Key Responsibilities

• Design, build, and maintain

  high-performance data pipelines and ELT workflows

  using Snowflake.
• Develop and optimize

  Snowflake objects

  including databases, schemas, tables, tasks, streams, stages, and views.
• Implement

  data warehousing solutions

  following best practices in dimensional modeling (Kimball/Inmon).
• Build scalable data integration solutions using tools like

  Informatica, dbt, Matillion, Airflow, or Azure Data Factory

  (customize as needed).
• Optimize Snowflake compute usage, query performance, and storage through

  clustering, micro-partitioning, caching, and resource monitoring

  .
• Perform data profiling, data quality checks, and implement governance/security controls.
  
• Collaborate with data analysts, data scientists, and business stakeholders to deliver clean, reliable data.
  
• Automate workflows and CI/CD for data pipelines.
  
• Monitor datasets for freshness, accuracy, and performance.
  

Required Skills

• Strong hands-on experience with Snowflake

  (Warehouses, Virtual Warehouses, Streams, Tasks, Time Travel, Cloning, Staging, Role-Based Access Control).
• Expertise in

  SQL

  (advanced level) and performance tuning.
• Solid understanding of

  Data Warehouse concepts

  , star-schema modeling, and ETL/ELT frameworks.
• Experience with at least one orchestration or ETL tool (e.g.,

  dbt, Airflow, Informatica, Matillion, ADF, Talend

  ).
• Proficiency in

  Python

  or

  Java/Scala

  for data transformation (optional).
• Experience working with cloud environments (AWS / Azure / GCP).
  
• Knowledge of

  CI/CD

  , Git, and DevOps best practices.

Preferred Qualifications

• Snowflake

  SnowPro Core or Advanced

  certification.
• Experience with

  real-time/streaming pipelines

  (Kafka, Kinesis, Pub/Sub).
• Exposure to

  BI tools

  like Tableau, Power BI, Looker, or ThoughtSpot.
• Understanding of

  data governance, lineage, and catalog tools

  (Collibra, Atlan, Alation).

Education

• Bachelors or Master’s degree in Computer Science, Information Systems, Engineering, or related fields.