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 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. 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
1. Collaborate with the DBA team to optimize database queries and improve ETL job performance.
2. Perform performance tuning of ETL processes to meet project requirements and deadlines.
3. Troubleshoot and resolve issues related to ETL processes, data integration, and system performance.
4. Ensure data accuracy, integrity, and consistency by performing data profiling and validation.
5. Ensure compliance with best practices, coding standards, and development processes.
6. Familiarity with debugging and troubleshooting ETL processes.
7. Proficiency in SQL and relational databases (e.g., Oracle, SQL Server, Redshift, and PostgreSQL).
8. Design and implement complex data transformation logic using Informatica PowerCenter transformations.
9. Develop, test, and implement ETL workflows and mappings using Informatica PowerCenter.
10. Perform data extraction, transformation, and loading (ETL) processes from various source systems into the target data warehouse.
Required Skills and Qualifications:
1. Strong experience with Informatica PowerCenter (ETL tool) including designing and developing mappings, workflows, and sessions.
2. Solid understanding of data modeling concepts and data warehousing.
3. Practical experience on performance tuning techniques for ETL jobs.
4. Excellent problem-solving skills and ability to work independently or in a team.
5. Strong communication and documentation skills.
6. Experience with cloud-based data integration tools (e.g., AWS).
7. Familiarity with other ETL tools or scripting languages (e.g., Shell scripting, Python).
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting and Financial Services
#J-18808-Ljbffr