Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Icertis Team. If you also belong to the team, you can get access from here

Icertis Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Icertis Senior Functional Consultant Interview Questions and Answers

Updated 19 Nov 2024

Icertis Senior Functional Consultant Interview Experiences

7 interviews found

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
-
Result
No response

I appeared for an interview in Jan 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL basic queries to call for two rows from a table.
  • Ans. 

    Retrieve two rows from a SQL table using SELECT and LIMIT clauses.

    • Use the SELECT statement to specify the columns you want to retrieve.

    • Use the FROM clause to indicate the table from which to select data.

    • Use the LIMIT clause to restrict the number of rows returned.

    • Example: SELECT * FROM tableName LIMIT 2;

    • You can also use WHERE to filter results before limiting.

  • Answered by AI
  • Q2. Select firstname, lastname FROM users;
  • Ans. 

    The query selects the first name and last name of users from a database.

    • Use SELECT statement to retrieve specific columns from a table

    • Specify the columns to be selected after the SELECT keyword

    • Table name should be specified before the FROM keyword

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Basic questions, like introduce yourself, how do you communicate with the team etc
  • Q2. Answer is simple

Interview Preparation Tips

Interview preparation tips for other job seekers - Try your luck only of you have to keep this as an option.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How much do you know about contract lifecycle management
  • Ans. 

    Contract lifecycle management involves managing contracts from creation to execution to renewal or termination.

    • Involves managing contracts from creation to execution to renewal or termination

    • Includes drafting, negotiation, approval, and monitoring of contracts

    • Ensures compliance with terms and conditions, tracking key dates and milestones

    • Utilizes software solutions for efficient contract management

    • Improves visibility, r...

  • Answered by AI
  • Q2. What do you know about Icertis
  • Ans. 

    Icertis is a leading provider of contract lifecycle management (CLM) software solutions.

    • Icertis offers a cloud-based platform for managing contracts and related processes.

    • Their software helps organizations streamline contract management, improve compliance, and reduce risk.

    • Icertis has a global customer base across various industries, including healthcare, manufacturing, and technology.

    • The company was founded in 2009 an...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What do you know about contracting, esignature
  • Ans. 

    Contracting and esignature involve legally binding agreements and electronic signatures.

    • Contracting refers to the process of creating and agreeing upon a legally binding agreement between two or more parties.

    • Esignature, or electronic signature, is a digital form of signature that can be used to sign documents electronically.

    • Esignature technology allows for the signing of contracts and other documents online, making the...

  • Answered by AI
  • Q2. What do you know about UAT and change request
  • Ans. 

    UAT stands for User Acceptance Testing, where end users validate the system meets their requirements. Change request is a formal proposal to alter a system.

    • UAT is the final phase of testing before the system is released to end users

    • End users are responsible for executing test cases and providing feedback during UAT

    • Change request is a formal document submitted to request changes to a system

    • Change requests can include mo...

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
No response

I applied via Referral

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Implementation related question
Round 3 - Technical 

(1 Question)

  • Q1. Sql related questions
Round 4 - HR 

(1 Question)

  • Q1. Role related queries and compensation discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi All,
My suggestion is not to join this firm. I had a very bad and disappointing experience where even after being offered, the company kept me hanging and HR irresponsiveness left me with such a unprofessional experience.
I was being referred by my ex colleague and I was able clear both my technical rounds. It took 6 months in the process and HR to come back with a reply that position has been put on hold or dropped.
I was interviewed for 1st round on 16th September' 22 and I cleared it. My second round held on 21st September '22 and I cleared that too. Now my last round was with HR and I kept asking for the availability. The team responded to me after a month on 27th October '22 and it took another week for HR to get my documents on 08th November '22.
After almost a month I checked back with the team on 21st November '22 regarding the final compensation and I got the final compensation letter on 30th November' 22.
After that I have done dozens of email and followups to check with team finalize terms but no one came back to me I even tried calling HR and it seems like a scam happened to me almost. In Feb, on 14 Feb'23 finally I got an email from HR stating that the position of Program Manager, wait a sec....I haven't even applied for this position. I applied for the position of Sr. Func. Consultant.
So much time and effort and all those hope of clearing an interview and joining a new firm was shattered with just an email after 6 months.
Surely, she didn't even know for which position I applied for
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jan 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. SQL, PLSQL basic to advanced interview questions data types,
  • Q2. Procedures, what is mutating trigger, cursors etc
  • Ans. 

    Mutating triggers and cursors are database concepts used in procedures to perform specific actions.

    • Mutating triggers are triggers in Oracle databases that are fired when a row is updated, causing the trigger to see the data as both the original and updated values.

    • Cursors are database objects used to retrieve and manipulate data in a set row by row.

    • Procedures are stored blocks of code that can be executed on demand in a...

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. Company related questions, SLA, incident management system etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Second round was totally unexpected and highly demanding, they wanted all the knowledge in single person. The person was rude and expectations were too high from a 2.6 years experienced.
PS: The profile was for 4+ years still they shortlisted me.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Current Work, Location Details, Why do you want to change the job?
  • Ans. 

    Currently working as a Functional Consultant in XYZ company in New York. Looking for new challenges and growth opportunities.

    • Currently working as a Functional Consultant in XYZ company

    • Located in New York

    • Seeking new challenges and growth opportunities

  • Answered by AI
  • Q2. Salary Expectations

