Hic Global Solutions Quality Analyst Interview Questions and Answers

Test of SQL, Tableau and other skills based on your resume on Skillate

Q1. SQL and other skills technical questions
Add your answer

Q1. Manager round / 2nd technical round
Add your answer

Q1. Find wheteher the given number is fibonacci or not
Ans. 
To determine if a number is a Fibonacci number or not.
• Check if 5*n^2 + 4 or 5*n^2 - 4 is a perfect square

• If either of the above conditions is true, the number is a Fibonacci number

• Example: 5 is a Fibonacci number as 5*5 - 4 = 21 which is a perfect square
Answered by AI
View 1 more answer
Q2. How will you add caching to improve fast response
Ans. 
Implement caching by storing frequently accessed data in memory to improve response time.
• Identify frequently accessed data that can be cached

• Choose an appropriate caching strategy (e.g. in-memory caching, distributed caching)

• Implement caching mechanisms such as Redis or Memcached

• Set expiration policies for cached data to ensure freshness

• Monitor cache performance and adjust as needed
Answered by AI
Add your answer

Q1. Agilecscrum, team management, test Mgmt, end to end testing, jira, defect flow
Add your answer

Q1. Agile scrum, validation testing, jira, Team management, test mgmt
Add your answer

Identifying test cases

Defect and bug difference

Q1. Test planning , previous projects and automation questions
Add your answer

Q1. Expectations from company and all.
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