Offer Tagging_ETL - Engineer

Job Description

Experience: 3-5 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.

Mandatory Competencies