DBT/Snowflake Engineer
NTT DATA, Inc. · Not specified · onsite · Posted 39d ago
Not disclosed7–9 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Offshore dbt Developer
Roles & Responsibilities
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.
- 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.
Sourced from foundit
Skills
InformaticaAzure DevopsCI/CD PipelinesGithub ActionsDBT CoreSCDsfact dimension designdimensional modelsSQLSnowflakeData Modeling
About NTT DATA, Inc.
NTT DATA, Inc.
IT Services & Consulting
40k+
employees
1988
38 years old
Hyderabad / Secunderabad, Telangana
India
About
NTT DATA helps clients transform through consulting, industry solutions, business process services, IT modernization and managed services.
Industries
IT Services & Consulting
Employee ratings
3,506 reviews
3.9/ 5
Culture
3.8
Career growth
3.1
Work-life
3.9
Employees rate it well for
Salary432Work Life Balance401Senior Management302Job Security299Work Culture299
Find them on