Camden Town Technologies Interview Questions and Answers

Asking about the excel and other data tool. Salary offer as per their terms no negotiate.

Q1. Salary offer as per their terms.
Add your answer
Q2. Tell me some thing about your self.
Add your answer
Q3. What is expertise why want to leave
Add your answer

Q1. How well do you know python
Ans. 
I have a strong understanding of Python and have used it extensively in various projects.
• Proficient in Python syntax and data structures

• Experience with popular libraries like NumPy, Pandas, and Matplotlib

• Developed web applications using Django framework

• Used Python for automation and scripting tasks
Answered by AI
Add your answer

Q1. Questions based on MS Excel only and provide 1 assignment for data analysis.
Add your answer

Q1. Again easy questions on MS Excel like; Vlookup, pivot, summarize, sumif, etc
Add your answer

Q1. What is the difference between secured and unscured loan
Ans. 
Secured loans are backed by collateral, while unsecured loans are not.
• Secured loans require collateral to secure the loan, such as a house or car

• Unsecured loans do not require collateral and are based on the borrower's creditworthiness

• Secured loans typically have lower interest rates due to the lower risk for the lender

• Examples of secured loans include mortgages and auto loans, while credit cards and personal loans are...read more
Answered by AI
Add your answer
Q2. How many types of loans are there.
Ans. 
There are several types of loans including personal loans, home loans, auto loans, student loans, and business loans.
• Personal loans

• Home loans

• Auto loans

• Student loans

• Business loans
Answered by AI
Add your answer

Q1. What are the basic documents required to process a Business loan.
Ans. 
Basic documents for a business loan include financial statements, business plan, credit history, and personal identification.
• Financial statements (income statement, balance sheet, cash flow statement)

• Business plan outlining the purpose of the loan and how it will be used

• Credit history of the business and its owners

• Personal identification documents (such as driver's license or passport)

• Collateral documents (if applicabl...read more
Answered by AI
Add your answer
Q2. What is 15% of 2 lakhs.
Ans. 
15% of 2 lakhs is 30,000.
• Calculate 15% of 2 lakhs by multiplying 2,00,000 by 0.15

• 15% of 2 lakhs = 2,00,000 * 0.15 = 30,000
Answered by AI
Add your answer

Q1. It was one-on-one round with the CTO. They judged me on my technical knowledge as well as understanding of tech-era.
Add your answer
Q2. I was asked question related to the languages and tech-stacks I mentioned in my resume and also question related to OOPs concepts.
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join: ...read more
Answered by AI
Add your answer

Medium level leet code questions

Q1. Low Leven system design of Instagram.
Ans. 
Low level system design of Instagram involves designing the core components like database, storage, caching, and networking.
• Use sharding to distribute data across multiple database servers for scalability.

• Implement a caching layer using Redis or Memcached to improve performance.

• Utilize a content delivery network (CDN) for faster content delivery to users.

• Design a fault-tolerant storage system to ensure data durability ...read more
Answered by AI
Add your answer

Q1. Creating a high level design of a message queue system
Ans. 
Designing a message queue system for efficient communication between components
• Define the requirements and constraints of the system

• Choose a suitable messaging protocol (e.g. AMQP, MQTT)

• Design the message format and structure

• Implement mechanisms for message persistence and delivery guarantees

• Consider scalability and fault tolerance

• Use appropriate data structures and algorithms for efficient message handling
Answered by AI
Add your answer

Q1. What are your goals ?
Ans. 
My goal is to continuously improve my technical skills, contribute to impactful projects, and eventually move into a leadership role.
• Continuously improve technical skills through learning new technologies and best practices

• Contribute to impactful projects by delivering high-quality code and solutions

• Work towards moving into a leadership role by taking on more responsibilities and mentoring junior team members
Answered by AI
Add your answer
Q2. Why you choose jupiter
Ans. 
I chose Jupiter because of its strong gravitational pull and potential for scientific exploration.
• Jupiter's large size and mass make it a key player in shaping the solar system

• Its strong magnetic field and radiation belts provide valuable insights for space research

• Jupiter's moons, like Europa and Io, offer unique environments for potential exploration missions
Answered by AI
Add your answer

Work related assignment they will give

Q1. About technical they will ask more
Add your answer
Q2. Last organisation full details
Add your answer