ETL/ ELT Engineering SME (City of London)

If you need support in completing the application or if you require a different format of this document, please get in touch with at UKI.recruitment@tcs.com or call TCS London Office number 02031552100 / +44 204 520 2575 with the subject line: “Application Support Request”.

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.

Are you looking to take on a role in Data?

We have an exciting role for you – ETL / ELT Engineering SME.

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.

• Build strong relationships with a diverse range of stakeholders.
• Gain access to endless learning opportunities.
• Work closely with the range of teams within the business to bring products to life.

The Role

As a ETL / ELT Engineering SME , you will be working on designing, developing, and supporting data applications and infrastructure using ETL tools such as IDMC and Informatica Power Center. This position offers a chance to work with cutting-edge data technologies, providing significant impact on data management and processing within the organization.

Your responsibilities:

• Implementing and managing data processing workflows to handle large volumes of data efficiently.
• Utilizing cloud computing models (IaaS, PaaS, SaaS) for scalable and secure data management.
• Collaborating with cross-functional teams to design and optimize cloud-based data solutions.
• Ensuring data quality, integration, and performance through best practices and advanced ETL techniques.
• Implement data quality checks & Standardization in the code.
• Document all mappings, mapplets and rules in detail and hand over documentation to the customer.
• Create solutions and environments to enable Analytics and Business Intelligence capabilities.

Your Profile

Essential skills/knowledge/experience:

• Design, develop, and maintain scalable ETL pipelines using AWS Glue (PySpark) .
• Strong hands-on experience with DBT (Cloud or Core) .
• Implement and manage DBT models for data transformation and modeling in a modern data stack.
• Proficiency in SQL , Python , and PySpark .
• Experience with AWS services such as S3, Athena, Redshift, Lambda, and CloudWatch.
• Familiarity with data warehousing concepts and modern data stack architectures.
• Experience with CI/CD pipelines and version control (e.g., Git).
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements.
• Optimize data workflows for performance, scalability, and cost-efficiency.
• Ensure data quality, integrity, and governance across all pipelines.
• Contribute to the development of best practices and standards for data engineering and transformation.

Desirable skills/knowledge/experience:

• Working knowledge of AWS GLUE, DBT, ETL.

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 UKI.recruitment@tcs.com 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 UKI.recruitment@tcs.com with the subject line: “Adjustment Request” or call TCS London Office 02031552100 / +44 204 520 2575 to request an adjustment. 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 UKI.recruitment@tcs.com 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.