DBT/Snowflake Engineer

NTT DATA, Inc.; Bengaluru; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

NTT DATA, Inc. in Bengaluru is seeking an offshore dbt Developer to translate Informatica mappings into dbt models on Snowflake and build scalable data pipelines.

You will design staging and mart layers, implement tests and reusable components, and collaborate with Snowflake engineers to optimize data structures. The role requires strong SQL, 7+ years in data engineering, and experience with dbt concepts and CI/CD integration.

Qualifications

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

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.

Skills

dbt

SQL

Snowflake

CI/CD

Data modeling

offshore delivery coordination

Tools

Informatica

Snowflake

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.