IRIS Software - Quality Assurance Engineer - ETL/Datawarehouse Testing

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.