Tilicho Labs Interview Questions and Answers

Q1. Tell me about yourself, and project architecture. What are your day-to-day responsibilities?
Ans. 
I am a Data Engineer with experience in designing and implementing project architectures. My day-to-day responsibilities include data processing, ETL tasks, and ensuring data quality.
• Designing and implementing project architectures for data processing

• Performing ETL tasks to extract, transform, and load data into the system

• Ensuring data quality and integrity through data validation and cleansing

• Collaborating with cross-...read more
Answered by AI
Add your answer
Q2. SQL: To calculate the difference in marks for each student ID and marks across different years?
Ans. 
Use SQL to calculate the difference in marks for each student ID across different years.
• Use a self join on the table to compare marks for the same student ID across different years.

• Calculate the difference in marks by subtracting the marks from different years.

• Group the results by student ID to get the difference in marks for each student.
Answered by AI
Add your answer
Q3. SQL: Statewise which gender purchase is the most?
Ans. 
The answer to the question is that in which state which gender makes the most purchases.
• Aggregate the data by state and gender to calculate the total purchases made by each gender in each state.

• Identify the gender with the highest total purchases in each state.

• Present the results in a table or chart for easy visualization.
Answered by AI
Add your answer
Q4. What is ADF ??
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF is used for building, scheduling, and monitoring data pipelines to move and transform data from various sources to destinations.

• It supports data integration between various data stores such as Azure SQL Database, Azure Blob Storage, and on-premises data sources.

• ADF provides a visu...read more
Answered by AI
Add your answer
Q5. Pysaprk Coding Question?
Add your answer
Q6. What is DAG ??
Ans. 
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
• DAG is a collection of nodes connected by edges, where each edge has a direction and there are no cycles.

• It is commonly used in data engineering for representing data pipelines and workflows.

• DAGs help in visualizing and optimizing the order of tasks to be executed in a workflow.

• Popular tools like Apache Ai...read more
Answered by AI
Add your answer
Q7. What is Lineage ??
Ans. 
Lineage refers to the history and origin of data, including its source, transformations, and dependencies.
• Lineage helps in understanding how data is generated, processed, and transformed throughout its lifecycle.

• It tracks the flow of data from its source to its destination, including any intermediate steps or transformations.

• Lineage is important for data governance, data quality, and troubleshooting data issues.

• Example...read more
Answered by AI
Add your answer
Q8. How does Spark handle fault tolerance?
Ans. 
Spark handles fault tolerance through resilient distributed datasets (RDDs) and lineage tracking.
• Spark achieves fault tolerance through RDDs, which are immutable distributed collections of objects that can be rebuilt if a partition is lost.

• RDDs track the lineage of transformations applied to the data, allowing lost partitions to be recomputed based on the original data and transformations.

• Spark also replicates data par...read more
Answered by AI
Add your answer
Q9. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
Ans. 
Only one job will run in parallel in Spark with four cores and four worker nodes.
• In Spark, each core can only run one task at a time, so with four cores, only four tasks can run concurrently.

• Since there are four worker nodes, each with four cores, a total of four tasks can run in parallel.

• Therefore, only one job will run in parallel in this scenario.
Answered by AI
Add your answer
Q10. What are the optimisation techniques you have used in your project ?
Ans. 
I have used techniques like indexing, query optimization, and parallel processing in my projects.
• Indexing: Used to improve the speed of data retrieval by creating indexes on columns frequently used in queries.

• Query optimization: Rewriting queries to improve efficiency and reduce execution time.

• Parallel processing: Distributing tasks across multiple processors to speed up data processing.

• Caching: Storing frequently acce...read more
Answered by AI
Add your answer

PEN PAPER round consisting of three coding and c/c++ output based questions.

Q1. OOPS concepts , javascript
Add your answer
Q2. Projects related questions
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Resume , internship related questions
Add your answer

Q1. Software relate
Add your answer
Q2. What is diffrent maya and blender
Ans. 
Maya and Blender are both 3D modeling software, but Maya is more commonly used in professional settings while Blender is open-source and free.
• Maya is more commonly used in professional settings due to its advanced features and industry recognition.

• Blender is open-source and free, making it more accessible to beginners and hobbyists.

• Maya has a steeper learning curve compared to Blender.

• Blender has a more active online c...read more
Answered by AI
Add your answer
Q3. Are you know about unity and unreal engin
Add your answer
Q4. Are you use unity
Ans. 
Yes, I use Unity for creating 3D art and animations.
• I use Unity for creating 3D models, animations, and visual effects.

• Unity provides a user-friendly interface and powerful tools for 3D artists.

• I have experience with Unity's lighting and shading features to enhance the visual quality of my work.
Answered by AI
Add your answer
Q5. Are you using unreal engin ?
Ans. 
Yes, I am using Unreal Engine for my 3D projects.
• I use Unreal Engine for creating realistic environments and characters.

• Unreal Engine offers powerful tools for creating interactive experiences.

• I have experience with Unreal Engine's Blueprint visual scripting system.
Answered by AI
Add your answer
Q6. Tell me about your self
Add your answer

Q1. Asked Scenario based question
Add your answer
Q2. Scenario based question asked
Add your answer

Q1. Total experience
Add your answer
Q2. How will you update client on regular basis?
Ans. 
I will update clients through regular progress reports, meetings, emails, and phone calls.
• Provide regular progress reports detailing project status and milestones

• Schedule regular meetings to discuss project updates and address any concerns

• Send frequent emails with updates on project progress and next steps

• Communicate via phone calls to provide immediate updates or address urgent issues
Answered by AI
Add your answer

Q1. Questions on basic PixiJs stuff and stuff about OOP.
Add your answer
Q2. What is the use of Loader?
Ans. 
Loader is used to load external assets such as images, sounds, and data into a game or application.
• Load images, sounds, and data from external sources into the game or application

• Improve loading times by preloading assets before they are needed

• Handle loading errors and provide feedback to the user

• Examples: loading character sprites, background music, level data
Answered by AI
Add your answer
Q3. What is the use of Interface in TypeScript?
Ans. 
Interfaces in TypeScript are used to define the structure of objects. They provide a way to enforce a certain shape on objects.
• Interfaces allow us to define the structure of an object by specifying the properties and their types.

• Interfaces can be used to enforce a certain shape on objects, ensuring that they have the required properties.

• Interfaces can also be used for type checking and to provide better documentation f...read more
Answered by AI
Add your answer
Q4. What is object pooling?
Ans. 
Object pooling is a design pattern where a set of objects are created and reused instead of creating new instances.
• Improves performance by reducing memory allocation and deallocation overhead

• Objects are kept in a pool and reused when needed

• Commonly used in game development for frequently created and destroyed objects
Answered by AI
Add your answer

Asked about previous projects and given a task to make a simple circle and change its color to a random color on click using pixiJS .

Q1. HR round was basic discussion on my prvs work and what I know about gammastack and stuff.
Add your answer

Question based on dsa

Q1. General questions
Add your answer

Setup a cluster and find the bottleneck of performance.

Q1. Ways to deal with latency in Cassandra
Ans. 
Ways to optimize latency in Cassandra
• Use appropriate data modeling to reduce the number of queries needed

• Optimize queries by using appropriate indexes and clustering keys

• Tune the Cassandra configuration settings for better performance

• Use caching mechanisms like Memcached or Redis to reduce latency

• Consider using partitioning strategies to distribute data evenly across nodes
Answered by AI
Add your answer