ETL/ ELT Engineering SME

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.

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:

• Strong knowledge of cloud computing architecture, technical design, and implementations including infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) delivery models.
• Strong functional understanding of RDBMS DWH-BI conceptual knowledge.
• Strong SQL skills and performance tuning capabilities.
• Excellent knowledge of the Informatica platform as a whole and the integration among different Informatica components and services.
• Excellent data analysis and data profiling skills using Informatica and Excel.
• Strong experience in infrastructure architecture, such as designing, hardware sizing, effort estimation and security.
• Experience with DataLake and Data Warehouse.
• Previous experience with data analysis activities.
• Working experience in developing application integration using SOAP/REST APIs, APIs leveraged to integrate multiple systems.
• Data Modeling experience, understanding of AWS concepts, Knowledge on Spark is a plus.
• Working knowledge of Spark.

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.