ScatterPie 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

Using PySpark for ETL processes to manipulate and analyze large datasets efficiently.

• Use SparkSession to initialize PySpark: `spark = SparkSession.builder.appName('ETL Example').getOrCreate()`

• Load data from various sources: `df = spark.read.csv('path/to/file.csv', header=True)`

• Transform data using DataFrame operations: `df_filtered = df.filter(df['age'] > 30)`

• Perform aggregations: `df_grouped = df.groupBy('departmen...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...read more

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 have hands-on experience with Tableau, focusing on data visualization and dashboard creation for insightful business analysis.

• Completed a project where I created interactive dashboards to visualize sales data, improving decision-making for the sales team.

• Utilized Tableau to analyze customer feedback data, identifying trends that led to a 15% increase in customer satisfaction.

• Participated in a team project that involv...read more

I have worked on various BI projects, focusing on data visualization, analysis, and reporting to drive business decisions.

• Developed a sales dashboard using Tableau to visualize monthly sales trends and identify top-performing products.

• Created an automated reporting system in Excel that reduced report generation time by 50%.

• Conducted a customer segmentation analysis using SQL to target marketing efforts more effectively...read more