As a DBT Engineer at NTT DATA, you will play a key role in modernizing enterprise data platforms by migrating and rebuilding legacy ETL workflows into scalable dbt-based solutions on Snowflake. Working closely with data engineers, Snowflake developers, and functional stakeholders, you will ensure functional equivalence, data quality, and performance as part of large-scale migration and stabilization efforts.
Responsibilities:
- Translate Informatica mappings, transformations, and business rules into dbt SQL models on Snowflake.
- Design and implement staging, core, and mart layers using standard dbt project structures.
- Develop and maintain dbt tests, including schema, data, and custom tests, to ensure data integrity.
- Implement dbt snapshots, seeds, macros, and reusable components where applicable.
- Collaborate with Snowflake developers to align physical data structures with dbt performance needs.
- Participate in performance tuning, defect resolution, and documentation of models and data lineage.
Requirements:
- 3–6 years of experience in data engineering, ETL, or data warehousing roles.
- 1–3+ years of hands-on experience with dbt Core or dbt Cloud.
- Strong SQL skills, preferably with Snowflake or another modern cloud data warehouse.
- Solid understanding of dbt concepts including models, tests, sources, snapshots, and macros.
- Prior experience with Informatica mappings and workflows is highly desirable.
- Experience integrating dbt into CI/CD pipelines and understanding data modeling concepts.
- Strong communication skills and ability to work with offshore and onshore teams.
This role supports NTT DATA’s mission to deliver reliable, modern data platforms for global clients.