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 with the subject line: "Application Support Request".
Role: Senior SSIS_ SQL Data Engineer
Job Type: Permanent
Location: Letterkenny (Hybrid 2/3 days onsite)
Ready to utilise your skills in Data Engineering?
Are you passionate about helping customers modernize and execute their data strategies?
Join us as Senior SSIS SQL Engineer and be part of a collaborative Data Engineering team to develop end-to-end solutions as well as take on a fantastic career growth opportunity
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.
Careers at TCS: It means more
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.
Role Overview
The SSIS SQL Server Developer is responsible for designing, developing, and maintaining ETL processes and data integration solutions using Microsoft SQL Server Integration Services (SSIS). This role supports enterprise data warehousing initiatives and ensures efficient, accurate, and secure data movement across systems.
Please note US hours coverage required (1pm – 9pm GMT)
Your Responsibilities:
* Design ETL workflows and SSIS package to meet business requirements.
* Create scalable and maintainable data integration solutions aligned with best practices.
* Design data warehouse schemas (star and snowflake models) and dimensional models for reporting and analytics.
* Design, develop, and optimize SQL/T-SQL components, ETL processes using SSIS to extract, transform, and load data from multiple sources into staging and data warehouse environments.
* Build data transformations, including importing data from files and migrating data between platforms.
Key skills/knowledge/experience:
* Strong proficiency with SQL and its variation among popular databases
* Extensive experience in SQL Server Development: Create and maintain stored procedures, functions, views, triggers, and indexes for ETL workflows. Perform query optimization and performance tuning for large datasets.
* Extensive experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance.
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.
Diversity, Inclusion & Wellbeing
At TCS, we believe in building and sustaining a culture of equity and belonging where everyone can thrive. Our diversity motto is 'Inclusion without Exception'.
You'll find a welcoming culture and many internal volunteering and social networks to join. Our diversity, inclusion and social activities include LGBTQ+ and mental health networks, as well as health and wellness initiatives and sports events (we even sponsor the London Marathon).
We are open to all and treat applications equally, regardless of ethnicity, disability, gender identity, gender reassignment, age, sexual orientation, or beliefs.
If you are an applicant who needs an accommodation due to a disability to complete an employment application, or during any phase of the hiring process, please contact us at with the subject line: "Disability Accommodation Request".
Due to a 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.
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 to report any fraudulent activity.
Join us and do more of what matters. Apply online now.