I applied via Naukri.com and was interviewed in Nov 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Based on your profile, questioning would be
  • Q2. Implemenation, data migration, communication. This would suffice

Interview Preparation Tips

Interview preparation tips for other job seekers - Lot of work pressure and no personal and family time. If ready to sacrifice, pls come and join. You would be loaded with work like anything.

Top trending discussions

View All
Office Jokes
2w
an executive
CTC ≠ Confidence Transfer Credit
Ab toh aisa lagta hai, chillar jaise salary ke liye main kaju katli ban ke jaa rahi hoon. Samajh nahi aata, main zyada ready ho ke jaa rahi hoon ya ye mujhe kam pay kar rahe hain? #CorporateLife #OfficeJokes #UnderpaidButWellDressed
FeedCard Image
Got a question about Icertis?
Ask anonymously on communities.

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Amadeus user image Varun Thopucherla

posted on 11 Mar 2015

Interview Questionnaire 

10 Questions

  • Q1. Tell about yourself?
  • Ans. 

    I am a software engineer with experience in developing web applications and mobile apps.

    • Proficient in programming languages such as Java, Python, and JavaScript

    • Experience in developing RESTful APIs and integrating third-party APIs

    • Familiarity with front-end frameworks such as React and Angular

    • Strong understanding of database management systems such as MySQL and MongoDB

    • Passionate about learning new technologies and keepi...

  • Answered by AI
  • Q2. Why Software industry? why not core?
  • Ans. 

    Software industry offers endless opportunities for innovation and growth.

    • Software industry is constantly evolving and offers opportunities to work on cutting-edge technologies.

    • It provides a platform to solve complex problems and create innovative solutions.

    • The demand for software engineers is high and the industry offers competitive salaries.

    • Core industries may have limited scope for growth and innovation compared to s...

  • Answered by AI
  • Q3. Write a program to print the given string in reverse
  • Ans. 

    Program to print a given string in reverse

    • Create a character array of the given string

    • Loop through the array from end to start and print each character

  • Answered by AI
  • Q4. Some questions about computer networks and Digital electronics
  • Q5. What is Mux? what are its real life applications?
  • Ans. 

    Mux is a device that selects one of several input signals and forwards the selected input into a single output line.

    • Mux stands for Multiplexer.

    • It is used in digital circuits to select one of several input signals and forward the selected input into a single output line.

    • It is used in communication systems to combine multiple signals into a single channel for transmission.

    • It is used in video and audio systems to switch b...

  • Answered by AI
  • Q6. What is DeMux? what are its real life applications?
  • Ans. 

    DeMux is short for Demultiplexer. It is a digital circuit that takes one input and directs it to multiple outputs.

    • DeMux is used in digital communication systems to separate signals that have been combined for transmission.

    • It is also used in computer memory systems to select a specific memory location.

    • DeMux is used in video and audio systems to separate different channels of information.

    • It is used in automation systems ...

  • Answered by AI
  • Q7. Difference between decoder and Demux
  • Ans. 

    Decoder converts encoded data into a readable format while Demux separates a single input into multiple outputs.

    • Decoder is used to decode encoded data such as binary data into a readable format.

    • Demux is used to separate a single input into multiple outputs based on the control signals.

    • Decoder is a combinational circuit while Demux is a sequential circuit.

    • Decoder is used in applications such as remote controls, computer...

  • Answered by AI
  • Q8. Why amadeus labs?
  • Ans. 

    Amadeus Labs is a leading technology company in the travel industry.

    • Amadeus Labs provides opportunities to work on cutting-edge technologies.

    • The company has a strong focus on innovation and research.

    • Amadeus Labs has a global presence and offers a diverse and inclusive work environment.

    • Working at Amadeus Labs provides the opportunity to make a real impact on the travel industry.

    • The company values work-life balance and o...

  • Answered by AI
  • Q9. Are you comfortable in working for Testing?
  • Ans. 

    Yes, I am comfortable working for Testing.

    • I have experience in testing and understand its importance in software development.

    • I am willing to learn new testing techniques and tools.

    • I am comfortable working with testing teams and collaborating with them to ensure quality software.

    • I understand the importance of testing in ensuring customer satisfaction and reducing costs.

    • Examples: I have experience in manual and automated...

  • Answered by AI
  • Q10. Why do you consider yourself suitable for developer role?
  • Ans. 

    I have the necessary skills and experience to excel in the developer role.

    • I have a degree in computer science and have completed multiple coding projects.

    • I am proficient in programming languages such as Java, Python, and C++.

    • I have experience working with databases and web development frameworks.

    • I am a quick learner and enjoy solving complex problems.

    • I am a team player and have collaborated with other developers on var...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test was conducted online. All the questions were of medium standard and easy to crack if we have patience for thinking.

