DBT and Snowflake Data Engineer

NTT DATA Global Delivery Services Ltd; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

NTT DATA Global Delivery Services Ltd. is seeking a Senior DBT/Snowflake Engineer to translate Informatica mappings into dbt models on Snowflake and design scalable data layers. You will implement tests, snapshots, and reusable components, collaborating with offshore teams to ensure parity with legacy outputs.

The role requires deep SQL, dbt expertise, and experience with CI/CD pipelines, aiming to optimize performance and data quality across the data stack.

Qualifications

• 7+ years of experience in Data Engineering / ETL / DW.
• 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 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.

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 to ensure data quality and integrity.
• Implement snapshots, seeds, macros, and reusable components where appropriate.
• Collaborate with Snowflake developers to ensure data structures support dbt models efficiently.
• 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, bug fixes, and enhancements during migration and stabilization phases.

Tools

Snowflake

Informatica

Azure DevOps

GitHub Actions

Job description

DBT/Snowflake Engineer 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.

Experience Level Senior Level