Data Engineer

atsMantra®

Hyderabad

On-site

INR 1,500,000 - 2,600,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

atsMantra® is seeking a hands-on Snowflake DBT Data Engineer to design, develop, and implement scalable data solutions in a Snowflake environment. The role focuses on ELT pipelines, SQL optimization, and data modeling to deliver reliable data warehouse capabilities.

Key responsibilities include building dbt models and workflows, tuning performance, and collaborating with cross-functional teams. Proficiency in Python and Airflow is highly valued for automation and orchestration.

Qualifications

  • Hands-on experience designing and maintaining Snowflake data warehouses.
  • Developing ELT pipelines with dbt.
  • Writing complex SQL queries and data transformations.
  • Experience with data modeling and dimensional modeling.
  • Proficiency in Python for data processing.
  • Familiarity with Airflow or similar orchestration tools.
  • Knowledge of CI/CD and version control practices.

Responsibilities

  • Design, develop, and maintain scalable data warehouse solutions using Snowflake.
  • Build and manage data transformation workflows using dbt.
  • Develop, implement, and optimize ELT pipelines for integrating data from multiple sources into Snowflake.
  • Write complex SQL queries, stored procedures, views, and data transformations.
  • Develop and maintain dbt models, macros, snapshots, tests, and incremental models.
  • Implement data quality checks, validation, and automated testing using dbt.
  • Perform Snowflake query performance tuning and optimize warehouse utilization and compute costs.
  • Work on data modeling techniques, including dimensional modeling (Star and Snowflake schemas).
  • Develop Python scripts for data processing, automation, and integration.
  • Work with Apache Airflow for workflow orchestration and pipeline scheduling.

Skills

Snowflake
DBT
SQL
Data modeling
ELT pipelines
Python
Airflow
CI/CD
Git
Agile

Tools

Snowflake
dbt
Apache Airflow
Git
CI/CD tools

Job description

We are looking for a hands-on Snowflake DBT Data Engineer with strong expertise in Snowflake and dbt to design, develop, and implement scalable, high-performance data solutions. The ideal candidate should have solid experience in SQL, data modeling, ELT pipeline development, and cloud data warehousing, with a focus on building efficient and reliable data pipelines.

Key Responsibilities
  • Design, develop, and maintain scalable data warehouse solutions using Snowflake.
  • Build and manage data transformation workflows using dbt (Data Build Tool).
  • Develop, implement, and optimize ELT pipelines for integrating data from multiple sources into Snowflake.
  • Write complex SQL queries, stored procedures, views, and data transformations.
  • Develop and maintain dbt models, macros, snapshots, tests, and incremental models.
  • Implement data quality checks, validation, and automated testing using dbt.
  • Perform Snowflake query performance tuning and optimize warehouse utilization and compute costs.
  • Work on data modeling techniques, including dimensional modeling (Star and Snowflake schemas).
  • Develop Python scripts for data processing, automation, and integration.
  • Work with Apache Airflow for workflow orchestration and pipeline scheduling.
  • Support data migration initiatives from legacy data platforms to Snowflake.
  • Follow coding standards, version control, and CI/CD best practices.
  • Collaborate with solution architects, business analysts, and cross-functional teams to deliver data engineering solutions.
Mandatory Skills
  • Strong hands-on experience with Snowflake.
  • Practical development experience with dbt (Data Build Tool).
  • Strong expertise in SQL and complex query development.
  • Experience in data modeling, data warehousing, and ELT pipeline development.
  • Good understanding of Snowflake architecture, performance tuning, and cost optimization.
  • Experience with Python for data engineering.
  • Exposure to Apache Airflow or similar workflow orchestration tools.
Good to Have
  • Experience with Snowpark.
  • Exposure to AWS / Azure / GCP cloud services.
  • Experience in migrating legacy data platforms to Snowflake.
  • Knowledge of Git, CI/CD, and automated deployment practices.
  • Experience working in Agile development environments.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer(Snowflake & dbt)
Data Engineer(Snowflake & dbt)

Alt Digital Technologies • Dadri

Remote
INR 1,200,000 - 1,500,000
Snowflake DBT Engineer
Snowflake DBT Engineer

Anblicks Inc. • Hyderabad

On-site
INR 1,800,000 - 2,800,000
Snowflake Data Engineer
Snowflake Data Engineer

Capgemini • Hyderabad, Pune District, Bengaluru

Hybrid
INR 1,200,000 - 2,400,000
Snowflake & dbt Data Engineer
Snowflake & dbt Data Engineer

Tata Consultancy Services Limited • Bengaluru

On-site
INR 1,500,000 - 2,600,000
Snowflake Data Engineer (DBT AWS)
Snowflake Data Engineer (DBT AWS)

Tech Mahindra Limited • Pune District

On-site
INR 1,500,000 - 3,000,000
Snowflake Data Engineer
Snowflake Data Engineer

Genpact Ltd. • Hyderabad, Bengaluru, Delhi

On-site
INR 3,500,000 - 7,000,000
Snowflake Senior Data Engineer
Snowflake Senior Data Engineer

HCL Technologies Limited • Chennai

On-site
INR 3,000,000 - 6,000,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

EPAM Systems Inc • India

On-site
INR 1,500,000 - 2,500,000
Snowflake + Python + SQL Developer
Snowflake + Python + SQL Developer

PradeepIt Global Consulting Pvt Ltd. • Bengaluru

On-site
INR 800,000 - 1,200,000
Snowflake Data Engineer with Python and DBT Expertise
Snowflake Data Engineer with Python and DBT Expertise

Infosys • Bengaluru

On-site
INR 1,500,000 - 2,100,000