Search by job, company or skills

DBT/Snowflake Engineer

DBT/Snowflake Engineer

ntt data north america
7-9 Years
Not Disclosed
Early Applicant
  • Posted 19 hours ago
  • Be among the first 10 applicants

Job Description

Offshore dbt Developer

Roles & Responsibilities

  • Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake.
  • Design and implement staging, core, and mart layers using standard dbt patterns and folder structures.
  • Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity.
  • Implement snapshots, seeds, macros, and reusable components where appropriate.
  • Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently.
  • Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs.
  • Participate in performance tuning of dbt models and Snowflake queries.
  • Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations.
  • Contribute to documentation of dbt models, data lineage, and business rules.
  • Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases.

Experience & Skills

  • 7+ years of experience in Data Engineering / ETL / DW, with 2+ years working with dbt (Core or Cloud).
  • Strong SQL skills, especially on Snowflake or another modern cloud DW.
  • Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures.
  • Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable.
  • Understanding of CI/CD practices and integrating dbt into automated pipelines.
  • Knowledge of data modeling (dimensional models, SCDs, fact/dimension design).
  • Experience working in offshore delivery with onshore coordination.
  • Good communication skills and ability to read/understand existing ETL logic and requirements documentation.

More Info

Job Type:
Industry:
Employment Type:

Key Skills

SCDs

dimensional models

fact dimension design

Similar Jobs

8-10 yrs
Bengaluru, India
Skills:
snowflake , Github, Data Modeling, Cloudformation, Sql, Apache Airflow, Git, Terraform, Data Warehousing, Python, CI CD Pipelines, AWS IAM Security, AWS Cloud Services, dbt, Monitoring
5-8 yrs
Bengaluru, India
Skills:
Github, Data Modeling, Data Warehousing Concepts, Sql, Git, Azure Data Factory, Python, Aws S3, Airflow, CI CD Pipelines, Snowflake Data Cloud, DBT Data Build Tool
5-7 yrs
Bengaluru, India
Skills:
snowflake , Data Modelling, Git, Python, Sql, Data Pipelines, dbt, CI CD