Senior ETL Data Engineer

Tata Consultancy Services

Tata Consultancy Services (TCS) invites seasoned professionals to join their purpose-led transformation journey, as they aid global brands in meaningful technological transitions. As part of an agile team, this role offers an opportunity to tackle ambitious projects, focusing on the reinvention of legacy systems and modern data strategies.

In this role you can expect to have the responsibilities:

• Design and develop solutions to migrate data from 'Golden' sources for various stakeholders.
• Drive data modernization by transitioning legacy data warehouses to cloud platforms.
• Engage in Program Increment planning as part of a Scaled Agile Framework.

This role comes with the following benefits:

• Competitive salary with pension and healthcare benefits.
• Life assurance, laptop, and phone provided.
• Access to training resources and discounts within the Tata network.
• A diversity and inclusion-focused workplace with various employee networks.
• Opportunities for involvement in health, wellness, and social initiatives.

This role requires you to have:

• Experience with ETL/ELT processes using SQL Server and SSIS.
• Proficiency in writing and optimizing SQL queries and stored procedures.
• In-depth knowledge of data pipeline design and data warehousing solutions.
• Familiarity with large-scale data processing and query optimization using TSQL.
• Experience in implementing audit and control mechanisms in data solutions.
• Knowledge of source control systems and CICD pipeline implementation.

You would benefit from having:

TCS is dedicated to inclusivity, aligning with the Ireland Employment Equality Acts and Equal Status Acts. They promote a culture of diversity and equity, offering support and adjustments during the recruitment process for disabled applicants.