Sokrati Interview Questions and Answers

Q1. Types of accounts have you worked on so far?
Ans. 
I have worked on various types of accounts including retail, corporate, and investment accounts.
• Retail accounts - managing individual customer accounts for everyday banking needs

• Corporate accounts - handling accounts for businesses and organizations

• Investment accounts - overseeing accounts for investments and financial planning
Answered by AI
Add your answer
Q2. Strategies you have been a part of and thought process for making them the way they were made
Add your answer

Q1. Tell me about yourself
Add your answer

Got an assignment to perform in excel about data analysis for churn prediction. Performed in excel. 70% focus was on skills and 30% on analysis.

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. They are asking technical questions what is their in the resume
Add your answer

Q1. They will technical questions as per your resume what you mentioned
Add your answer