English comprehension level is slightly below the standard of CAT. Those who have the habit of reading English news paper can easily crack the test.

Data analysis questions were also of medium standard. Those who have knowledge about graphs, bar & pie charts can easily crack the exam.
Tips: Practice Aptitude questions from R S Agarwaal book and CAT material.

Round: Technical Interview
Experience: Over all interview experience is cool. Interviewers never grilled on anything. In many cases they have helped me to arrive at answers.
Tips: Read C++ and Oops concepts from E Balaguruswamy text book.
For Data structures and algorithms read 'Data structures' by Yeshwant kanethkar.
Minimum knowledge about all the courses of your department will be an added advantage. This will help you to depict you are sincere in your studies and don't have any personal constraints in learning a new thing.

General Tips: Just be confident and believe in yourself. You will get through.
Skills: Programming skill in C++
College Name: NIT Warangal
Motivation: No special motivation. It is a rapidly growing company offering good package.

Skills evaluated in this interview

Interview Questionnaire 

21 Questions

  • Q1. AVL tree balance checking
  • Ans. 

    AVL tree balance checking ensures that the tree maintains its height-balanced property after insertions and deletions.

    • An AVL tree is a self-balancing binary search tree.

    • The balance factor (BF) of a node is defined as the height of the left subtree minus the height of the right subtree.

    • A node is considered balanced if its BF is -1, 0, or +1.

    • To check balance, recursively calculate the height of left and right subtrees fo...

  • Answered by AI
  • Q2. Median of 2 sorted arrays in O(log N) time complexity and O(1) space complexity
  • Ans. 

    Find median of 2 sorted arrays in O(log N) time complexity and O(1) space complexity

    • Use binary search to find the partition point in both arrays

    • Calculate the median based on the partition point and array sizes

    • Adjust the partition points based on the median value

    • Repeat until the partition points are at the median

    • Handle edge cases such as empty arrays and uneven array sizes

  • Answered by AI
  • Q3. Strings Anagram in O(1) space complexity
  • Ans. 

    Anagram of strings in O(1) space complexity

    • Use a fixed size array of integers to store the frequency of characters in the first string

    • Iterate through the second string and decrement the frequency of each character in the array

    • If all the frequencies are zero, then the strings are anagrams

    • Return true or false accordingly

  • Answered by AI
  • Q4. Level order traversal of a tree using Queue
  • Ans. 

    Level order traversal of a tree using Queue

    • Create a queue and add the root node to it

    • While the queue is not empty, remove the front node and print its value

    • Add the left and right child nodes of the removed node to the queue

    • Repeat until the queue is empty

  • Answered by AI
  • Q5. Reverse level order traversal of a tree using Queue
  • Ans. 

    Reverse level order traversal of a tree using Queue

    • Create a queue and push the root node into it

    • While the queue is not empty, pop the front node and push its children into the queue

    • Add the popped node to a stack

    • Once the queue is empty, pop elements from the stack and print them

  • Answered by AI
  • Q6. BFS and DFS Difference
  • Ans. 

    BFS and DFS are graph traversal algorithms. BFS explores nodes level by level while DFS explores nodes depth by depth.

    • BFS uses a queue while DFS uses a stack or recursion.

    • BFS is optimal for finding shortest path while DFS is optimal for finding a path between two nodes.

    • BFS requires more memory as it stores all the nodes at each level while DFS requires less memory.

    • BFS can be used to find connected components while DFS ...

  • Answered by AI
  • Q7. OS Concepts – Starvation, Demand Paging, Virtual Memory, Deadlocks
  • Q8. Parenthesis Balance Checking
  • Ans. 

    Check if parentheses in a string are balanced using a stack-based approach.

    • Use a stack to track opening parentheses: '(', '{', '['.

    • For each closing parenthesis: check if it matches the top of the stack.

    • If the stack is empty at the end, parentheses are balanced.

    • Example: '((){})' is balanced, but '((())' is not.

  • Answered by AI
  • Q9. Three Jars - 1 with apples, 1 with oranges, 1 with apples and oranges. All of them wrongly labelled. Find min no of attempts to find the correct nature of boxes
  • Q10. Find product of each element of an array except that element in O(N) time complexity without using / operation
  • Ans. 

    Find product of each element of an array except that element in O(N) time complexity without using / operation

    • Use prefix and suffix products

    • Multiply prefix and suffix products for each element to get the final product

    • Handle edge cases where array has 0 or 1 element separately

  • Answered by AI
  • Q11. Recursively deleting linked list
  • Ans. 

    Recursively delete a linked list

    • Create a recursive function that takes the head of the linked list as input

    • Base case: if the head is null, return

    • Recursively call the function with the next node as input

    • Delete the current node

  • Answered by AI
  • Q12. Recursively deleting linked list from end
  • Ans. 

    Recursively delete a linked list from the end.

    • Start from the head and recursively traverse to the end of the list.

    • Delete the last node and set the second last node's next pointer to null.

    • Repeat until the entire list is deleted.

    • Use a recursive function to implement the deletion process.

  • Answered by AI
  • Q13. Recursively deleting tree
  • Ans. 

    Recursively delete a tree by deleting all its child nodes and then the parent node.

    • Start from the leaf nodes and delete them first.

    • Then move up to the parent nodes and delete them.

    • Repeat until the root node is deleted.

    • Use post-order traversal to ensure child nodes are deleted before parent nodes.

  • Answered by AI
  • Q14. Recursively deleting from end
  • Ans. 

    Recursively delete elements from the end of an array.

    • Create a recursive function that removes the last element of the array.

    • Call the function recursively until the desired number of elements are removed.

    • Handle edge cases such as empty arrays and removing more elements than the array contains.

  • Answered by AI
  • Q15. Difference between Floyd Warshall and Djikstra
  • Ans. 

    Floyd Warshall finds shortest path between all pairs of vertices while Djikstra finds shortest path from a single source.

    • Floyd Warshall is used for dense graphs while Djikstra is used for sparse graphs.

    • Floyd Warshall has a time complexity of O(n^3) while Djikstra has a time complexity of O((n+m)logn).

    • Floyd Warshall can handle negative edge weights while Djikstra cannot.

    • Floyd Warshall can detect negative cycles while Dj...

  • Answered by AI
  • Q16. Shortest path between 2 points in 2-D space in O(log N) time
  • Ans. 

    There is no known algorithm to find shortest path in 2-D space in O(log N) time.

    • The best known algorithm for finding shortest path in 2-D space is Dijkstra's algorithm which has a time complexity of O(N^2).

    • Other algorithms like A* and Bellman-Ford have better time complexity but still not O(log N).

    • If the points are on a grid, Lee algorithm can be used which has a time complexity of O(N).

  • Answered by AI
  • Q17. Design a system for putting newspapers using classes and functions taking different aspects into account
  • Ans. 

    Design a system for putting newspapers using classes and functions

    • Create a Newspaper class with attributes like title, date, and content

    • Create a Publisher class with methods to publish and distribute newspapers

    • Create a Subscriber class with methods to subscribe and receive newspapers

    • Use inheritance to create different types of newspapers like daily, weekly, etc.

    • Implement a database to store newspaper information and ha...

  • Answered by AI
  • Q18. SQL commands
  • Q19. Career Prospects - Long Term Plans
  • Q20. Why not higher studies?
  • Ans. 

    I believe practical experience is more valuable than higher studies.

    • I have gained valuable experience through internships and projects.

    • I prefer hands-on learning and problem-solving over theoretical knowledge.

    • I am constantly learning and improving my skills through online courses and workshops.

  • Answered by AI
  • Q21. Machine Learning Concepts - Based on my projects

