Upload Button Icon Add office photos
Engaged Employer

i

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

Cogniscient Business Solutions Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Cogniscient Business Solutions SAP Technical Consultant Interview Questions and Answers

Updated 13 Mar 2024

Cogniscient Business Solutions SAP Technical Consultant Interview Experiences

1 interview found

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

BASIC SQL RELATED QUESTIONS

Round 2 - One-on-one 

(2 Questions)

  • Q1. WHAT ARE VIEWS?
  • Ans. 

    Views are virtual tables that display data from one or more tables in a database.

    • Views do not store data themselves, but instead display data from underlying tables.

    • Views can be used to simplify complex queries by pre-defining joins, filters, and calculations.

    • Views can also restrict access to certain columns or rows of data for security purposes.

  • Answered by AI
  • Q2. What are functions and procedures
  • Ans. 

    Functions and procedures are blocks of code that can be called to perform specific tasks in a program.

    • Functions are reusable blocks of code that can return a value.

    • Procedures are similar to functions but do not return a value.

    • Functions and procedures help in organizing code and making it more modular.

    • Examples: Function to calculate the square of a number, Procedure to print a message.

  • Answered by AI

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in May 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Technical questions related to domain. Oops,SQL,Asp.Net MVC
Round 2 - One-on-one 

(1 Question)

  • Q1. Some technical+managerial round
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jun 2023. There were 4 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 

(1 Question)

  • Q1. Most of questions related project base and Apache Hadoop, Spark fundamental and also indept question in above areas
Round 3 - Group Discussion 

Spark and Hadoop architecture, Linux command , python , pyspark question

Round 4 - HR 

(1 Question)

  • Q1. They were asking related CTC, location etc.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2022. There were 4 interview rounds.

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 - Group Discussion 

They generally ask over a small topic which we come across daily in our day-to-day life. They ask me ....Is 75% in colleges should be mandatory or not..??

Round 3 - Technical 

(1 Question)

  • Q1. They will ask questions only related to your resume.. whatever you have provided to them.
  • Ans. Must know the basic coding of SQL
  • Answered Anonymously
Round 4 - HR 

(1 Question)

  • Q1. They will ask tricky questions..so be prepared. Don't blabber anything infront of them.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be totally honest with the HR.. regarding your previous job.or interview.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 2 interview rounds.

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 - Technical 

(2 Questions)

  • Q1. Basic SQL Questions were asked
  • Q2. Questions were asked on AWS S3, EC2

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall interview process was good. Two rounds were taken followed by HR discussion.
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 

HackerRank Coding Test followed by one to one

Round 3 - One-on-one 

(2 Questions)

  • Q1. Deep Dive into Programming Language questions
  • Q2. System Design related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Get the basics right, hands on coding is a must. It also depends on interviewer what questions they ask
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic Question on C
  • Q2. Linux basics, and domain specific
Round 2 - One-on-one 

(2 Questions)

  • Q1. Linux Internals
  • Q2. Threads and processes
Round 3 - HR 

(1 Question)

  • Q1. Basic details, offer

Interview Preparation Tips

Topics to prepare for Amantya Technologies Technical Lead interview:
  • DSA
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jan 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Coding Test 

Programming mandatory (c cpp java ...)

Round 3 - Technical 

(1 Question)

  • Q1. You should be technically sound as per mentioned in cv.
Round 4 - HR 

(1 Question)

  • Q1. Just a salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Before go for interview, you should be prepared as per mention in resume.

I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL queries, joins, lead lag functions,
  • Q2. Unix scripting, snowflake, cloud technology background, practical experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was more of technical check, mostly bon SQL queries as I was considered as ETL developer.

Cogniscient Business Solutions Interview FAQs

How many rounds are there in Cogniscient Business Solutions SAP Technical Consultant interview?
Cogniscient Business Solutions interview process usually has 2 rounds. The most common rounds in the Cogniscient Business Solutions interview process are Coding Test and One-on-one Round.
What are the top questions asked in Cogniscient Business Solutions SAP Technical Consultant interview?

Some of the top questions asked at the Cogniscient Business Solutions SAP Technical Consultant interview -

  1. What are functions and procedu...read more
  2. WHAT ARE VIE...read more

Tell us how to improve this page.

Cogniscient Business Solutions SAP Technical Consultant Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Cogniscient Business Solutions SAP Technical Consultant Salary
based on 9 salaries
₹1.5 L/yr - ₹4.5 L/yr
67% less than the average SAP Technical Consultant Salary in India
View more details

Cogniscient Business Solutions SAP Technical Consultant Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Assistant Software Engineer
31 salaries
unlock blur

₹1.5 L/yr - ₹4.1 L/yr

SQL Developer
28 salaries
unlock blur

₹1.9 L/yr - ₹7 L/yr

Software Developer
18 salaries
unlock blur

₹1.8 L/yr - ₹5.5 L/yr

Software Engineer
16 salaries
unlock blur

₹2 L/yr - ₹6.6 L/yr

Technical Consultant
15 salaries
unlock blur

₹2.4 L/yr - ₹5 L/yr

Explore more salaries
Compare Cogniscient Business Solutions with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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