Data Engineer Sr (DBT)

NTT DATA North America; Bengaluru Urban; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

NTT DATA North America seeks an experienced professional in Bengaluru Urban, India, to design and implement DBT models, ensuring data integrity and quality through extensive testing. You will lead the development of enterprise data layers, focusing on performance tuning and CI/CD integration for automated workflows.

The role requires over 10 years of expertise in modern ELT and DBT-based development, along with a proven ability to guide collaborative teams and improve data processes.

Qualifications

• 10+ years in modern ELT / transformation engineering with DBT.
• Experience in defining DBT project standards and testing frameworks.
• Strong skills in leading development for Silver layer models.

Responsibilities

• Design and implement staging, core, and mart layers using DBT.
• Develop and maintain DBT tests for data quality.
• Collaborate with teams for functional equivalence between outputs.

Skills

DBT-based development

Modern ELT / transformation engineering

Collaboration with Snowflake

CI/CD integration

Performance tuning

Tools

Azure DevOps

GitHub Actions

Databricks

Delta Lake

Job description

Roles & Responsibilities

• 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

• 10+ years in modern ELT / transformation engineering, with strong expertise in DBT-based development for curated enterprise data layers.
• Experience defining DBT project standards, modular model design, testing frameworks, documentation, macros, environment strategy, and deployment controls.
• Proven ability to lead development of conformed Silver layer models across Policy, Claims, Billing, and shared dimensions / reference domains.
• Strong experience integrating DBT with Databricks / Delta Lake, orchestration tools, version control, and automated quality checks.
• Able to guide developer productivity, code review standards, reusability, performance tuning, and traceability from mapping to model implementation.