Blackstraw AI Senior Program Manager Interview Questions and Answers

Q1. Describe your current project snd your role.
Ans. 
Leading a team in developing a mobile app for tracking fitness goals.
• Managing a team of developers and designers

• Creating project timelines and milestones

• Collaborating with stakeholders to gather requirements

• Testing and quality assurance of the app

• Implementing feedback and updates based on user testing

• Ensuring project stays within budget and timeline
Answered by AI
Add your answer

Q1. Describe your role
Ans. 
I oversee project planning, execution, and delivery to ensure successful completion.
• Lead project teams in defining project scope, goals, and deliverables

• Develop project plans and schedules, and track progress against milestones

• Manage project budget and resources effectively

• Communicate with stakeholders to ensure alignment and manage expectations

• Identify and mitigate project risks and issues

• Ensure quality standards are ...read more
Answered by AI
Add your answer

Q1. Describe your childhood
Ans. 
I had a happy and adventurous childhood filled with outdoor activities and family vacations.
• Grew up in a small town surrounded by nature

• Enjoyed playing sports like soccer and basketball

• Went on camping trips with my family every summer

• Participated in school plays and talent shows

• Had a close-knit group of friends from the neighborhood
Answered by AI
Add your answer

Q1. Walk me through your profile highlighting 2-3 key achievements
Add your answer
Q2. *Include pointers that are most relevant to job description * Weave entire profile like a story showing that you have growing trend * Put your achievements in CAR format. Challenge that d project had, Act...read more
Add your answer

Q1. What will be your 30 days plan if you are hired?
Add your answer

Q1. Why are you looking for a change?
Add your answer

Q1. Previous work experience related
Add your answer
Q2. How did i solve business problems through analytics
Ans. 
I utilized data analytics to identify root causes of business problems and develop effective solutions.
• Utilized data analytics tools such as Excel, Tableau, and SQL to analyze large datasets

• Identified trends and patterns in data to pinpoint areas of improvement

• Developed predictive models to forecast future business outcomes

• Collaborated with cross-functional teams to implement data-driven solutions

• Monitored key performa...read more
Answered by AI
Add your answer

Data cleansing, data querying and data visualization

Q1. Case solutioning
Add your answer
Q2. Case study explanation and data science algorithm explanation
Add your answer

Q1. How to decide upon Spark cluster sizing?
Ans. 
Spark cluster sizing depends on workload, data size, memory requirements, and processing speed.
• Consider the size of the data being processed

• Take into account the memory requirements of the Spark jobs

• Factor in the processing speed needed for the workload

• Scale the cluster based on the number of nodes and cores required

• Monitor performance and adjust cluster size as needed
Answered by AI
Add your answer
Q2. Question on Spark internals
Add your answer

Implement a pipeline based on given conditions and data requirement

Q1. There were no questions as such. They want me join on very next day when the HR discussion was over and started itimidating me with aggressive approach even without discussing the salary part and the benef...read more
Add your answer

Q1. NLP based question
Add your answer

Q1. Components of Databricks
Ans. 
Databricks is a unified data analytics platform that includes components like Databricks Workspace, Databricks Runtime, and Databricks Delta.
• Databricks Workspace: Collaborative environment for data science and engineering teams.

• Databricks Runtime: Optimized Apache Spark cluster for data processing.

• Databricks Delta: Unified data management system for data lakes.
Answered by AI
Add your answer
Q2. How to read a json file
Ans. 
To read a JSON file, use a programming language's built-in functions or libraries to parse the file and extract the data.
• Use a programming language like Python, Java, or JavaScript to read the JSON file.

• Import libraries like json in Python or json-simple in Java to parse the JSON data.

• Use functions like json.load() in Python to load the JSON file and convert it into a dictionary or object.

• Access the data in the JSON fi...read more
Answered by AI
Add your answer
Q3. Second highest salary SQL
Ans. 
To find the second highest salary in SQL, use the MAX function with a subquery or the LIMIT clause.
• Use the MAX function with a subquery to find the highest salary first, then use a WHERE clause to exclude it and find the second highest salary.

• Alternatively, use the LIMIT clause to select the second highest salary directly.

• Make sure to handle cases where there may be ties for the highest salary.
Answered by AI
Add your answer
Q4. How to configure the spark while creating the cluster
Ans. 
Spark cluster configuration involves setting up memory, cores, and other parameters for optimal performance.
• Specify the number of executors and executor memory

• Set the number of cores per executor

• Adjust the driver memory based on the application requirements

• Configure shuffle partitions for efficient data processing

• Enable dynamic allocation for better resource utilization
Answered by AI
Add your answer