DBT Engineer at NTT DATA
Bengaluru, karnataka, India -
Full Time


Start Date

Immediate

Expiry Date

27 Mar, 26

Salary

0.0

Posted On

27 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

DBT, SQL, Snowflake, Data Quality, Data Integrity, Performance Tuning, Documentation, Informatica, Collaboration, Testing, Data Lineage, Bug Fixes, Migration, Stabilization, Models, Transformations

Industry

IT Services and IT Consulting

Description
Job Duties: 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. 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 with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures. Experience working in offshore delivery with onshore coordination.
Responsibilities
The DBT Engineer will translate Informatica mappings and business rules into dbt models on Snowflake, while ensuring data quality through tests and collaborating with developers. They will also participate in performance tuning and contribute to documentation.
Loading...