DBT/Snowflake Engineer
At a glance
Mid-level Data Engineering role at NTT DATA. Bangalore.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Turn Informatica mappings and business rules into SQL-based dbt models running on Snowflake
- Set up staging, core and mart layers, then create checks and reusable dbt components
- Coordinate with Snowflake developers and functional teams to align platform structures and compare legacy and dbt results
- Improve model and query speed, and connect dbt with automated delivery workflows
- Record model details, lineage and business rules; troubleshoot and fix issues during migration and stabilization
What you bring
- At least seven years in data engineering, ETL or data warehousing, including two years or more using dbt
- Strong SQL skills, especially with Snowflake or another modern cloud data warehouse
- Knowledge of dbt features such as models, tests, sources, seeds and snapshots
- Experience applying continuous integration and delivery to automate dbt runs and checks
- Background in offshore delivery with onshore coordination, and skill in interpreting existing ETL logic
Who this fits
This role suits a mid-level data engineer with substantial ETL experience and hands-on dbt work. You’ll coordinate offshore delivery with onshore teams.
From the employer
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 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.