Data Test Engineer job

• Perform end-to-end data validation across source systems, databases, APIs, web services, and downstream applications.
• Develop and execute complex SQL queries to validate data accuracy, completeness, consistency, and integrity.
• Analyze inbound files, database records, API payloads, and data transformations to identify discrepancies.
• Validate data mappings, transformation logic, business rules, and expected outcomes.
• Investigate data quality issues, perform root-cause analysis, and collaborate with engineering teams to resolve defects.
• Design and execute backend, database, integration, and data reconciliation test scenarios.
• Validate data processing workflows and ensure information is accurately transferred between interconnected systems.
• Support testing of financial-crimes and sanctions-related business processes, ensuring that data is processed according to defined requirements.
• Document test results, defects, findings, and potential business impacts with a high degree of accuracy.
• Work closely with developers, data engineers, product owners, business analysts, and compliance stakeholders.
• Communicate technical issues, risks, and recommendations clearly to both technical and nontechnical audiences.
• Take ownership of assigned deliverables and contribute to continuous improvements in data quality and testing processes.

SQL and Database Technologies

• Strong SQL skills, including complex joins, subqueries, aggregations, and data comparisons.
• Experience querying relational databases and validating large datasets.
• Ability to identify missing, duplicate, inconsistent, or incorrectly transformed records.
• Experience with database testing and data reconciliation.

Data Engineering and Data Validation

• Understanding of data pipelines, data ingestion, transformation, and downstream processing.
• Experience validating source-to-target mappings and data integrity across systems.
• Ability to analyze structured data files and troubleshoot data discrepancies.
• Familiarity with ETL/ELT processes and data integration concepts.

API and Backend Testing

• Experience validating REST APIs or other web services.
• Understanding of request/response payloads, JSON or XML, and backend data verification.
• Ability to validate that API responses and system outputs align with expected database records.
• Experience testing integrations between multiple applications or services.

Programming and Automation

• Scripting experience in Python or another programming language is desirable.
• Ability to develop reusable scripts or queries to support data validation and reconciliation.
• Familiarity with test automation approaches for backend and data-centric workflows.