Zephirum Research 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

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. What is minaral and different by metals?
Ans. 
Minerals are naturally occurring inorganic substances with a definite chemical composition, while metals are a type of mineral that have high electrical conductivity and luster.
• Minerals are inorganic substances found in nature, while metals are a subset of minerals with specific properties.

• Metals have high electrical conductivity, malleability, and luster, distinguishing them from other minerals.

• Examples of metals incl...read more
Answered by AI
Add your answer
Q2. What is spong iron?
Ans. 
Sponge iron is a metallic product produced through the direct reduction of iron ore in the form of lumps, pellets, or fines.
• Sponge iron is also known as direct reduced iron (DRI).

• It is produced by removing oxygen from iron ore through a chemical reaction using natural gas or coal as a reducing agent.

• Sponge iron is used as a raw material in the production of steel through the electric arc furnace (EAF) or basic oxygen f
Answered by AI
Add your answer

Q1. What is whrb in rotary kiln?
Ans. 
WHRB in rotary kiln stands for Waste Heat Recovery Boiler, which is used to recover heat from the exhaust gases of the kiln.
• WHRB is a type of boiler that captures and reuses the heat energy from the exhaust gases of a rotary kiln.

• It helps in improving the overall energy efficiency of the kiln operation.

• The recovered heat can be used for various purposes such as preheating combustion air or generating steam for power ge...read more
Answered by AI
Add your answer
Q2. Explain Iron smelting process ?
Ans. 
Iron smelting process is a method of extracting iron from its ore using heat and reducing agents.
• Iron ore is heated in a blast furnace with coke (carbon) and limestone as reducing agents.

• The coke burns to produce carbon monoxide, which reacts with the iron ore to release the iron metal.

• The limestone helps to remove impurities from the iron ore, forming slag as a byproduct.

• The molten iron is then collected at the bottom...read more
Answered by AI
Add your answer

Q1. What is off page Seo
Ans. 
Off page SEO refers to activities done outside of your website to improve its search engine rankings.
• Building backlinks from reputable websites

• Social media marketing

• Guest blogging on relevant websites

• Online reputation management

• Local SEO strategies
Answered by AI
Add your answer
Q2. What is on page seo
Ans. 
On-page SEO refers to the practice of optimizing individual web pages to rank higher and earn more relevant traffic in search engines.
• Includes optimizing content, meta tags, headings, images, and URLs

• Focuses on improving user experience and relevance

• Helps search engines understand the content of a page and its relevance to users

• Examples: keyword optimization, internal linking, mobile optimization
Answered by AI
Add your answer
Q3. Type of digital marketing
Ans. 
Digital marketing encompasses various online strategies to promote products or services.
• Search engine optimization (SEO) - optimizing website content to rank higher in search engine results

• Social media marketing - using platforms like Facebook, Instagram, and Twitter to engage with audiences

• Email marketing - sending targeted emails to potential customers

• Content marketing - creating and sharing valuable content to attra...read more
Answered by AI
Add your answer

Q1. Types of research, qualitative and quantitative?
Add your answer

Technical knowledge and troubleshooting discussion

Q1. Hydraulic symbols, hydraulic circuit drow
Add your answer
Q2. How to work hydraulic system
Ans. 
A hydraulic system uses fluid to transmit power and control movement in machinery.
• Hydraulic systems use a pump to pressurize fluid, typically oil or water.

• The pressurized fluid is then used to generate force and control the movement of various components.

• Components of a hydraulic system include pumps, actuators, valves, and fluid reservoirs.

• Proper maintenance and regular inspection are essential to ensure the system's ...read more
Answered by AI
Add your answer
Q3. How to attend troubleshooting
Ans. 
To attend troubleshooting, follow a systematic approach by identifying the problem, gathering information, analyzing data, and implementing solutions.
• Identify the problem by gathering information from the user or observing the issue

• Ask relevant questions to understand the symptoms and potential causes

• Analyze available data, logs, and system configurations to narrow down the problem

• Use diagnostic tools and techniques to...read more
Answered by AI
Add your answer

Assignment in excel with proper presentation

Q1. Generic HR questions were being asked which wasn't that difficult
Add your answer
Q2. As usual they'll try to negotiate and reduce the salary slab.
Add your answer

Q1. The interviewee was really friendly and made me comfortable while asking questions related to the job role. It was all mostly based on your previous job role and how can I contribute as an executive in th...read more
Add your answer