ETL Tester - Senior Engineer @ Iris Software

Experience: 5-8 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.

SQL Expertise:

o Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis.

o Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery).

o 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:

o 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).

o 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.

Communication: Strong verbal and written communication skills to articulate data issues and collaborate with diverse teams.

Time Zone Overlap: Proven ability and willingness to provide consistent working hour overlap until noon EST to collaborate with teams in the Eastern Standard Time zone.