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
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
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