DBT/Snowflake Engineer

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 A