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.
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Quality Assurance and TestingRole: Test AnalystEmployement Type: Full time