DBT/Snowflake Engineer

NTT DATA BUSINESS SOLUTIONS; Hyderabad; On-site; INR 3,000,000 - 5,000,000; Full time

Job summary

NTT DATA BUSINESS SOLUTIONS is seeking an experienced Data Engineer to translate Informatica mappings into dbt models on Snowflake, design layered data pipelines, and ensure data quality. You will build dbt tests, implement snapshots, seeds, and reusable components, and collaborate with offshore teams to maintain performance and reliability.

The role requires 7+ years in data engineering with 2+ years in dbt, strong SQL, Snowflake experience, and familiarity with CI/CD pipelines and data

Qualifications

• 7+ years in Data Engineering/ETL/DW.
• 2+ years with dbt (Core or Cloud).
• Strong SQL, Snowflake or similar modern DW.
• Knowledge of dbt models, tests, sources, seeds, snapshots, macros, exposures.
• Familiarity with Informatica mappings/workflows.
• Understanding CI/CD and automated pipelines.
• Experience with offshore delivery and cross-team collaboration.

Responsibilities

• Translate Informatica mappings into dbt models on Snowflake.
• Design staging, core, and mart layers using dbt patterns.
• Develop and maintain dbt tests for quality.
• Implement snapshots, seeds, macros as needed.
• Collaborate with Snowflake developers on data structures.
• Ensure functional equivalence between legacy outputs and dbt.
• Tune performance of dbt models and Snowflake queries.
• Integrate dbt with CI/CD pipelines for automated runs.
• Document dbt models, data lineage, and business rules.
• Support defect analysis during migration and stabilization.

Skills

SQL

Snowflake

dbt concepts

CI/CD practices

Data modeling

Communication skills

Offshore delivery coordination

Tools

Informatica

Azure DevOps

GitHub Actions

Job description

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.