If you need support in completing the application or if you require a different format of this document, please get in touch with us at [email protected] with the subject line: “Application Support Request”.
Job Type: Permanent
Location: Letterkenny GDC, Co. Donegal (Hybrid – minimum 3 days onsite per week)
Do you have strong experience in ETL and data testing, with the ability to validate complex data flows and integrations?
Do you bring a solid QA background, with experience in automation testing and defect investigation across enterprise applications?
Are you an analytical problem solver who enjoys investigating data issues, identifying risks early, and helping teams deliver quality solutions with confidence?
Make your mark at TCS as an
ETL/Data Test Engineer.
Join a global tech leader right here in Donegal. With over 850 employees and a state-of-the-art global delivery centre, we’re proud to offer world-class career opportunities without having to leave the Northwest. Recognised as Workplace of the Year by the Letterkenny Chamber, we foster a culture of continuous learning, innovation, and respect. Our people are at the heart of everything we do – collaborating across teams, geographies, and disciplines to drive real change for clients around the world. Be part of something global, grounded in Donegal.
TCS is a purpose-led transformation company, built on belief. We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve - our clients include some of the biggest brands in the UK and worldwide. For you, it means more to make an impact that matters, through challenging projects which demand ambitious innovation and thought leadership.
-
Join a leading global IT services organisation.
-
Be part of an exciting team where you will be challenged every day.
-
Gain exposure to innovative technology.
The Role
We are seeking an experienced
ETL/Data Test Engineer with a strong background in data testing and quality assurance. The ideal candidate will have proven experience in ETL testing, data migration testing, data reconciliation testing, SQL validation, batch processing validation, and Automation testing. This is a hands-on role for that requires a detail-oriented professional who can analyse complex data flows, investigate issues, perform root cause analysis, and ensure the accuracy and integrity of data across multiple systems.
You will help shape the testing approach, review requirements, understand business context, validate data and integrations, and clearly communicate quality risks before release. The role suits someone proactive, practical and confident, with the ability to work across different priorities while keeping quality and delivery in focus.
The successful candidate should be comfortable working in a fast-paced Agile environment and possess excellent communication, stakeholder management, and analytical skills.
Key Responsibilities:-
Own QA activities for assigned work from requirement review through to release readiness.
- Review user stories and requirements to understand business context, risks, dependencies and downstream impacts.
- Design and execute clear test scenarios covering functional, integration, regression, data and edge-case testing.
- Ask questions, validate assumptions and raise risks early when requirements, test coverage, environments or timelines are unclear.
- Clearly communicate test progress, defects, blockers, release confidence and any remaining quality risks.
- Take part in Agile ceremonies, including refinement, sprint planning, stand-ups, defect triage and release discussions.
- Support colleagues through knowledge sharing, constructive feedback and a strong team-first approach.
- Perform end-to-end ETL and data testing activities.
-
Validate source-to-target mappings, transformation rules, and business requirements.
-
Execute data migration, data reconciliation, and data validation testing.
-
Verify data accuracy, completeness, consistency, and integrity across multiple systems.
-
Perform backend database testing and large-scale data analysis.
-
Analyse files including CSV, TXT, XML, and JSON for data validation purposes.
-
Write and execute complex SQL queries for backend validation and reconciliation.
-
Monitor and validate batch-processing activities and scheduled jobs.
-
Analyse job failures and perform detailed root cause investigations.
-
Review and understand Python-based scripts used in data-processing workflows.
-
Work in Linux/Unix environments to analyse logs and troubleshoot issues.
-
Execute automated tests using existing Java and Python-based frameworks.
Your Profile
Essential skills/knowledge/experience:-
5+ years of experience in software testing, quality engineering or a similar technical QA role.
- Strong analytical and troubleshooting skills with experience in system validation, defect analysis, root cause identification, and cross-system data reconciliation.
-
Strong understanding of SDLC, Agile delivery, Jira and Confluence.
- Good critical thinking skills, with the ability to consider broader business impact, edge cases and production risk.
- Confident communicator who can ask clear questions, challenge assumptions professionally and raise concerns early.
- Strong ownership, organisation and prioritisation skills, especially when managing multiple work items or business areas.
- Willingness to use AI-enabled tools responsibly to improve productivity, analysis, documentation or testing effectiveness.
- Hands-on experience with test automation, ideally using Selenium and automation frameworks.
Required Technical Skills
ETL & Data Testing-
Strong and recent ETL/Data Testing experience.
-
Proven experience in:
- ETL Testing
-
Data Validation Testing
-
Data Migration Testing
-
Data Reconciliation Testing
-
Source-to-Target Validation
-
Data Quality Testing
-
Data Recon Automation Testing
-
Experience validating large and complex datasets.
-
Strong understanding of data lifecycle, data transformations, and batch processing.
SQL & Database Testing-
Advanced SQL skills and data analysis capability.
-
Experience writing complex queries using:
- Joins
-
Aggregations
-
Subqueries
-
Window Functions
-
Reconciliation Queries
-
Experience working with SQL Server, PostgreSQL, MsSQL or Oracle.
-
Strong database testing and backend validation experience.
Data Analysis & Excel-
Advanced Microsoft Excel skills.
-
Experience using:
- Pivot Tables
-
VLOOKUP/XLOOKUP
-
Conditional Formatting
-
Data Comparison Techniques
-
Data Reconciliation Methods
-
Ability to analyse large datasets and identify anomalies, trends, and discrepancies.
-
Ability to use text/data compare tools like Beyond Compare.
Linux & Job Monitoring-
Strong Linux/Unix knowledge.
-
Experience analysing logs and troubleshooting batch-processing issues.
-
Experience working with Autosys or similar enterprise scheduling tools.
-
Ability to investigate job failures and perform root cause analysis.
Automation Knowledge (Preferred)-
Experience executing and troubleshooting automated test suites.
-
Exposure to Java, Selenium, TestNG, Python, PyTest
-
Ability to understand existing automation frameworks.
-
Ability to review and understand Python scripts used within testing and data-processing workflows.
Desirable skills/knowledge/experience:
- Experience in Financial Services, Asset Management, Banking, Capital Markets or another data-driven enterprise environment.
- Previous experience as a Senior QA, QA Lead, Automation Lead or mentor to other testers.
- Experience testing data feeds, reporting processes, audit trails, market data or complex downstream data processes.
- Exposure to cloud platforms such as AWS or Azure.
- Experience with CI/CD, DevOps practices or continuous testing approaches.
- Relevant certifications such as ISTQB, Agile/Scrum, AWS, Azure or automation-related certifications.
Rewards & Benefits
TCS is consistently voted a Top Employer in the UK and globally. Our competitive salary packages feature pension, health care, life assurance, laptop, phone, access to extensive training resources and discounts within the larger Tata network.
We offer health & wellness initiatives and sports events; we are the proud sponsor of the London Marathon.
Diversity, Inclusion and Wellbeing
Tata Consultancy Services UK&I is committed to meeting the accessibility needs of all individuals in accordance with the UK Equality Act 2010 and the UK Human Rights Act 1998.
We welcome and embrace diversity in race, nationality, ethnicity, disability, neurodiversity, gender identity, age, physical ability, gender reassignment, sexual orientation. We are a disability inclusive employer and encourage disabled people to apply for this role.
As a Disability Confident Employer, we offer an interview to applicants with disabilities or long-term conditions who meet the minimum criteria for the role. Please email us at
[email protected] if you would like to opt in.
If you are an applicant who needs any adjustments to the application process or interview, please contact us at
[email protected] with the subject line: “Adjustment Request”. We welcome requests prior to you completing the application and at any stage of the recruitment process.
Beware of Fraudulent offers
This is to notify you that TCS does not ask for any sort of payment or security deposit from candidates at any stage of the recruitment process. The firm never sends out job offers from free internet email services like Gmail, Yahoo Mail, and so on. TCS has not authorised any third-party company to collect money on their behalf. As a vigilant job seeker, beware of fraudulent recruitment activity and protect your interests!
You can write to
[email protected] to report any fraudulent activity.
Due to the high volume of applications, we will be unable to contact each applicant individually on the status of their application. If you have not received a direct response within 30 days, then it should be deemed unsuccessful on this occasion.
Join us and do more of what matters. Apply online now. 