Data Architect

HCLTech; Greater London; On-site; GBP 45,000 - 80,000; Full time

Job summary

An established industry player is seeking a talented Data Architect to join their dynamic team in London. This role focuses on optimizing ETL processes and ensuring data integrity while working with cutting-edge technologies. You'll collaborate with a diverse team to design and implement complex data transformations, leveraging tools like Informatica PowerCenter and AWS. If you're passionate about data and eager to make a substantial impact in a forward-thinking environment, this opportunity is perfect for you. Join a company committed to innovation and sustainability, and help shape the future of technology-driven solutions.

Qualifications

• Strong experience with Informatica PowerCenter for ETL processes.
• Solid understanding of data modeling concepts and data warehousing.
• Excellent problem-solving skills and ability to work independently.

Responsibilities

• Collaborate with the DBA team to optimize database queries.
• Perform performance tuning of ETL processes to meet project requirements.
• Ensure data accuracy, integrity, and consistency through profiling.

Skills

Informatica PowerCenter

SQL

Data Modeling

ETL Processes

Cloud Data Integration

Problem-Solving

Communication Skills

Tools

AWS

Oracle

SQL Server

Redshift

PostgreSQL

Job description

Direct message the job poster from HCLTech

Talent Acquisition- HR APPS & SI-TAG (UK & Europe) at HCL Technologies

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).

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting and Financial Services

Referrals increase your chances of interviewing at HCLTech by 2x

Sign in to set job alerts for “Data Architect” roles.

London, England, United Kingdom 1 week ago

Greater London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 2 months ago

City Of London, England, United Kingdom 6 days ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 months ago

Croydon, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 4 days ago

London, England, United Kingdom 2 weeks ago

Greater London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.