Offshore ETL Sr Engineer (DBT SME) (Bangalore, KA, IN)

Req ID: 394571 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Offshore ETL Sr Engineer (DBT SME) to join our team in Bangalore, Karnātaka (IN-KA), India (IN). dbt SME Role Overview The dbt SME acts as the architectural authority for the target-state transformation layer, defining standards, patterns, and best practices for dbt development. This role is responsible for establishing the dbt project structure, enforcing modeling conventions, and ensuring consistent implementation of transformations, tests, and performance strategies. The dbt SME partners with Informatica SMEs to validate translation approaches and supports Data Engineers through code reviews and technical guidance, ensuring scalable, high-quality dbt delivery across multiple migration waves and parallel business units. Key Responsibilities Define and govern dbt project structure (staging → intermediate → marts) Establish dbt standards: naming, testing, materializations, macros Design incremental models and snapshot strategies (non-CDC) Perform code reviews and ensure consistency across SWP and IMS Optimize dbt performance and warehouse execution Guide Data Engineers on best practices and reusable patterns Required Skills & Experience 8+ years SQL-based transformation experience 5+ years hands-on dbt Core or dbt Cloud Strong data mod