DBT/Snowflake Engineer

NTT DATA, Inc.; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

NTT DATA, Inc. is looking for an experienced DBT/Snowflake Engineer to join a large-scale Data Modernization Program. This role involves translating Informatica mappings into dbt models on Snowflake, designing staging and core layers, and ensuring data quality through rigorous testing.

The ideal candidate will have over 7 years of experience in Data Engineering, with strong SQL skills and profound knowledge of dbt and Snowflake. Familiarity with CI/CD practices is essential. Join us to make a significant impact on our data initiatives.

Qualifications

• 7+ years of experience in Data Engineering/ETL/DW, with 1-3+ years working with dbt.
• Strong SQL skills, especially on Snowflake or another modern cloud data warehouse.
• Knowledge of data modeling including dimensional models and SCDs.

Responsibilities

• Translate Informatica mappings into dbt models on Snowflake.
• Design and implement staging, core, and mart layers using dbt.
• Collaborate with Snowflake developers for efficient physical data structures.
• Integrate dbt with CI/CD pipelines for automated runs.

Skills

Data Engineering

SQL

dbt

Snowflake

ETL

Data Modeling

CI/CD

Informatica

Communication Skills

Job description

We are seeking an experienced DBT/Snowflake Engineer to be part of a large-scale Data Modernization Program.

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 1–3+ 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.