01 Aug
|
NTT America
|
Bengaluru
01 Aug
NTT America
Bengaluru
We are seeking an experienced DBT/Snowflake Engineer to be part of a large-scale Data Modernization Program **Offshore dbt Developer** 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. **Experience & Skills** + 7+ years of experience in Data Engineering / ETL / DW, with 1-3+ 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. + Valuable communication skills and ability to read/understand existing ETL logic and requirements documentation.
📌 DBT/Snowflake Engineer (Bengaluru)
🏢 NTT America
📍 Bengaluru