Interview Preparation Tips

Round: Test
Experience: All Computer Science Topics Covered: Data Structures, Algorithms, Object Oriented Systems, C, C++, Operating Systems, Computer Architectures, Databases, SQL, Basic Quantitative Aptitude
Tips: Solve all of them. Cut off's generally go high.
Duration: 30 minutes
Total Questions: 30

Round: Interview
Experience: Nice Experience. Interviewer was friendly. He wanted exact solutions.
Tips: Be thorough with everything and your projects.

Round: Interview
Experience: Nice Experience. Interviewer was friendly. He wanted exact solutions.
Tips: Be thorough with everything and your projects.

Round: Interview
Experience: Nice Experience. Interviewer was friendly.
Tips: Do not fake yourself.

General Tips: Be thorough with all CS related concepts and projects.
Skill Tips: ""Be thorough.""
Skills: Algorithms, Data Structures, Operating Systems, Machine Learning, SQL, Operating Systems, Computer Architecture, Data Analytics
College Name: IIT Kharagpur
Motivation: Kind of application oriented work and the rising nature of the company. Obviously money also.
Funny Moments: Many funny questions and answers like did you have lunch, when did you last eat, etc

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basic oop
  • Q2. Previous projects and walktrough of one of the project, if any
  • Q3. Basic English test on a computer

