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