Data Tester

Civica

Vadodara

Hybrid

INR 500,000 - 700,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Flexible Work
Hybrid or Remote options
Days of Difference leave

Job summary

Civica in India is seeking a Data Tester to safeguard financial data during migrations, design and execute test cases, validate reconciliations, and apply SQL expertise across legacy and target systems.

You will work with Data Engineers, Analysts, and UK stakeholders to identify defects, support root-cause analysis, and ensure go-live readiness, with strong emphasis on ETL, finance mappings, and audit trails.

Qualifications

  • Test planning, design, build and maintenance of test plans, scripts and cases across migration cycles.
  • Data validation with source-to-target reconciliations and mapping specs.
  • SQL testing to verify counts, values and totals.
  • Defect management using established tooling.
  • Root cause analysis with ETL teams for issue resolution.
  • Regression testing to confirm fixes and avoid new issues.
  • Finance knowledge including GL, COA, AP/AR, and assets.
  • ERP familiarity with SAP, Oracle Financials or similar.
  • Attention to detail and clear defect reporting.

Responsibilities

  • Design, build, and maintain test plans, scripts, and cases across migration cycles (mock runs, SIT, UAT, cutover).
  • Perform reconciliation checks between source and target systems using mapping specs.
  • Write queries to compare record counts, field values, and totals across systems.
  • Log, track, and resolve data defects using Azure DevOps/JIRA/ALM/TestRail.
  • Collaborate with engineers and ETL teams to investigate and resolve issues.
  • Confirm fixes and ensure no new issues are introduced.
  • Check for duplicates, missing values, incorrect mappings, and broken relationships.
  • Maintain clear records of test evidence, sign-offs, and defect logs.
  • Highlight risks and readiness for go/no-go decisions.
  • Participate in go-live activities and post-migration checks.
  • Coordinate with UK-based stakeholders to align priorities and timelines.

Skills

Test planning
Data validation
SQL testing
Defect management
Root cause analysis
Regression testing
Financial integrity
Documentation
Reporting
Cutover support
Stakeholder alignment
Communication skills
Collaboration
Resilience
Attention to detail

Education

Bachelor's degree in Finance, Accounting, CS or related field
1-4 years of data testing/QA experience

Tools

JIRA
Azure DevOps
HP ALM
TestRail

Job description

We're Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public bodies across the globe use our software to help provide critical services to over 100 million citizens.

Our aspiration is to be a GovTech champion everywhere we work around the globe, supporting the needs of citizens and those that serve them every day. Building on 21 years of continuous growth and success, we're at a pivotal point on our journey to realise that aspiration.

As a company, we're passionate about what we do and the citizens we help to serve. If you too would like to help champion the use of technology in public services, to improve outcomes for citizens and public sector organisations, then Civica is the right place for you. We will help you unlock the best version of yourself, achieve growth in your career whilst making a real difference to people and communities.

Why you'll love this role as Data Tester at Civica

As a Data Tester at Civica, you'll play a pivotal role in ensuring the success of multiple data migration projects by safeguarding the accuracy and integrity of financial data. You'll design and execute test cases, validate reconciliations, and apply SQL expertise to verify data across legacy and target systems. Working hand‑in‑hand with Data Engineers, Analysts, and UK stakeholders, you'll be at the heart of complex migrations — identifying and resolving defects, supporting root cause analysis, and ensuring readiness for go‑live. This is your chance to make a tangible impact on mission‑critical systems, grow your expertise in ETL and financial data validation, and thrive in a collaborative, structured environment where your work directly contributes to smoother transitions and trusted outcomes.

