Zillion Analytics Interview Questions and Answers

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

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

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

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

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

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)

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

PSI stands for Pounds per Square Inch, a unit of pressure measurement commonly used in engineering and physics.

• PSI is used to measure pressure in various systems, such as in pneumatic tools, hydraulic systems, and air compressors.

• 1 PSI is equal to 0.068046 atmospheres or 6,894.76 Pascals.

• For example, a car tire may require inflation to 32 PSI for optimal performance.

Firing strokes position refers to the position of the firing strokes in an engine.

• Firing strokes position is crucial for the proper functioning of the engine.

• The firing order of the engine determines the position of the firing strokes.

• Incorrect firing strokes position can lead to engine misfires or damage.

• Common firing orders include 1-3-4-2 for a 4-cylinder engine and 1-8-4-3-6-5-7-2 for a V8 engine.

To work a hydraulic pump, you need to understand its components and operation.

• Understand the basic components of a hydraulic pump such as the inlet, outlet, and pistons.

• Ensure the pump is properly connected to a power source and the hydraulic system.

• Monitor the pump's pressure and flow rate to ensure optimal performance.

• Regularly check and maintain the pump to prevent any malfunctions or breakdowns.

• Examples: Gear pump,

A torque gun is a tool used to apply torque to fasteners such as nuts and bolts.

• Ensure the torque gun is set to the correct torque value for the fastener being tightened.

• Hold the torque gun perpendicular to the fastener and apply pressure while pulling the trigger.

• Listen for the click or beep indicating the desired torque has been reached.

• Do not over-tighten the fastener as it can cause damage.

• Regularly calibrate and m