DBT/Snowflake Engineer

NTT DATA BUSINESS SOLUTIONS; Bengaluru; On-site; INR 2,000,000 - 4,200,000; Full time

Job summary

NTT DATA BUSINESS SOLUTIONS is seeking an experienced DBT/Snowflake Engineer to join a large-scale Data Modernization Program in Bengaluru. The role focuses on translating Informatica mappings into dbt models on Snowflake, building layered data architectures, and ensuring data quality with tests and documentation.

You will work across staging, core, and mart layers, implement snapshots and reusable components, and collaborate with onshore/offshore teams to maintain functional parity with legacy

Qualifications

• 7+ years in Data Engineering / ETL / DW with 13+ years using dbt (Core or Cloud).
• Strong SQL skills, especially on Snowflake or modern cloud DW.
• Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures.
• Desirable: Informatica knowledge at developer level.
• Understanding CI/CD practices and integrating dbt into automated pipelines.
• Knowledge of dimensional modeling, SCDs, and fact/dimension design.
• Offshore delivery experience with onshore coordination.
• Good communication and ability to read/understand ETL logic and requirements.

Responsibilities

• Translate Informatica mappings, transformations, and business rules into dbt models on Snowflake.
• Design and implement staging, core, and mart layers using standard dbt patterns.
• Develop and maintain dbt tests to ensure data quality and integrity.
• Implement snapshots, seeds, macros, and reusable components.
• Collaborate with Snowflake developers to optimize data structures for dbt.
• 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 for automated runs and validations.
• Contribute to documentation of dbt models, data lineage, and business rules.
• Participate in defect analysis and enhancements during migration and stabilization.

Skills

dbt expertise

SQL proficiency

Data modeling

ETL/DW experience

Offshore delivery coordination

Communication skills

Informatica knowledge

Tools

dbt

Snowflake

Informatica

Azure DevOps

GitHub Actions

Job description

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

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 13+ 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.