HCL Job Opening For ADF/ADL
HCL Job Opening For ADF/ADL
Company: HCL Technologies Ltd
Experience: 5 – 10 years
Location: Noida, Kolkata, Hyderabad/Secunderabad, Pune, Chennai, Bangalore/Bengaluru, Mumbai
Job Description:
- Expertise in SQL Server and T-SQL (DDL, DML, and DCL) in constructing Tables, Joins, Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules.
- Experience Data Extraction, Transforming and Loading (ETL) using SSIS.
- Worked with various Transformations like Lookup, Derive Column, Merge, Sort, Multicast, Conditional Split, &Tasks Data Flow Task, Execute SQL Task and lot more using SSIS.
- Implemented Error Handling/ debugging the packages with Data Viewers, Breakpoints, Event Handlers and Configure Error Output.
- Experienced in Azure ADF data migration projects from On-Prem to Cloud.
- Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob.
- Experience on creating CUBES using SSAS tabular and writing DAX Queries to create Power BI reports.
- Hands on experience with Azure Data Lake, Azure Data Factory, Azure SQL Database.
Education
UG :Any Graduate
PG :Any Postgraduate
Key Skills:
- Azure Data Factory
- T-SQL
- SSAS
- Power Bi
- AzureData Lake
- Dax
- SQL Server
- SSI
- SETL
Send Resume to: santhoshkumar.k@hcl.com.