Data Testing Engineer

Must Have Technical/Functional Skills

We are seeking a Senior Data Testing Engineer with a strong business and domain understanding of wealth management platforms and a passion for data quality and automation. This is a hands-on role focused on understanding how the business operates, how financial products behave, and how data flows across systems, and then translating that understanding into effective automated data tests.

This role emphasizes business-driven testing, where the engineer deeply understands products, calculations, data transformations, and downstream impact, and uses Python-based data testing and automation tools (e.g., PyTest, Python DQ frameworks) to validate correctness.

You will work closely with Product, Business Analysts, Data Engineers, and Developers to ensure financial data is reliable, explainable, and trusted.

Roles & Responsibilities

Business & Domain-Driven Data Testing

Develop strong functional understanding of wealth management products, including:

o Accounts, positions, holdings, transactions, balances, and statements

o Fees, performance, valuations, and corporate actions

Understand business workflows and data flows end-to-end, such as

o Trade capture booking settlement accounting reporting

o Client onboarding account setup funding transactions o Market data ingestion pricing valuation

Translate business rules and requirements into testable data validation scenarios

Data Testing & Reconciliation

Design and execute data validation and reconciliation tests for

o Financial transactions and balances

o Positions, holdings, and ledger data o Client, account, security master, and reference data

Automation & Tooling (Python / PyTest Focus)

Build and maintain automated data quality tests using

o Python and PyTest o SQL-based assertions and reconciliation queries

o Python-based data quality or validation frameworks

Automate validation for

o Databases and data stores o APIs and backend services (data-centric validation)

o File-based integrations (CSV, JSON, XML)

Integrate automated data tests into CI/CD pipelines or scheduled runs

Collaboration & Defect Analysis

Partner with business, product, and engineering teams to

o Clarify requirements and expected data behavior

o Investigate data issues with a business-first mindset

o Provide clear explanations of data breaks and mismatches

Document defects with business context, data evidence, and root-cause insights -

Required Qualifications

10+ years of experience in Data Testing or SDET roles with strong business and data focus

Strong understanding of wealth management or financial services domains

Hands-on experience with

o Python and PyTest for data testing automation

o Advanced SQL for data validation and reconciliation

Experience validating

o Backend systems, APIs, and integrations from a data perspective

o Batch processing and data pi pelines

* Ability to understand business rules, calculations, and financial logic, not just schemas

TCS Employee Benefits Summary

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $100,000-$130,000 a year

Location

Hamilton, NJ

Job Function

TECHNOLOGY

Role

Senior Engineer

Job Id

412220

Desired Skills

Python | SQL

Salary Range

$100,000-$130,000 a year

Desired Candidate Profile

Qualifications : BACHELOR OF COMPUTER SCIENCE