Interview Preparation Tips

Interview preparation tips for other job seekers - The first step of the interview is the basic communication skills, which is taken on computer, try to listen carefully, most of the questions are only about what you have comprehend from the automated voice when played over.

OOP is very basic, they may ask some real life examples.

If you have worked previously, they may ask you about one of your projects. What technologies have you used ans why.

Icertis Interview FAQs

How many rounds are there in Icertis Senior Functional Consultant interview?
Icertis interview process usually has 1-2 rounds. The most common rounds in the Icertis interview process are Technical, HR and One-on-one Round.
How to prepare for Icertis Senior Functional Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Icertis. The most common topics and skills that interviewers at Icertis expect are Contract Management, SQL, Application Support, Cloud Computing and CRM.
What are the top questions asked in Icertis Senior Functional Consultant interview?

Some of the top questions asked at the Icertis Senior Functional Consultant interview -

  1. How much do you know about contract lifecycle managem...read more
  2. SQL basic queries to call for two rows from a tab...read more
  3. Procedures, what is mutating trigger, cursors ...read more

Tell us how to improve this page.

Overall Interview Experience Rating

2.9/5

based on 7 interview experiences

Difficulty level

Easy 20%
Moderate 60%
Hard 20%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

Chetu Interview Questions
3.3
 • 197 Interviews
AVASOFT Interview Questions
2.9
 • 174 Interviews
Oracle Cerner Interview Questions
3.7
 • 161 Interviews
Thomson Reuters Interview Questions
4.1
 • 124 Interviews
ServiceNow Interview Questions
4.1
 • 124 Interviews
Amadeus Interview Questions
3.8
 • 115 Interviews
UKG Interview Questions
3.1
 • 111 Interviews
EbixCash Limited Interview Questions
3.9
 • 106 Interviews
SPRINKLR Interview Questions
3.0
 • 105 Interviews
View all
Icertis Senior Functional Consultant Salary
based on 261 salaries
₹9 L/yr - ₹24 L/yr
9% more than the average Senior Functional Consultant Salary in India
View more details

Icertis Senior Functional Consultant Reviews and Ratings

based on 29 reviews

3.4/5

Rating in categories

3.2

Skill development

3.1

Work-life balance

3.1

Salary

3.2

Job security

3.1

Company culture

2.9

Promotions

3.1

Work satisfaction

Explore 29 Reviews and Ratings
Functional Consultant
301 salaries
unlock blur

₹4.9 L/yr - ₹15 L/yr

Senior Functional Consultant
261 salaries
unlock blur

₹13 L/yr - ₹21.7 L/yr

Senior Software Engineer
255 salaries
unlock blur

₹8.2 L/yr - ₹28 L/yr

Software Engineer
240 salaries
unlock blur

₹5.3 L/yr - ₹13.5 L/yr

Lead Software Engineer
176 salaries
unlock blur

₹14 L/yr - ₹32 L/yr

Explore more salaries
Compare Icertis with

Apttus

4.3
Compare

Thomson Reuters

4.1
Compare

Oracle Cerner

3.6
Compare

Chetu

3.3
Compare
write
Share an Interview