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).
* 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.
* Valuable communication skills and ability to read/understand existing ETL logic
and requirements documentation.

📌 DBT/Snowflake Engineer (Bengaluru)
🏢 NTT DATA Services
📍 Bengaluru