Technical Lead
India
Job Description
Technical Lead
| Noida, Uttar PradeshHyderabad, Telangana

Job Summary

As a Microsoft Fabric Data Engineer at HCLTech, you will play a pivotal role in architecting and implementing advanced data solutions leveraging Microsoft Fabric. You will be responsible for designing robust data pipelines, ensuring the integrity and quality of data, and enabling actionable business intelligence across the organization. Your expertise will directly contribute to empowering data-driven decision-making and accelerating the company’s transformation initiatives.
Detailed Responsibilities
• Design, develop, and implement scalable ETL processes using Microsoft Fabric to extract, transform, and load data from diverse sources into cloud-based data warehouses or lakehouses.
• Collaborate closely with data analysts, engineers, and stakeholders to gather business requirements and translate them into effective data solutions.
• Build and maintain Power BI dashboards and reports, delivering actionable insights from complex datasets to drive informed business decisions.
• Enforce data quality, integrity, and accuracy throughout the ETL lifecycle, implementing industry best practices for data management and governance.
• Monitor ETL processes, proactively identifying and resolving issues or performance bottlenecks to maintain high system reliability.
• Document ETL workflows, data mappings, and process changes to ensure transparency and clear communication across technical and non-technical teams.
• Implement advanced data transformation and ingestion patterns, including CDC, schema evolution, and error handling for robust data operations.

Key Responsibilities

Detailed Responsibilities:
• Design, develop, and implement scalable ETL processes using Microsoft Fabric to extract, transform, and load data from diverse sources into cloud-based data warehouses or lakehouses.
• Collaborate closely with data analysts, engineers, and stakeholders to gather business requirements and translate them into effective data solutions.
• Build and maintain Power BI dashboards and reports, delivering actionable insights from complex datasets to drive informed business decisions.
• Enforce data quality, integrity, and accuracy throughout the ETL lifecycle, implementing industry best practices for data management and governance.
• Monitor ETL processes, proactively identifying and resolving issues or performance bottlenecks to maintain high system reliability.
• Document ETL workflows, data mappings, and process changes to ensure transparency and clear communication across technical and non-technical teams.
• Implement advanced data transformation and ingestion patterns, including CDC, schema evolution, and error handling for robust data operations.

Skill Requirements

Must Have Skills: 

• 7+ years of hands-on experience in ETL development, specifically utilizing Microsoft Fabric in recent projects.
• Expertise in Microsoft Fabric Data Pipelines (activities, triggers, parameters) and Notebooks (PySpark/Spark SQL).
• Deep working knowledge of Delta Lake, including schema evolution, MERGE/UPSERT, OPTIMIZE/VACUUM, partitioning, and checkpointing.
• Proficiency in CDC ingestion patterns (watermarks, change tables, log-based ingestion).
• Strong SQL skills (window functions, CTEs) and experience with PySpark for data transformations and performance tuning.
• Experience with data quality implementation: rule patterns (null, range, referential, uniqueness), scorecards, and exception handling.
• Advanced error handling & observability: idempotency, retries, dead-letter handling, and alerting hooks.

Nice to Have Skills: 

• Experience with additional ETL tools (e.g., SSIS) and data warehousing solutions.
• Understanding of data governance, data privacy, and compliance standards.
• Familiarity with programming languages such as Python or R for advanced data manipulation.
• Experience with stored procedures in Fabric transformations.
• Knowledge of metadata-driven pipelines and parameterization (YAML/JSON controlled).
• Awareness of Power BI model readiness (star schema, aggregations).

Other Requirements

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 7+ years of hands-on experience in ETL development, specifically utilizing Microsoft Fabric in recent projects.
• Solid understanding of Business Intelligence concepts and hands-on experience in Power BI for data visualization and reporting.
• Strong grasp of data warehousing concepts, architectures, and modeling techniques.
• Familiarity with major cloud platforms (Azure, AWS, Google Cloud) and their data storage and processing services.
• Proficiency in SQL and experience with relational databases such as SQL Server or Oracle.
• Knowledge of data modeling, normalization, and denormalization.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication skills, capable of conveying complex technical concepts to non-technical audiences.

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.