AST Corporation Consultant Interview Questions and Answers

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

On python and sql coding.they ask simple to complex questions

Q1. On data science machine learning
Add your answer

Q1. What languages do you know? Asked about the project I did and various clarification questions on that.
Add your answer
Q2. What are various assumption you made while implementing this project.
Add your answer

Q1. What is Tuples? How do you convert a string to a tuple?
Ans. 
Tuples are immutable sequences of elements. A string can be converted to a tuple using the tuple() function.
• Tuples are similar to lists but are immutable

• Elements of a tuple are enclosed in parentheses ()

• A string can be converted to a tuple using the tuple() function

• Each character in the string becomes an element in the tuple
Answered by AI
Add your answer
Q2. What is Left Join? Show one Left join for 2 data frames on Python
Ans. 
Left join is a type of join operation in SQL that returns all the rows from the left table and matching rows from the right table.
• Left join is performed using the 'left join' keyword in SQL

• In Python, left join can be performed using the 'merge' function from the pandas library

• Syntax: pd.merge(left_dataframe, right_dataframe, how='left', on='key_column')

• Example: pd.merge(df1, df2, how='left', on='id')
Answered by AI
Add your answer

Moderate difficult with business reasoning

Q1. Prior work Ex mostly and a case study
Add your answer

Q1. Interview based on your programming language , how good you know like java or python or scala
Add your answer
Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
Add your answer
Q3. Explain your recent project in detail
Add your answer

Q1. More deep dive in your expertise technologies like Spark DAG working explain
Add your answer
Q2. How you do data validation in hive
Ans. 
Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.
• Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

• Use regular expressions and pattern matching to validate data formats

• Write custom scripts to perform more complex data validation tasks

• Perform data profiling to identify potential data quality issues

• Use data...read more
Answered by AI
Add your answer

Q1. Salary , why changing job etc..
Add your answer
Q2. Your complete background of career
Add your answer