Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data architecture projects from discovery to implementation and oversee data migration to Azure.
- Company: Join a forward-thinking company focused on innovative data solutions in the retail sector.
- Benefits: Enjoy a dynamic work environment with opportunities for professional growth and skill development.
- Why this job: Be at the forefront of data trends and make a real impact on data management strategies.
- Qualifications: Experience with Microsoft Azure stack and strong understanding of data warehousing principles required.
- Other info: This position does not offer sponsorship; ideal for candidates with relevant experience.
The predicted salary is between 43200 - 72000 £ 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 re 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. As a company, we are deeply focused on accelerating our ESG agenda. 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.
Key Responsibilities
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
Familiarity with debugging and troubleshooting ETL processes.
Proficiency in SQL and relational databases (e.g., Oracle, SQL Server, Redshift and Postgrace etc.).
Design and implement complex data transformation logic using Informatica PowerCenter transformations
Develop, test, and implement ETL workflows and mappings using Informatica PowerCenter.
Perform data extraction, transformation, and loading (ETL) processes from various source systems into the target data warehouse.
.
Required Skills and Qualifications:
Strong experience with Informatica PowerCenter (ETL tool) including designing and developing mappings, workflows, and sessions.
Solid understanding of data modeling concepts and data warehousing.
Practical experience on performance tuning techniques for ETL jobs.
Excellent problem-solving skills and ability to work independently or in a team.
Strong communication and documentation skills.
Experience with cloud-based data integration tools (e.g.,AWS).
Familiarity with other ETL tools or scripting languages (e.g., Shellscripting, Python).
Data Architect employer: HCLTech
Contact Detail:
HCLTech Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect
✨Tip Number 1
Make sure to stay updated on the latest trends in data architecture, especially those related to Azure. Familiarize yourself with the specific tools mentioned in the job description, like Azure Data Bricks and Azure Synapse, as this will show your commitment and expertise.
✨Tip Number 2
Highlight any experience you have with migrating data from legacy systems to cloud platforms. Be prepared to discuss specific projects where you successfully managed such migrations, as this is a key responsibility for the role.
✨Tip Number 3
Demonstrate your ability to work with both structured and unstructured data. Prepare examples of how you've identified patterns in data relationships and how that has impacted your previous projects.
✨Tip Number 4
Since communication with non-technical individuals is crucial, practice explaining complex data concepts in simple terms. This will help you stand out during interviews and show that you can bridge the gap between technical and non-technical teams.
We think you need these skills to ace Data Architect
Some tips for your application 🫡
Highlight Relevant Experience: Make sure to emphasize your experience in the full life cycle of data architecture projects. Detail your roles in discovery, design, development, and implementation phases.
Showcase Technical Skills: Clearly list your technical skills related to the Microsoft Azure stack, including ADLS, ADF, and Azure Data Bricks. Mention your proficiency in SQL, Python, and any relevant data modeling techniques.
Communicate Effectively: Demonstrate your ability to communicate complex technical concepts to non-technical stakeholders. Provide examples of how you've successfully collaborated with different teams.
Tailor Your Application: Customize your CV and cover letter to reflect the specific requirements mentioned in the job description. Highlight your experience in the retail domain and any relevant projects you've worked on.
How to prepare for a job interview at HCLTech
✨Showcase Your Full Lifecycle Experience
Be prepared to discuss your experience in the full life cycle of data architecture projects. Highlight specific examples where you discovered, designed, developed, and implemented solutions, especially in relation to Azure.
✨Stay Current on Architecture Trends
Demonstrate your knowledge of current architecture trends and how they relate to market conditions. Be ready to discuss how these trends can influence future data architecture decisions.
✨Communicate Clearly with Non-Technical Stakeholders
Practice explaining complex technical concepts in simple terms. This will help you connect with non-technical individuals during the interview, showcasing your ability to bridge the gap between technical and non-technical teams.
✨Highlight Your Retail Domain Experience
If you have experience in the retail domain, make sure to emphasize it. Discuss specific projects or challenges you've faced in this area, as it will be relevant to the role and demonstrate your industry knowledge.
