DBT/Snowflake Engineer

DBT/Snowflake Engineer

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.

Experience Level

Mid Level