DBT Lead

As a DBT Lead at NTT DATA, your role will involve defining and implementing the target ELT architecture using dbt on Snowflake, integrated with Azure services such as ADF, ADLS, Synapse/Databricks, Key Vault, Azure DevOps/GitHub. Your key responsibilities will include: - Translating legacy Informatica mappings, workflows, and sessions into modular dbt models (staging, core, mart layers). - Establishing modeling standards for staging, integration, and mart layers including naming conventions, layer design, and folder/package structure. - Defining and implementing performance-optimized patterns in dbt and Snowflake such as incremental models, clustering, partitioning logic, and query tuning. - Leading the migration strategy, roadmap, and wave planning for converting Informatica jobs to dbt on Snowflake. - Designing a repeatable migration factory with templates, accelerators, mapping spreadsheets, and conversion playbooks for Informatica to dbt. - Overseeing conversion, unit testing, and parallel runs to ensure dbt models match legacy outputs. - Leading hands-on development of dbt models, seeds, snapshots, tests, macros, and documentation. - Defining and implementing testing strategy using dbt tests and integrating with broader data quality checks. - Setting up and maintaining dbt environments, profiles, and connections to Snowflake on Azure. - Introducing and enforcing code quality practices such as code reviews, pull requests, and modular, reusable models and packages. Qualifications Required: - 8+ years total experience in Data Engineering/ETL/Data Warehousing. - 3+ years hands-on experience with dbt building production-grade pipelines. - Proven experience leading an Informatica to dbt migration to Snowflake on Azure. - Strong Snowflake experience and solid working knowledge of the Azure data stack. - Very strong SQL skills and understanding of ELT patterns vs traditional ETL. - Deep understanding of dbt concepts, Informatica PowerCenter/IDQ objects, and setting up CI/CD for dbt projects. - Familiarity with Python and/or Spark and connecting BI tools to Snowflake models. NTT DATA is a $30 billion business and technology services leader, committed to accelerating client success and positively impacting society through responsible innovation. With capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services, NTT DATA's consulting and industry solutions help organizations and society move confidently into the digital future. As a Global Top Employer, NTT DATA has experts in more than 50 countries and offers clients access to an ecosystem of innovation centers and established partners.,