CGI Group ETL Tester Interview Questions and Answers for Experienced

Static class and static constructor in C#

• Static class can only contain static members and cannot be instantiated

• Static constructor is called only once when the class is first accessed

• Static constructor is used to initialize static members of the class

• Example: Math class in C# is a static class

• Example: static constructor can be used to initialize a static variable with a value

Performance improvement in Angular app

• Use lazy loading to load modules on demand

• Optimize change detection strategy

• Use trackBy function in ngFor loops

• Minimize DOM manipulation

• Use AOT compilation

• Implement server-side rendering

• Use web workers for heavy computations

• Use caching for frequently accessed data

Performing web application penetration testing on a website with firewall enabled.

• Identify the type of firewall and its configuration

• Perform reconnaissance to gather information about the target

• Identify vulnerabilities and exploit them

• Use tools like Burp Suite, Nmap, and Metasploit

• Test for common web application vulnerabilities like SQL injection and cross-site scripting

• Document findings and provide recommendations for

Steps for Azure migration from onprem to cloud and Hyper V migration using VMWARE tool.

• Assess on-premises environment

• Choose appropriate migration method

• Prepare Azure environment

• Migrate data and applications

• Optimize and secure migrated resources

• VMware tool used for migration: VMware vCenter Converter

• Hyper-V migration can be done using Azure Site Recovery

Memory management is crucial for efficient application performance.

• Memory allocation and deallocation should be done carefully to avoid memory leaks.

• Unused memory should be released to prevent memory fragmentation.

• Memory profiling tools can help identify memory-related issues.

• Caching can improve performance by reducing the need for frequent memory allocation.

• Examples: Java's garbage collector, C++'s smart pointers, iOS