Job Description

Roles & Responsibilities

  • Validated end-to-end data ingestion pipelines for multiple hospitality clients, ensuring accurate data flow from source systems (SQL Server, MySQL, ADLS, Redshift, CSV/Excel) into Snowflake.
  • Performed data quality testing on raw, staging, and transformed layers, verifying record counts, schema alignment, null handling, and business rule compliance.
  • Executed regression testing for recurring data loads and new feature releases to ensure no impact on existing transformations and reports.
  • Wrote and optimized SQL queries to validate transformations, joins, aggregations, and derived metrics across bronze, silver, and gold layers.
  • Tested and validated dbt models, including materializations (table, view, incremental), snapshots (SCD Type 2), tests, and macros.
  • Reviewed and validated business logic implemented in dbt models, ensuring alignment with functional requirements and acceptance criteria.<...

Ready to Apply?

Take the next step in your AI career. Submit your application to Anblicks today.

Submit Application