Requirements
  • Test planning: Design, build, and maintain test plans, scripts, and cases across migration cycles (mock runs, SIT, UAT, cutover).
  • Data validation: Perform reconciliation checks between source and target systems using mapping specifications.
  • SQL testing: Write queries to compare record counts, field values, and financial totals across systems.
  • Defect management: Log, track, and resolve data defects using tools like Azure DevOps.
  • Root cause analysis: Collaborate with engineers and ETL teams to investigate and resolve issues.
  • Regression testing: Confirm fixes and ensure no new issues are introduced.
  • Financial integrity: Check for duplicates, missing values, incorrect mappings, and broken relationships.
  • Documentation: Maintain clear records of test evidence, sign‑offs, and defect logs.
  • Reporting: Highlight risks, blockers, and readiness for go/no‑go decisions.
  • Cutover support: Participate in go‑live activities and post‑migration checks.
  • Stakeholder alignment: Work with UK‑based stakeholders to align priorities and timelines.
  • SQL expertise: Ability to write queries for data extraction, joins, filtering, and aggregation.
  • Data testing techniques: Experience with reconciliation, sampling, field‑level comparisons, and count checks.
  • Tool proficiency: Familiarity with test management and defect tracking tools (e.g., JIRA, Azure DevOps, HP ALM, TestRail).
  • Advanced Excel: Skilled in XLOOKUP, pivot tables, and formulas for reconciliation and reporting.
  • ETL exposure: Understanding of ETL processes and data migration methodology is a strong plus.
  • Finance knowledge: Basic to intermediate grasp of GL, Chart of Accounts, Trial Balance, AP/AR, and Fixed Assets.
  • ERP familiarity: Prior exposure to SAP, Oracle Financials, Workday Financials, or similar systems.
  • Project experience: Background in testing data for finance transformations, ERP implementations, or migration projects.
  • Attention to detail: Methodical approach with strong analytical and problem‑solving skills.
  • Communication skills: Clear written and verbal communication for defect reporting and stakeholder updates.
  • Collaboration: Comfortable working with UK‑based stakeholders across time zones.
  • Resilience: Ability to manage competing priorities during test cycles and cutover periods.
  • Qualifications: Bachelor's degree in Finance, Accounting, Computer Science, or related field; 1-4 years of experience in data testing/QA; offshore/onshore delivery model exposure preferred.
Benefits
Why you'll love working with us

We know that when our people are happy, they will work better and have greater work satisfaction. Here's what you can expect:

We're all different-and we love this about us.

We provide an inclusive,safe, and welcoming environment to all Civicans, new and old Focus on learning- there are heaps of opportunities to enable you to grow and be your best.

Giving culture-we encourage you to "give back" with benefits such as our Days of Difference leave where you can volunteer for a charity of your choice.

Flexible Work- we have comprehensive flexibility options including part‑time work, adjusted hours, staggered shifts, and hybrid or remote working, supporting work‑life balance based on individual needs.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Tester
Data Tester

Civica UK Ltd • Vadodara

Hybrid
INR 600,000 - 1,200,000
Days of Difference leave
Flexible work options
Data Tester
Data Tester

Civica • India

On-site
INR 600,000 - 900,000
Days of Difference leave
Flexible work options (part-time)
Inclusive culture
Finance Systems Analyst
Finance Systems Analyst

Civica • Vadodara

Hybrid
INR 1,500,000 - 2,500,000
Days of Difference leave
Flexible work from home
Inclusive environment
Finance Systems Analyst
Finance Systems Analyst

Civica UK Ltd • Vadodara

Hybrid
INR 800,000 - 1,100,000
Days of Difference leave
Flexible work arrangement
Volunteer opportunities
CIC Application Support Analyst
CIC Application Support Analyst

Civica UK Ltd • Vadodara

Hybrid
INR 4,050,000 - 6,581,000
Days of Difference leave
Flexible work options
Accounts Executive (Accounts Receivable)
Accounts Executive (Accounts Receivable)

Civica UK Ltd • Vadodara

Hybrid
INR 400,000 - 700,000
Days of Difference leave
Flexible work
Hybrid/Remote work options
Software Test Engineer -Local Government
Software Test Engineer -Local Government

Civica • Vadodara

On-site
INR 1,000,000 - 1,500,000
Flexible Work
Inclusive Environment
Days of Difference leave
Modern Workplace Engineer
Modern Workplace Engineer

Civica • Vadodara

Hybrid
INR 1,200,000 - 1,800,000
Flexible working hours
Hybrid/Remote options
Senior PMO Analyst
Senior PMO Analyst

Civica • Vadodara

Hybrid
INR 1,500,000 - 2,300,000
Days of Difference leave
Flexible Work
Work from home allowance
Modern Workplace Engineer
Modern Workplace Engineer

Civica UK Ltd • Vadodara

Hybrid
INR 1,500,000 - 2,100,000
Flexible work options
Days of Difference leave
Learning opportunities