ETL/ ELT Engineering SME (City of London)

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.

The Role

As an 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.

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!

Join us and do more of what matters. Apply online now.