HCLTech→
Azure Senior Data Lead at HCLTech in Chennai, Tamil Nadu, IN
ExperiencedOn-siteFull-timeChennai, Tamil Nadu, IN
Skills
advanced sqlstored proceduresviewsfunctionsquery optimizationperformance tuningindexing strategiesmulti-dimensional data modelingstar schemasnowflake schemafact modelingdimension modelingdata warehouse architecturenormalizationdenormalizationsql server integration servicesazure data factorydata migrationdata transformationetl designsql server reporting servicespower bidaxpower querydashboard developmentdata visualizationautosysenterprise job scheduling toolsbatch processingworkflow monitoringanalytical skillsproblem-solvingtroubleshootingcommunicationstakeholder managementability to work independentlycollaborationazure data platform servicescloud-based data engineering solutions
Job Description
Job Summary
We are seeking an experienced Senior Data Engineer with 8+ years of expertise in Data Warehousing, ETL Development, Reporting, and Business Intelligence solutions. The ideal candidate should have strong technical knowledge in Advanced SQL, Data Modeling, SSIS, SSRS, Power BI, Azure Data Factory (ADF), and Scheduling Tools such as AutoSys.
The role involves designing, developing, and supporting scalable data solutions, optimizing database performance, building robust ETL pipelines, and delivering high-quality reporting and analytics capabilities to business stakeholders.
Key Responsibilities
- Design, develop, and maintain enterprise-scale Data Warehouse solutions.
- Develop and optimize complex SQL queries, Stored Procedures, Views, Functions, and Indexes.
- Perform database performance tuning, query optimization, and troubleshooting.
- Design and implement dimensional models including Star and Snowflake schemas.
- Apply normalization and denormalization techniques to support business and reporting requirements.
- Develop and support ETL processes using SSIS and Azure Data Factory (ADF).
- Create, maintain, and optimize reports using SSRS.
- Develop interactive dashboards and reports using Power BI.
- Build Power BI semantic models, DAX calculations, and data visualizations.
- Schedule, monitor, and support batch jobs using AutoSys or similar scheduling tools.
- Work closely with business users, analysts, and development teams to gather and understand data requirements.
- Ensure data quality, integrity, security, and governance standards are maintained.
- Provide production support and resolve data-related issues within agreed SLAs.
Skill Requirements
Database & SQL
- Advanced SQL
- Stored Procedures
- Views
- Functions
- Query Optimization
- Performance Tuning
- Indexing Strategies
Data Warehousing & Modeling
- Multi-Dimensional Data Modeling
- Star Schema & Snowflake Schema Design
- Fact & Dimension Modeling
- Data Warehouse Architecture
- Normalization & Denormalization
ETL & Integration
- SQL Server Integration Services (SSIS)
- Azure Data Factory (ADF)
- Data Migration & Data Transformation
- ETL Design and Development
Reporting & Analytics
- SQL Server Reporting Services (SSRS)
- Power BI
- DAX
- Power Query
- Dashboard Development
- Data Visualization & Reporting
Scheduling Tools
- AutoSys
- Enterprise Job Scheduling Tools
- Batch Processing & Workflow Monitoring
Other Requirements
Required Qualifications
- 8+ years of hands-on experience in Data Engineering and Data Warehousing.
- Strong analytical, problem-solving, and troubleshooting skills.
- Excellent communication and stakeholder management skills.
- Ability to work independently and collaborate effectively within cross-functional teams.
Preferred Qualifications
- Experience with Azure Data Platform services.
- Exposure to cloud-based data engineering solutions.
- Experience working in large-scale enterprise environments.