i
Infosys
Filter interviews by
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;
Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.
Optimize data flow by using efficient data sources and destinations
Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations
Increase parallelism by using multiple threads and optimizing task execution order
Use performance monitoring tools like SSIS logging and performance counters...
I applied via Company Website and was interviewed before Jan 2024. There was 1 interview round.
Use a script to find and delete files older than 30 days.
Use a script to identify files older than 30 days based on their creation or modification date
Utilize a command like find or PowerShell to search for files older than 30 days
Combine the script with a delete command to remove the identified files
Infosys interview questions for designations
What people are saying about Infosys
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.
Mapping is the process of defining the relationship between source and target data in ETL.
Mapping involves identifying the source and target data structures.
It also involves defining the transformation rules to be applied to the source data.
Mappings can be simple or complex depending on the complexity of the data.
Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target
Session refers to a period of time during which a user interacts with a computer system or application.
A session is created when a user logs into a system or application.
It is used to track user activity and maintain user-specific data.
Sessions can be terminated manually or automatically after a certain period of inactivity.
Session management is important for security purposes.
Examples of session management techniques
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 Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
based on 4 interviews
1 Interview rounds
based on 15 reviews
Rating in categories
Technology Analyst
55.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Systems Engineer
50.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
System Engineer
39.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
30.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate Consultant
28k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Cognizant
Accenture