Required Skills & Experience :
- Experience : 5-8 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.
- SQL Expertise :
Advanced proficiency in SQL :
Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis.Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery).Strong understanding of database concepts : normalization, indexing, primary / foreign keys, and data types.Data Testing Methodologies :
Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (e.g., source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy).Domain Expertise :
Strong understanding and proven experience in Risk and Finance IT domain : Familiarity with financial data (e.g., trading data, market data, risk metrics, accounting data, regulatory reporting).Knowledge of financial products, regulations, and risk management concepts.Analytical & Problem-Solving Skills :
Excellent ability to analyze complex data sets, identify root causes of data issues, and propose effective solutions.(ref : hirist.tech)