Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to optimise database queries and enhance ETL job performance.
- Company: HCLTech is a global tech leader, innovating across 60 countries with a focus on sustainability.
- Benefits: Enjoy flexible work options, diverse culture, and opportunities for personal growth.
- Why this job: Be part of a mission-driven company that values technology and people for positive global impact.
- Qualifications: Proficiency in SQL, experience with ETL processes, and familiarity with AWS required.
- Other info: We're committed to achieving net zero by 2040, making a difference together.
The predicted salary is between 36000 - 60000 £ per year.
HCLTech is a global technology company, spread across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
We are powered by our people - a global, diverse, multi-generational talent representing 161 nationalities whose unique spark, perspective and boundless passion drive our culture of proactive value creation and problem-solving. Our purpose is to bring together the best of technology and our people to supercharge progress for everyone, everywhere - our clients, partners, their stakeholders, communities, and the planet. We are also creating technology-enabled sustainable solutions with and for our clients and partners. We embed ESG imperatives into every aspect of our business and ensure that the progress we supercharge is responsible, inclusive and beneficial to all our stakeholders in the long term. We have committed to achieving net zero by 2040.
- Collaborate with the DBA team to optimize database queries and improve ETL job performance.
- Perform performance tuning of ETL processes to meet project requirements and deadlines.
- Troubleshoot and resolve issues related to ETL processes, data integration, and system performance.
- Ensure data accuracy, integrity, and consistency by performing data profiling and validation.
- Ensure compliance with best practices, coding standards, and development processes.
- Proficiency in SQL and relational databases (e.g., Oracle, SQL Server, Redshift and PostgreSQL).
- Design and implement complex data transformation logic using Informatica PowerCenter transformations.
- Perform data extraction, transformation, and loading (ETL) processes from various source systems into the target data warehouse.
- Solid understanding of data modeling concepts and data warehousing.
- Practical experience on performance tuning techniques for ETL jobs.
- Experience with cloud-based data integration tools (e.g., AWS).
- Familiarity with other ETL tools or scripting languages (e.g., Shell scripting, Python).
Data Architect - AWS (Permanent) employer: HCLTech
Contact Detail:
HCLTech Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect - AWS (Permanent)
✨Tip Number 1
Familiarise yourself with AWS services, especially those related to data storage and processing. Understanding how AWS integrates with ETL processes will give you a significant edge during interviews.
✨Tip Number 2
Brush up on your SQL skills and be prepared to discuss complex queries you've written in the past. Being able to demonstrate your proficiency in SQL can set you apart from other candidates.
✨Tip Number 3
Showcase any experience you have with data modelling and performance tuning of ETL jobs. Be ready to provide examples of how you've optimised processes in previous roles.
✨Tip Number 4
Network with professionals in the data architecture field, particularly those who work with HCLTech or similar companies. Engaging with industry peers can provide insights and potentially lead to referrals.
We think you need these skills to ace Data Architect - AWS (Permanent)
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Data Architect position at HCLTech. Familiarise yourself with key terms like ETL processes, data integration, and cloud-based tools.
Tailor Your CV: Customise your CV to highlight relevant experience in SQL, data modelling, and ETL processes. Emphasise any previous work with AWS or similar cloud platforms, as well as your proficiency in tools like Informatica PowerCenter.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data architecture and your understanding of HCLTech's mission. Mention specific projects or experiences that demonstrate your ability to optimise database queries and improve ETL performance.
Proofread Your Application: Before submitting, carefully proofread your application materials. Check for spelling and grammatical errors, and ensure that all information is clear and concise. A polished application reflects your attention to detail.
How to prepare for a job interview at HCLTech
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in SQL and your experience with relational databases like Oracle and SQL Server. Be prepared to discuss specific projects where you've optimised database queries or improved ETL job performance.
✨Demonstrate Problem-Solving Abilities
HCLTech values proactive problem-solving. Prepare examples of how you've troubleshot issues related to ETL processes or data integration in the past, and explain the steps you took to resolve them.
✨Understand Data Modelling Concepts
Familiarise yourself with data modelling concepts and be ready to discuss how you've applied these in your previous roles. This will show your understanding of data warehousing and its importance in the role.
✨Discuss Cloud Experience
Since the role involves cloud-based data integration tools, be sure to talk about your experience with AWS and any other relevant cloud technologies. Highlight any specific projects where you've implemented these tools effectively.
