Filter interviews by
Be the first one to contribute and help others!
I applied via LinkedIn and was interviewed in Oct 2024. There were 3 interview rounds.
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...
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
posted on 25 Nov 2024
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
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...
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
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...
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...
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
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
Coalesce is a function used to return the first non-null value in a list of expressions.
Coalesce function is commonly used in SQL to handle null values.
It takes multiple arguments and returns the first non-null value.
Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Repartition is the process of redistributing data across partitions in a distributed system.
Repartitioning helps in balancing the workload and improving performance in distributed computing environments.
It involves moving data between partitions based on certain criteria such as key values or hash functions.
Repartitioning can be done in Spark using operations like repartition() or coalesce().
A non repeatable character is a character that appears only once in a given string.
Iterate through the string and count the frequency of each character
Identify the characters that have a frequency of 1
Return the first non repeatable character found
Sort list without using sort method
Create a custom sorting function using loops
Compare each element with every other element to determine the correct order
Swap elements based on the comparison results
posted on 23 Dec 2024
I applied via Approached by Company and was interviewed in Jun 2024. There were 2 interview rounds.
Market size and value of India diagnostics market
I am a detail-oriented and analytical individual with a strong background in data analysis and problem-solving.
Graduated with a degree in Statistics
Proficient in statistical software such as R and Python
Experience in analyzing large datasets to derive insights
Strong communication skills for presenting findings to stakeholders
I have worked on various custom and syndicate projects in my previous roles.
Led a team in developing a custom market research report for a pharmaceutical company
Contributed to syndicate reports on consumer behavior trends in the tech industry
Collaborated with clients to tailor research findings to their specific needs
I applied via Walk-in and was interviewed in Nov 2024. There was 1 interview round.
posted on 18 Sep 2024
Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.
I worked as a Research Analyst at a market research firm, conducting data analysis and preparing reports.
Conducted market research studies to analyze consumer behavior and trends
Collected and analyzed data using statistical software such as SPSS and Excel
Prepared reports and presentations for clients based on research findings
Collaborated with team members to design research methodologies and strategies
I applied via Referral and was interviewed in Apr 2024. There were 3 interview rounds.
Good and easy to understand stand
Good and competative
Research Analyst
3
salaries
| ₹10 L/yr - ₹14 L/yr |
Research Consultant
3
salaries
| ₹8 L/yr - ₹9.6 L/yr |
GfK MODE
Nyx-medical Solutions
Market Xcel Data Matrix
Future Market Insights