AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Coforge
Compare
Filter interviews by
Coforge Data Analyst Interview Questions and Answers
Coforge Data Analyst Interview Experiences
4 interviews found
Anonymous
(2 Questions)
- Q1. Introduce yourself and past experience
- Q2. Describe slowing changing dimensions
- Ans.
Slowly changing dimensions are attributes that change over time, but at a slow rate.
SCD is a technique used in data warehousing to handle changes in dimensions over time
Type 1 SCD overwrites old data with new data
Type 2 SCD creates a new record for each change and maintains a history
Type 3 SCD adds a new column to the existing record to store the new value
Examples of SCD include customer addresses, product prices, and
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
(2 Questions)
- Q1. Data structures and oops
- Q2. Sql and basic python
I applied via Naukri.com and was interviewed before Jan 2021. There were 6 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Denodo architecture
- Q2. Plsql performance tuning
- Q3. Scenario based cases
- Q4. Out of the box thinking
Interview Preparation Tips
What people are saying about Coforge
I applied via Recruitment Consultant and was interviewed in Apr 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Database Architecture.
- Q2. Database objects knowledge
Interview Preparation Tips
Coforge interview questions for designations
Interview questions from similar companies
RISHABH Pal
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
The Aptitude Test session accesses mathematical and logical reasoning abilities
(6 Questions)
- Q1. What is Vlookup
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. Some IF else Question in Excel
- Q3. What does your day in your previous organization look like?
- Ans.
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
Reviewing and cleaning large datasets to ensure accuracy
Creating visualizations and reports to communicate insights
Collaborating with team members to identify trends and patterns
Presenting findings to stakeholders in meetings or presentations
- Q4. Could you share the technical skills you possess?
- Ans.
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
Proficient in programming languages such as Python, R, SQL
Skilled in statistical analysis and data modeling techniques
Experience with data visualization tools like Tableau, Power BI
Knowledge of machine learning algorithms and techniques
- Q5. Can you explain what a Pivot Table is?
- Ans.
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.
Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.
Pivot tables are commonly used in Excel and other spreadsheet program...
- Q6. Find the Highest-paid employee in each department along with their salary and department name.
- Ans.
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
Group employees by department
Find the employee with the highest salary in each group
Retrieve the employee's name, salary, and department name
Interview Preparation Tips
- SQL
- Excel
- Problem Solving
- PowerBI
- SQL Queries
Be prepared to discuss past challenges and how did you overcome.
Selected
(6 Questions)
- Q1. Whats your name?
- Ans.
My name is John Doe.
Full name is John Doe
Common first and last name combination
Easy to remember and pronounce
- Q2. Csv stand for?
- Ans.
CSV stands for Comma-Separated Values.
CSV is a file format used to store tabular data in plain text.
Each line in a CSV file represents a row of data, with columns separated by commas.
CSV files can be easily imported and exported in spreadsheet software like Excel.
Example: 'name,age,city' on the first line, followed by 'John,25,New York' on the second line.
- Q3. Tell me something about yourself?
- Ans.
Hello,First of all thankyou very much for giving opportunity to introduced in front of you.I am harsh.I hail from ambala cantt but currently live in defence enclave.I am a fresher. I live in nuclear family.There are 5 of us in my family.I am a object oriented person. I have a master degree in computer application from kurukshetra university.I have done 6 month course in data analyst from chandigarh.I enjoy dancing,Sing...
- Q4. Sql stand for?
- Ans.
SQL stands for Structured Query Language.
SQL is a standard language for accessing and manipulating databases.
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables.
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
- Q5. Write a dml commands?
- Ans.
DML commands are used to manipulate data in a database.
DML stands for Data Manipulation Language
Common DML commands include INSERT, UPDATE, DELETE
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2)
- Q6. Rdbms stands for?
I applied via Job Fair and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. DAX Related Syntax and Codes
- Q2. Data Modelling, SQL, Python
(1 Question)
- Q1. No Response from HR after calling of selection after Round 1
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Basics of mathematical ability and verbal ability
(2 Questions)
- Q1. Introduction - explain projects
- Q2. Data analytics explain
(2 Questions)
- Q1. What is the importance of data analysis?
- Ans.
Data analysis is crucial for making informed decisions, identifying trends, and solving complex problems.
Helps in making informed decisions based on data-driven insights
Identifies trends and patterns that can lead to strategic business decisions
Aids in solving complex problems by analyzing data to find root causes
Improves efficiency and effectiveness of processes through data-driven optimizations
- Q2. What steps should be taken to become a data analyst?
- Ans.
To become a data analyst, one should focus on acquiring relevant education, gaining experience with data analysis tools, and developing strong analytical and problem-solving skills.
Obtain a degree in a related field such as statistics, mathematics, computer science, or data science.
Gain experience with data analysis tools such as SQL, Python, R, and Excel.
Develop strong analytical and problem-solving skills by working ...
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. How to perform Set Actions, LOD's
Coforge Interview FAQs
Tell us how to improve this page.
Coforge Interviews By Designations
- Coforge Senior Software Engineer Interview Questions
- Coforge Software Engineer Interview Questions
- Coforge Technical Analyst Interview Questions
- Coforge Graduate Engineer Trainee (Get) Interview Questions
- Coforge Senior Associate Interview Questions
- Coforge Software Developer Interview Questions
- Coforge Senior Test Engineer Interview Questions
- Coforge Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Coforge Data Analyst Interview Process
based on 6 interviews
1 Interview rounds
- Technical Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Coforge Data Analyst Reviews and Ratings
based on 19 reviews
Rating in categories
|
Senior Software Engineer
4.8k
salaries
|  ₹6.2 L/yr - ₹26.2 L/yr |
|
Technical Analyst
2.6k
salaries
| ₹10.6 L/yr - ₹38.4 L/yr |
|
Software Engineer
2k
salaries
| ₹2.2 L/yr - ₹9.5 L/yr |
|
Senior Test Engineer
1.8k
salaries
| ₹4.7 L/yr - ₹19.2 L/yr |
|
Technology Specialist
1.1k
salaries
| ₹11.9 L/yr - ₹42 L/yr |
Capgemini
Cognizant
Accenture
Infosys
- Home >
- Interviews >
- Coforge Interview Questions >
- Coforge Data Analyst Interview Questions
