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 1–3+ years
working with dbt (Core or Cloud).
Solid SQL skills, especially on Snowflake or another contemporary 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.
Valuable communication skills and ability to read/understand existing ETL logic
and requirements documentation.

📌 Dbt/snowflake Engineer Bengaluru
🏢 NTT DATA Services
📍 Bengaluru