Zillion Analytics Interview Questions and Answers

Q1. Project Experience and end to end architecture
Ans. 
I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.
• Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

• Developed applications using AWS SDKs and integrated with other AWS services.

• Performed testing and debugging of applications on AWS infrastructure.

• Deployed applications on AWS using CI/CD pipel...read more
Answered by AI
Add your answer
Q2. PySpark Coding question to Extract Transform & Load
Add your answer
Q3. Cost Optimization on Snowflake
Ans. 
Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.
• Utilize virtual warehouses efficiently based on workload requirements

• Enable auto-suspend to automatically pause warehouses when not in use

• Monitor resource usage and adjust configurations accordingly
Answered by AI
Add your answer

Q1. Project end to end
Add your answer
Q2. How to connect to a share point database
Ans. 
To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.
• Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

• Authenticate using OAuth tokens to access SharePoint resources securely.

• Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

• Ensure proper permissions are set up for the application accessing the Sha
Answered by AI
Add your answer
Q3. Normalization & de normalization
Add your answer
Q4. Questions on SQL Joins
Add your answer
Q5. Question to find the 2nd highest salary using window function
Ans. 
Use window function to find 2nd highest salary in SQL
• Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

• Filter the results where the row number is 2 to get the 2nd highest salary
Answered by AI
Add your answer

Q1. Why are you looking for a job change
Add your answer
Q2. How was the experience at previous company
Add your answer
Q3. Expected CTC at Scatterpie
Ans. 
Expected CTC at Scatterpie
• Research industry standards for AWS Developer roles at Scatterpie

• Consider your experience, skills, and qualifications

• Factor in location, company size, and benefits package

• Negotiate based on market trends and personal value
Answered by AI
Add your answer

I have already added the questions.

Q1. Can you provide a description of your previous work experience?
Add your answer
Q2. What were the reasons for leaving your previous job?
Add your answer

Q1. What are your salary expectations?
Add your answer

Crafting a proposal for a potential client.

Q1. Laboratory technician
Add your answer
Q2. Laboratory technician qualified
Add your answer

Q1. Laboratory technician
Add your answer
Q2. Laboratory technician Qualify
Add your answer

Q1. Quality control
Add your answer
Q2. Complete process
Add your answer

Q1. SQL questions such as case statement, joins and advanced sql question.
Add your answer
Q2. PLSQL, tableau basic to advanced question
Add your answer

Q1. Bureau operations,credit data
Add your answer
Q2. Career goals and future plans
Add your answer

Q1. Only two rounds were there
Add your answer
Q2. Na rounds happened after two rounds
Add your answer

Q1. Unica technical questions
Add your answer
Q2. What is flow chart
Add your answer

Q1. Technical ask about macro and treatment code
Add your answer
Q2. Campaign attributes
Add your answer

Q1. What are the technical skills that you use to analyse the data?
Ans. 
I use technical skills such as programming languages, data visualization tools, statistical analysis, and database management to analyze data.
• Programming languages (e.g. Python, R, SQL)

• Data visualization tools (e.g. Tableau, Power BI)

• Statistical analysis techniques (e.g. regression analysis, hypothesis testing)

• Database management (e.g. SQL Server, MySQL)
Answered by AI
Add your answer
Q2. What exactly do you do in your current job?
Add your answer

Q1. What is the most important skill do you think you should have for this job role?
Add your answer
Q2. How do you negotiate with vendors?
Ans. 
Negotiating with vendors involves establishing clear communication, understanding needs, exploring options, and finding mutually beneficial agreements.
• Establish clear communication to understand vendor's offerings and terms

• Understand your organization's needs and budget constraints

• Explore multiple vendor options to compare prices, quality, and services

• Negotiate based on data and facts rather than emotions

• Seek mutually ...read more
Answered by AI
Add your answer