Ceridian Interview Questions and Answers for Freshers

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

Q1. Form based JS questions. String questions in javascript
Add your answer
Q2. React interview questions with some state management follow up questions.
Add your answer

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer

There were 3 rounds for data science consultant position at Equifax. 1st round consists of Python and SQL questions and also in this round they have tested analytical thinking as well.

In 2nd round they have asked me questions from my resume and asked me to explain the projects which I have worked on in previous company. In this round they have asked me pandas related questions and asked me write code.

Q1. In Managerial round again here I have been asked questions related my projects. and no coding round in this stage.
Add your answer