Upload Button Icon Add office photos

Filter interviews by

LeanIX Informatica Administrator Interview Questions and Answers

Updated 14 Jan 2022

LeanIX Informatica Administrator Interview Experiences

1 interview found

I applied via Referral and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Research and quality check related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Quality related, qc work flow

Interview questions from similar companies

I appeared for an interview in Apr 2020.

Interview Questionnaire 

4 Questions

  • Q1. Explain the most challenging problem you faced at work
  • Q2. Given the following design - A university has colleges, colleges have departments, departments have students. There are department level elections being held where students nominate themselves to stand fo...
  • Ans. 

    Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.

    • Use a relational database like MySQL or PostgreSQL

    • Create tables for colleges, departments, students, and elections

    • Use foreign keys to establish relationships between tables

    • Add columns for election details like candidate names and vote counts

    • Write a query to join tables and filter for maximum vot

  • Answered by AI
  • Q3. Explain how you would design a bit.ly URL shortening service. What would be the choice of database. What would be your table design what would be the endpoints
  • Ans. 

    Design a bit.ly URL shortening service with database choice, table design, and endpoints.

    • Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.

    • Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.

    • Endpoints should include URL shortening, redirection, and analytics.

    • Implement caching to improve performance and reduce database load...

  • Answered by AI
  • Q4. Coding test - knapsack problem, 2 sum problem, alien language problem. All from leetcode.

Interview Preparation Tips

Interview preparation tips for other job seekers - System Design, Coding practice on leetcode. Popular leetcode problems help improve confidence greatly. If you are just starting off leetcode, start with the most popular easy questions. On day one, don't struggle for more than 30 minutes to solve the question. Look at the answer if no success. with every 10 questions solved looking at the answer, increase the struggle time. Also, studying at the same time everyday helps.
Read or watch system design questions explained on Youtube.

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Coding Test 

Database realted task

Round 3 - Technical 

(1 Question)

  • Q1. Oops concept ,kotlin related question
Round 4 - HR 

(1 Question)

  • Q1. What is your strength and weakness
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).

Round 2 - Technical 

(1 Question)

  • Q1. 1 easy coding and design problem on how would you design a web app like book my show.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Asked about the previous job experience and area of interest like frontend or backend
Round 2 - Coding Test 

Coding test was on reactjs and html

Round 3 - One-on-one 

(1 Question)

  • Q1. Asked about all the react concepts in detail
Round 4 - Technical 

(1 Question)

  • Q1. Javascript basics were asked
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Assignment 

Create a hero section for website

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Online test with basic questions along with c++ question

Round 2 - Group Discussion 

Virtual group discussion

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Assignment 

Desgining of backend services

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Assignment 

There was a data with some 6000 rows and we have to derive 5 useful insights from it

Round 3 - Aptitude Test 

To know yourself like it was a kind of OPQ

Round 4 - Technical 

(1 Question)

  • Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
Round 5 - Technical 

(1 Question)

  • Q1. It was a discussion with CEO of company

Interview Preparation Tips

Interview preparation tips for other job seekers - It is good place to start your career as data analyst. Very good place to work
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. It was basic data analyst non technical quesions
Round 2 - HR 

(1 Question)

  • Q1. Salary Discussion

Tell us how to improve this page.

Research Analyst
11 salaries
unlock blur

₹5.1 L/yr - ₹5.8 L/yr

Senior Research Analyst
5 salaries
unlock blur

₹7 L/yr - ₹9 L/yr

Salesforce Developer
5 salaries
unlock blur

₹6 L/yr - ₹11 L/yr

Software Engineer
4 salaries
unlock blur

₹13.5 L/yr - ₹15 L/yr

Engineering Manager
3 salaries
unlock blur

₹31 L/yr - ₹45 L/yr

Explore more salaries
Compare LeanIX with

GrapplTech

4.8
Compare

Rialtes Technologies

2.0
Compare

Wilco Source

3.6
Compare

TraviYo

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview