Senior Data Quality Engineer

Whiteblue; Chennai District; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

A leading fintech company is seeking a Senior Data Quality Engineer to ensure the reliability of enterprise financial data pipelines. The ideal candidate has over 5 years of experience in database and ETL testing within financial environments. Responsibilities include validating data movements in Azure Data Factory, optimizing SQL queries, and applying banking domain knowledge. Strong analytical skills and familiarity with compliance processes are essential for success in this role.

Qualifications

• 5+ years experience in database and ETL testing, particularly in financial environments.
• Expert-level SQL skills with a focus on complex joins and performance tuning.
• Hands-on experience with Snowflake and Azure Data Factory.

Responsibilities

• Analyze and dissect business and technical requirements for data pipelines.
• Design and run testing strategies for data movements within Azure Data Factory.
• Write and optimize advanced SQL queries to validate data transformations.
• Oversee data modeling and ensure schemas are optimized for reporting.

Skills

SQL Mastery

Cloud Data Warehousing

Data Modeling

Banking Domain Knowledge

Analytical Rigor

Job description

Overview

A Senior Data Quality Engineer focused on validating, monitoring, and ensuring the reliability of enterprise financial data pipelines.

Key Details

• Employment Type: Full Time
• Timing: 3:00 AM to 12 Noon PST
• Work Mode: NA
• Experience: 5+ years
• Location:

Responsibilities

• Requirement Dissection: Thoroughly analyze business and technical requirements to ensure data pipelines meet complex banking compliance and logic standards.
• End-to-End ETL Validation: Design and execute testing strategies for large-scale data movements within Azure Data Factory (ADF).
• Complex SQL Engineering: Write and optimize advanced SQL queries (CTEs, Window Functions, Analytical Joins) to validate data transformations and warehouse performance.
• Data Modeling Oversight: Analyze and map conceptual, logical, and physical data models, ensuring star/snowflake schemas are optimized for financial reporting.
• Banking Domain Excellence: Apply deep knowledge of CIF, KYC, and AML processes to ensure data reflects the true transaction lifecycle and regulatory requirements (Basel, CCAR).

Required Skills & Experience

• 5+ Years Experience: Proven track record in database and ETL testing, specifically within financial or banking environments.
• SQL Mastery: Expert-level SQL skills, including complex joins, windowing functions, and analytical performance tuning.
• Cloud Data Warehousing: Hands-on experience with Snowflake (schema design, warehouse performance, stages, and ingestion) and Azure Data Factory.
• Data Modeling: Strong understanding of dimensional modeling, fact/dimension structures, and mapping transformations to warehouse architectures.
• Domain Knowledge (Banking/Finance): Solid grasp of Transaction Lifecycle data and GL/ledger balancing.
• Familiarity with risk and regulatory data models (CCAR, Basel).
• Experience handling sensitive KYC/AML and Customer Information File (CIF) datasets.

Process & Soft Skills

• Analytical Rigor: A proven ability to identify edge cases in complex financial requirements.
• Agile Proficiency: Comfortable working in fast-paced Agile environments with integrated QA processes.
• Communication: Ability to translate technical data discrepancies into business-level risks.

Apply For This Position

• Full Name
• E-mail
• Phone
• Position
• Upload Resume
• Upload Resume Upload Max: 2 MB

By submitting this form you agree with the storage and handling of your data by this website & WhiteBlue Cloud Services Pvt Ltd.