40+ CELIK IS LLC Interview Questions and Answers

Severity is the impact of a bug on the system while priority is the urgency of fixing it.

• Severity is the measure of how much a bug affects the system's functionality or performance.

• Priority is the measure of how urgently a bug needs to be fixed.

• A high severity bug may not have a high priority if it does not affect critical functionality.

• A low severity bug may have a high priority if it affects critical functionality.

• Both severity and priority are used to prioritize bug fixes....read more

Yes, I have experience implementing server driven UIs.

• Implemented server driven UIs using JSON responses to dynamically update UI elements

• Worked with frameworks like React and Angular to handle server driven UI updates

• Used server driven UIs to efficiently manage and display large amounts of data

Core Data is a framework provided by Apple for managing the model layer objects in an iOS application.

• Core Data is used for storing, retrieving, and managing data in an iOS app.

• It provides an object-oriented interface to work with data.

• Operations include creating, reading, updating, and deleting data.

• Example: Creating a new record in Core Data for a user profile.

• Example: Fetching a list of items from Core Data to display in a table view.

Challenges faced during testing phase

• Lack of clear requirements

• Limited access to test environment

• Time constraints

• Difficulty in reproducing bugs

• Integration issues with third-party systems

• Lack of proper documentation

• Testing on multiple platforms and devices

• Dealing with unexpected errors

Testing Life Cycle includes planning, designing, executing and reporting. Bug Life Cycle includes reporting, assigning, fixing and verifying.

• Testing Life Cycle involves planning, designing, executing and reporting of tests.

• Bug Life Cycle involves reporting, assigning, fixing and verifying bugs.

• Testing Life Cycle starts with requirement analysis and ends with test closure.

• Bug Life Cycle starts with bug reporting and ends with bug closure.

• Testing Life Cycle ensures that the sof...read more

Count the occurrence of each word in a sentence using Java code.

• Split the sentence into an array of words using split() method.

• Create a HashMap to store each word and its count.

• Iterate through the array and update the count in the HashMap.

• Print the word and its count at the end.

Recruitment life cycle involves the process of identifying, attracting, evaluating, and hiring qualified candidates for a job.

• Identifying job vacancies and determining the requirements

• Sourcing candidates through various channels like job portals, social media, and referrals

• Screening and shortlisting candidates based on their qualifications and experience

• Conducting interviews and assessments to evaluate candidates' skills and suitability

• Selecting the most suitable candidate an...read more

External libraries are pre-written code that can be imported and used in a project to provide additional functionality.

• External libraries help in reducing development time by providing ready-made solutions for common tasks.

• Examples include React for front-end development, NumPy for scientific computing in Python, and Retrofit for making network calls in Android apps.

Closure is a function that captures variables from its surrounding scope, allowing it to access those variables even after the scope has closed.

• Closure allows a function to access variables from its lexical scope even after the function has finished executing.

• Types of closures include lexical closures, which capture variables from the surrounding lexical scope, and function closures, which capture variables from the function's scope.

