Senior Technical Specialist
India
Apply now
Job Description
Senior Technical Specialist
| Gautam Buddha Nagar, Uttar PradeshHyderabad, Telangana

Job Summary

Job Title: Business Intelligence – ETL Developer Lead  Experience: 10+ Years  Location: Noida / Hyderabad  Role Overview  We are seeking an experienced BI ETL Developer Lead with 10+ years of expertise in designing, developing, and managing data integration and ETL processes. The ideal candidate will lead a team of ETL developers, ensure high-quality data pipelines, and support business intelligence solutions for enterprise analytics.  Key Responsibilities  Lead the design and development of ETL/ELT processes and data integration workflows  Build, optimize, and maintain high-performance data pipelines for data warehousing and BI reporting  Manage and mentor a team of ETL developers, ensuring best practices and coding standards  Collaborate with business stakeholders to gather and translate data requirements into technical solutions  Design and maintain data models (Dimensional / Star / Snowflake schemas)  Ensure data quality, integrity, and consistency across systems  Perform performance tuning and optimization of ETL jobs and SQL queries  Manage data extraction from multiple heterogeneous sources (databases, APIs, flat files, etc.)  Support data validation, reconciliation, and troubleshooting  Implement and enforce data governance and documentation standards  Work with BI teams to enable reporting, dashboards, and analytics solutions  Drive automation and scheduling using job orchestration tools  Participate in architecture discussions and solution design  Required Skills & Qualifications  Core ETL & BI Skills  Hands-on experience in ETL tools such as:   Informatica / Talend / DataStage / SSIS / ADF (any leading tool)  Strong expertise in:   Data Warehousing concepts and architecture  Data modeling (Dimensional modeling, Star/Snowflake schema)  Extensive experience in building batch data pipelines  Database & SQL Expertise  Advanced proficiency in SQL  Experience with databases such as:   Teradata (preferred), Oracle, SQL Server, Snowflake, BigQuery  Strong experience in query optimization and performance tuning  Programming & Scripting  Working knowledge of:   Python / Shell scripting  Understanding of automation and data processing frameworks  Data Integration & Processing  Experience handling:   Large-scale data processing  Data ingestion, transformation, and validation  Familiarity with data quality frameworks and reconciliation techniques  Tools & Technologies  Version control: Git / Bitbucket  Job scheduling tools: Control-M / Autosys / Airflow  Exposure to cloud platforms (Azure / AWS / GCP) – preferred  Leadership & Management Skills  Experience in leading and managing ETL/BI teams  Ability to drive delivery within timelines and quality standards  Strong stakeholder management and cross-functional coordination  Experience in conducting code reviews and technical mentoring  Soft Skills  Strong analytical and problem-solving skills  Excellent communication and presentation abilities  Ability to work in a fast-paced and deadline-driven environment 

Key Responsibilities

null

Skill Requirements

null

Other Requirements

Detail-oriented with focus on data accuracy 

 

Education 

Bachelor’s or Master’s degree in Computer Science, Engineering, or related field 

 

Preferred Qualifications 

Experience in Teradata-based environments (strong advantage based on your org context) 

Exposure to BI tools (Power BI, Tableau) 

Experience with cloud-based ETL (ADF, Glue, etc.) 

Knowledge of big data technologies (Spark, Hadoop) is a plus 

 

Why Join Us 

Work on enterprise-scale data integration and BI platforms 

Opportunity to lead and mentor high-performing data teams 

Exposure to modern data engineering and cloud ecosystems 
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people 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. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.