Position Summary

We are looking for a Quality Engineer to ensure the accuracy, completeness, and reliability of data onboard from the Yardi Diamond database into our Snowflake platform. This role is responsible for designing and executing comprehensive test strategies covering data pipelines, stored procedures, staging tables, views, and outbound file exports. The QE will validate that Diamond data integrates correctly with the existing Yardi EMEA IAR data estate and meets business and regulatory requirements.

Key Responsibilities

· Test Strategy & Planning: Define and document the end-to-end test strategy for the Yardi Diamond onboarding, covering data extraction validation, staging layer accuracy, transformation correctness, and outbound file integrity.

· Source-to-Target Validation: Design and execute source-to-target reconciliation tests comparing Yardi Diamond SQL Server source data against Snowflake staging tables. Validate row counts, column-level data integrity, data types, NULL handling, and boundary values across all onboarded entities.

· Stored Procedure Testing:



Test all recent and modified SQL stored procedures (following PROC_PRE_TA_DATA / PROC_POST_TA_DATA / PROC_GEN_TA_DATA_FILES patterns), verifying correct data transformation, SOURCEDB tagging, ETL logging to CIM.ETL_LOG_SNOWFLAKE, error handling, and exception path behavior.

· Incremental & Historical Load Testing: Validate incremental load correctness (inserts, updates, deletes/soft-deletes), historical backfill accuracy (PROC_PRE_TA_DATA_HISTORICAL pattern), and idempotency of pipeline re-runs.

· Multi-Currency & Exchange Rate Validation: Verify that Diamond data correctly integrates with the currency framework (INTEXCHANGERATE, CUREXCHIDX, VW_INTEXCHANGERATE), including exchange rate lookups, base currency conversions, and multi-currency transaction amounts.

· Fund & Investor Data Validation: Validate fund hierarchy (FUND_DATA), batch transactions (FUND_BATCH, FUND_BATCHDETAIL), fund trans

📌 ETL Tester (Hyderabad)
🏢 AlgoLeap Technologies
📍 Hyderabad