• Example: function outerFunction() { let out...read more

I handle requirements sessions with clients by preparing thoroughly, actively listening, and asking clarifying questions.

• Prepare an agenda and share it with the client beforehand

• Actively listen to the client's needs and concerns

• Ask clarifying questions to ensure understanding

• Take detailed notes and confirm accuracy with the client

• Follow up with the client to ensure all requirements are met

The density of bentonite after flushing of pile bore depends on various factors such as the type of bentonite used, the amount of water used for flushing, and the duration of flushing.

• The density of bentonite is typically measured in pounds per gallon (ppg) or kilograms per cubic meter (kg/m³).

• The density of bentonite after flushing can range from 8.5 to 16 ppg or 1,020 to 1,920 kg/m³ depending on the factors mentioned above.

• The density of bentonite is important for determini...read more

It is impossible to determine how many electrical engineers take a job in 1 day.

• The number of electrical engineers taking a job in a day varies depending on various factors such as job availability, location, and demand.

• It is not possible to accurately predict the number of electrical engineers taking a job in a day without specific data.

• Factors such as the economy, industry trends, and job market conditions can also affect the number of electrical engineers taking a job in a...read more

I communicate with customers through email by ensuring clear and concise messaging, addressing their concerns promptly, and providing personalized responses.

• Use a professional tone and language

• Address the customer by their name if possible

• Provide detailed information and solutions to their inquiries

• Include a call to action for next steps or follow-up

• Ensure timely responses to maintain customer satisfaction

I can draft emails quickly and efficiently, typically within a few minutes.

• I have strong typing skills and can type quickly without errors

• I am familiar with email templates and can customize them quickly for each customer

• I prioritize clear and concise communication in my emails to ensure efficiency

• I am experienced in handling high volume of emails and responding promptly

SCCM (System Center Configuration Manager) is a software management suite developed by Microsoft for managing large groups of computers running Windows OS.

• SCCM allows for remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory.

• It helps organizations to manage their IT infrastructure more efficiently and securely.

• SCCM integrates with Active Directory to provide comprehensive management...read more

Active Directory is a directory service developed by Microsoft for Windows domain networks.

• Centralized database for managing network resources

• Stores information about users, computers, groups, and more

• Allows for authentication and authorization of users and computers

• Enables administrators to manage and secure network resources

• Supports features like Group Policy, LDAP, and Kerberos authentication

Dynamic memory allocation is the process of allocating memory during program execution.

• Allows programs to request memory at runtime

• Helps in efficient memory management

• Commonly used in languages like C and C++

• Example: using malloc() function in C to allocate memory for an array

Collabera is a global staffing and IT services company.

• Global staffing and IT services company

• Founded in 1991

• Headquartered in Basking Ridge, New Jersey

• Provides services in areas like IT consulting, staffing, and managed services

I learned about Collabera through online job search platforms and networking events.

• Online job search platforms like Indeed or Glassdoor

• Networking events or career fairs

• Referrals from friends or colleagues

BAPI stands for Business Application Programming Interface. All BAPIs are RFCs.

• BAPIs are standard interfaces provided by SAP to access business processes and data.

• They are used to integrate SAP with other systems.

• BAPIs are RFC-enabled function modules.

• They are used to create, read, update, and delete data in SAP.

• Examples of BAPIs include BAPI_MATERIAL_GET_DETAIL, BAPI_SALESORDER_CREATEFROMDAT2, etc.

OOPS concepts of Java include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation: bundling data and methods within a class

• Inheritance: creating new classes from existing ones

• Polymorphism: using a single interface to represent multiple classes

• Abstraction: hiding implementation details and showing only necessary information

Developed a solution to automate manual data entry process

• Identified the repetitive nature of the task

• Researched and evaluated available automation tools

• Developed a custom Python script to automate the process

• Tested and refined the script to ensure accuracy and efficiency

Enums are a feature in programming languages that allow you to define a set of named constants.

• Enums can be used to improve code readability by giving meaningful names to values

• Enums can be used in switch statements to handle different cases

• Enums can have associated values or raw values for more flexibility

RFC is a remote function call protocol used to communicate between SAP systems. Not all RFCs are BAPIs.

• RFC stands for Remote Function Call and is a protocol used to enable communication between SAP systems.

• BAPI stands for Business Application Programming Interface and is a set of standard interfaces provided by SAP for accessing its business objects.

• Not all RFCs are BAPIs, but all BAPIs are RFCs.

• RFCs can be used to call functions remotely, while BAPIs are used to access SAP b...read more

Basic CSS properties include color, font-size, margin, padding, and display.

• color

• font-size

• margin

• padding

• display

Binary search is a divide and conquer algorithm that efficiently finds the target value within a sorted array.

• Start by defining the low and high indices of the array.

• Calculate the middle index and compare the target value with the middle element.

• If the target value is less than the middle element, search the left subarray. If greater, search the right subarray.

• Repeat the process until the target value is found or the subarray is empty.

Yes, Singleton handles synchronization by ensuring only one instance of a class is created and providing global access to that instance.

• Singleton pattern restricts the instantiation of a class to one object.

• It provides a global point of access to the instance.

• Synchronization can be implemented in the Singleton pattern to ensure thread safety.

• Example: Singleton pattern is commonly used in database connections to ensure only one connection is created and shared.

CI/CD flow stands for Continuous Integration/Continuous Deployment flow, which is a software development practice where code changes are automatically built, tested, and deployed.

• CI/CD flow involves automating the process of integrating code changes into a shared repository, running automated tests, and deploying the changes to production.

• Continuous Integration (CI) focuses on automating the build and testing of code changes, typically triggered by a code commit to the reposi...read more

Java is a high-level programming language known for its platform independence and object-oriented approach.

• Java is widely used for developing desktop, web, and mobile applications.

• It follows the 'write once, run anywhere' principle, allowing code to be executed on any platform with a Java Virtual Machine (JVM).

• Java supports multithreading, exception handling, and automatic memory management.

• It has a vast standard library and a large community of developers.

• Example: Java is us...read more

Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• It helps in reducing data redundancy and inconsistencies.

• Views are virtual tables that are created based on the result of a query. They can be used to simplify complex queries.

• Stored procedures are precompiled SQL statements that can be executed multiple times. They ...read more

DHCP assigns IP addresses to devices, while DNS resolves domain names to IP addresses.

• DHCP stands for Dynamic Host Configuration Protocol

• DHCP server assigns IP addresses to devices on a network

• DNS stands for Domain Name System

• DNS resolves domain names to IP addresses

• DNS server maintains a database of domain names and their corresponding IP addresses

I have two offers in hand.

• One offer is from a software development company and the other is from a financial services firm.

• Both offers are for Technical Business Analyst roles.

• The software development company is offering a higher salary but the financial services firm has better benefits.

• I am still evaluating both offers and have not made a decision yet.

Collabera is a global staffing and IT services company.

• Provides staffing and IT services to clients worldwide

• Offers solutions in areas like digital, cloud, cybersecurity, and analytics

• Has a presence in multiple countries including the US, India, and the UK

I rate my convincing skills as 8 out of 10.

• I have experience in persuading candidates to accept job offers.

• I have successfully convinced clients to adopt new technologies.

• I use data and facts to support my arguments.

• I am confident and articulate in presenting my ideas.

• I am always willing to listen to the other person's perspective.

Various tools are used for requirements gathering and management.

• Interviews with stakeholders

• Surveys and questionnaires

• Prototyping and wireframing

• Use case diagrams and flowcharts

• User stories and acceptance criteria

• Requirements management software (e.g. JIRA, Trello)

GDG stands for Generation Data Group in JCL, used to manage related datasets as a single unit.

• GDG is used in JCL to group related datasets together for easier management.

• It allows for easy referencing of datasets within the group using relative generation numbers.

• Example: MYDATA.GDG(+1) refers to the most recent generation in the GDG.

• Example: MYDATA.GDG(-1) refers to the previous generation in the GDG.

Pile foundation methods include driven piles, drilled piles, and screw piles.

• Driven piles are installed by hammering the pile into the ground using a pile driver.

• Drilled piles are created by drilling a hole into the ground and filling it with concrete and reinforcing steel.

• Screw piles are installed by rotating a helical screw into the ground.

• Other methods include jacked piles, vibratory piles, and auger cast piles.

• The choice of method depends on factors such as soil condition...read more

An IP address is a unique numerical label assigned to each device connected to a computer network.

• IP addresses are used to identify and locate devices on a network.

• There are two types of IP addresses - IPv4 and IPv6.

• IPv4 addresses are written in the form of four sets of numbers separated by periods (e.g. 192.168.1.1).

• IPv6 addresses are written in a hexadecimal format and are longer than IPv4 addresses.

• IP addresses can be static (manually assigned) or dynamic (assigned by a DH...read more

The depth and diameter of a pile depend on the load it needs to support and the soil conditions.

• The depth of a pile is determined by the depth of the soil layer that can support the load.

• The diameter of a pile is determined by the load it needs to support and the soil conditions.

• The type of pile also affects its diameter and depth.

• For example, a driven pile may have a smaller diameter but greater depth than a bored pile.

• The design of the foundation and the structure it suppor...read more

A stored procedure is a pre-written SQL code that can be saved and reused multiple times.

• Stored procedures improve performance by reducing network traffic and improving security.

• They can be used to perform complex operations and automate tasks.

• Stored procedures can be called from other programs or scripts.

• They can also be used to enforce business rules and data integrity.

• Examples include procedures for inserting, updating, and deleting data.

• Stored procedures can also be used ...read more

There are four divisions in COBOL: Identification Division, Environment Division, Data Division, and Procedure Division.

• Identification Division: Contains program name, author, and date.

• Environment Division: Specifies the hardware and software environment.

• Data Division: Defines the data structures used in the program.

• Procedure Division: Contains the actual program logic.

Generics are a way to create reusable code that can work with different data types.

• Generics allow for type safety and reduce code duplication.

• They are used in collections such as List and Dictionary.

• Generics can also be used in methods and classes.

• Example: List names = new List();

• Example: Dictionary employees = new Dictionary();

Primary key is a unique identifier for a record in a database table.

• Primary key ensures data integrity and helps in faster data retrieval.

• It cannot have null values and must be unique for each record.

• Examples of primary keys are social security number, email address, etc.

Reverse a given string using built-in functions or loops.

• Use the built-in reverse() function in Python or JavaScript.

• Loop through the string and append each character to a new string in reverse order.

• Convert the string to an array, use the reverse() function, and then join the array back into a string.

Data cleaning is the process of identifying and correcting errors or inconsistencies in data to improve its quality.

• Removing duplicate entries

• Correcting spelling errors

• Handling missing values

• Standardizing data formats

• Identifying and removing outliers