HCLTech · 2 days ago
ETL Specialist
Providence, RI
Full-time
Onsite
Mid, Senior Level
$85K/yr - $176K/yr
7+ years expHCLTech is looking for a highly talented and self-motivated ETL / Informatica Specialist to join it in advancing the technological world through innovation and creativity. This role will focus on redesigning, optimizing, and validating ETL pipelines as the client transitions from legacy data systems to a modern SQL Server–based environment.
Information and Communications Technology (ICT)IT ManagementOutsourcingSoftwareTelecommunications
Hiring Manager
Neha G.
Responsibilities
Redesign and modernize ETL pipelines to transition data workflows from Sybase to SQL Server
Analyze existing Informatica ETL jobs and update source and target configurations based on new architecture
Ensure data accuracy, completeness, and consistency throughout ETL execution cycles
Optimize ETL performance to support large-scale data processing and reduce load times
Implement robust error handling, logging, and recovery mechanisms within ETL workflows
Collaborate closely with data engineers to ensure transformation logic aligns with updated database schemas
Validate ETL outputs against business requirements, regulatory standards, and legacy datasets
Utilize scheduling tools (e.g., Control-M) to manage and coordinate data load processes
Support performance tuning and integration activities related to SQL Server
Contribute to documentation, best practices, and knowledge transfer within the project team
Qualification
Required
7–10 years of experience working with ETL tools, with strong expertise in Informatica
Advanced proficiency in SQL Server, including integration techniques and performance optimization
Solid understanding of data warehousing concepts, including star schemas, fact/dimension modeling, and data quality principles
Experience with enterprise workload scheduling tools such as Control-M
Demonstrated success analyzing and re-engineering complex ETL jobs in large-scale environments
Strong problem-solving ability with meticulous attention to data accuracy and system reliability
Preferred
Experience working in consulting or other client-facing roles
Experience migrating or modernizing ETL pipelines from legacy RDBMS systems (e.g., Sybase)
Familiarity with Financial Services data domains (e.g., transactions, risk, operations, regulatory reporting)
Knowledge of best practices in data governance, metadata management, and production support
Relevant certifications (Informatica, SQL Server, cloud data certifications, etc.)
Benefits
Medical
Dental
Vision
Pharmacy
Life
Accidental death & dismemberment
Disability insurance
Employee assistance program
401(k) retirement plan
10 days of paid time off per year
10 paid holidays per year
Company
HCLTech
HCLTech is a global IT company offering digital, engineering, and cloud solutions partnering with businesses for transformation.
10001+ employees
H1B Sponsorship
HCLTech has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2975)
2024 (3974)
2023 (3649)
2022 (3861)
2021 (4093)
2020 (4317)
Funding
Current Stage
Public CompanyTotal Funding
$220MKey Investors
ChrysCapital
2008-07-10Post Ipo Equity· $220M
2000-01-06IPO
Leadership Team
Vijayakumar C.
Chief Executive Officer
Alan Flower
Executive Vice President - CTO & Global Head, AI & Cloud Native Labs
Recent News
2026-01-05
Techcircle
2025-12-31
Company data provided by crunchbase