DBT/Snowflake Engineer

NTT DATA North America; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

NTT DATA North America in Hyderabad, India, seeks an experienced Data Engineer to translate Informatica mappings into dbt models on Snowflake, design staging/core/mart layers, and build robust tests. You will implement snapshots, seeds, and reusable components while ensuring efficient data structures with Snowflake.

You will integrate dbt with CI/CD pipelines, collaborate with offshore teams, and contribute to data lineage, documentation, and migration activities.

Qualifications

• 7+ years of Data Engineering/ETL/DW experience.
• 2+ years with dbt (Core or Cloud).
• Strong SQL skills on Snowflake or similar.
• Informatica knowledge is desirable.
• Familiarity with CI/CD practices and pipelines.
• Knowledge of dimensional data modeling.
• Experience with offshore/onshore delivery.
• Excellent communication skills.

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 (Core/Cloud)

SQL proficiency

Data Engineering

Informatica knowledge

CI/CD knowledge

Snowflake

Offshore delivery

Communication skills

Tools

Snowflake

dbt

CI/CD tools

Job description

• 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.

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.