i
HCLTech
Filter interviews by
I am an experienced ETL Developer with a strong background in data integration and transformation.
Over 5 years of experience in ETL development
Proficient in using tools like Informatica, Talend, and SSIS
Strong SQL skills for data querying and manipulation
Experience in designing and implementing data warehouses
Familiar with data modeling and ETL best practices
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
I am using Talend version 7.3.1 for ETL development.
I am currently using Talend version 7.3.1 for ETL development.
The specific version of Talend being used is 7.3.1.
Talend 7.3.1 offers various features and improvements for ETL processes.
What people are saying about HCLTech
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
The greatest challenge faced during migration to cloud from on-premise DB is ensuring data security and compliance.
Ensuring data security during transit and at rest
Maintaining compliance with regulations and industry standards
Minimizing downtime and ensuring data integrity
Optimizing performance and cost efficiency in the cloud environment
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded into a data warehouse. ELT is Extract, Load, Transform where data is extracted, loaded into a data warehouse, and then transformed.
ETL involves extracting data from source systems, transforming it according to business rules, and loading it into a data warehouse.
ELT involves extracting data from source systems, loading it into a data wareh...
Loads in Informatica refer to the process of moving data from source to target in a data warehouse.
Loads involve extracting data from source systems
Transforming the data as needed
Loading the data into the target data warehouse or database
Loads can be full, incremental, or delta depending on the requirements
Example: Loading customer data from a CRM system into a data warehouse for analysis
Use GROUP BY and HAVING clause to find duplicates in a table.
Use GROUP BY to group rows with same values together
Use HAVING COUNT(*) > 1 to filter out duplicates
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed before Aug 2022. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Apr 2023. There was 1 interview round.
based on 2 interviews
Interview experience
based on 5 reviews
Rating in categories
Software Engineer
23.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
21.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
15.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Engineer
14.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
14.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Accenture
Cognizant