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 BiAzure
- Data Lake
- Dax
- SQL Server
- SSIS
- ETL
Send Resume to: santhoshkumar.k@hcl.com.