Filter interviews by
SQL Rank salary calculates employee salaries and ranks them within a dataset using SQL functions.
Use the RANK() function to assign a rank to each salary: RANK() OVER (ORDER BY salary DESC).
Ties in salary will receive the same rank, and the next rank will skip accordingly.
Example: If salaries are 5000, 6000, 6000, 7000, ranks will be 4, 2, 2, 1.
Use PARTITION BY to rank within specific groups, e.g., RANK() OVER (PAR...
The process for Software Development Engineer involves planning, designing, coding, testing, and deploying software solutions.
Gather requirements from stakeholders
Create a design based on requirements
Write code to implement the design
Test the software for bugs and issues
Deploy the software for users to use
Iterate on feedback and make improvements
XML is a markup language while JSON is a lightweight data interchange format.
XML uses tags to define elements while JSON uses key-value pairs.
XML is more verbose and complex than JSON.
JSON is easier to read and parse than XML.
XML supports namespaces and validation while JSON does not.
XML is widely used in web services and document exchange while JSON is preferred for data exchange between applications.
Django follows Model-View-Controller (MVC) architectural pattern.
Django has a high-level architecture that follows the Model-View-Controller (MVC) architectural pattern.
The Model layer represents the database schema and business logic.
The View layer is responsible for rendering the templates and presenting the data to the user.
The Controller layer handles the user's input and interacts with the Model and View laye...
Closing a critical position requires a strategic approach and a thorough understanding of the job requirements and the candidate pool.
Identify the key skills and qualifications required for the position
Develop a targeted recruitment strategy to attract qualified candidates
Utilize multiple sourcing channels, including job boards, social media, and employee referrals
Screen candidates thoroughly to ensure they meet t...
Smoke testing is a quick and shallow test to check if the basic functionalities of the software are working. Sanity testing is a more in-depth test to check if the major functionalities are working as expected.
Smoke testing is done to ensure that the software is stable enough for further testing.
Sanity testing is done to ensure that the major functionalities of the software are working as expected.
Smoke testing is...
Discuss with developer and provide evidence to support the defect.
Schedule a meeting with the developer to discuss the defect.
Provide evidence such as screenshots, logs, or test results to support the defect.
Collaborate with the developer to understand their perspective and come to a resolution.
If necessary, escalate the issue to a higher authority for further review.
Severity is based on impact on system functionality, priority is based on business needs.
Severity is determined by the impact of the defect on the system functionality
Priority is determined by the business needs and urgency of the defect
Defects with high severity and high priority should be fixed first
Severity levels can be categorized as critical, major, minor, and cosmetic
Priority levels can be categorized as hi...
SDLC is Software Development Life Cycle, STLC is Software Testing Life Cycle, and Bug Life Cycle is the process of a bug from discovery to resolution.
SDLC is a process that outlines the development of software from conception to delivery.
STLC is a process that outlines the testing of software from planning to execution.
Bug Life Cycle is the process of a bug from discovery to resolution, including steps like report...
I appeared for an interview in Nov 2024, where I was asked the following questions.
Simple but fast paced test
I am a recent graduate with a degree in Business Administration and a passion for marketing and analytics.
Recent graduate with a degree in Business Administration
Passionate about marketing and analytics
Strong communication and analytical skills
Experience in internships related to marketing
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
The process for Software Development Engineer involves planning, designing, coding, testing, and deploying software solutions.
Gather requirements from stakeholders
Create a design based on requirements
Write code to implement the design
Test the software for bugs and issues
Deploy the software for users to use
Iterate on feedback and make improvements
posted on 8 Jan 2025
I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.
I appeared for an interview before Mar 2024, where I was asked the following questions.
SQL Rank salary calculates employee salaries and ranks them within a dataset using SQL functions.
Use the RANK() function to assign a rank to each salary: RANK() OVER (ORDER BY salary DESC).
Ties in salary will receive the same rank, and the next rank will skip accordingly.
Example: If salaries are 5000, 6000, 6000, 7000, ranks will be 4, 2, 2, 1.
Use PARTITION BY to rank within specific groups, e.g., RANK() OVER (PARTITIO...
Calculate salary ranks using SQL to determine employee standings based on their salaries.
Use the RANK() function to assign ranks based on salary: SELECT name, salary, RANK() OVER (ORDER BY salary DESC) AS rank FROM employees;
Handle ties with DENSE_RANK() to avoid gaps in ranking: SELECT name, salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees;
Use PARTITION BY to rank within specific groups, e.g., b...
As a Project Manager, I faced challenges like scope creep, resource allocation, and stakeholder communication.
Scope Creep: A project initially aimed at developing a software tool expanded to include additional features without proper assessment, leading to delays.
Resource Allocation: During a critical phase, key team members were pulled into other projects, causing bottlenecks and impacting timelines.
Stakeholder Commun...
Topics:
Python, Django, MySQL, Automation, Technical questions
XML is a markup language while JSON is a lightweight data interchange format.
XML uses tags to define elements while JSON uses key-value pairs.
XML is more verbose and complex than JSON.
JSON is easier to read and parse than XML.
XML supports namespaces and validation while JSON does not.
XML is widely used in web services and document exchange while JSON is preferred for data exchange between applications.
Top trending discussions
The duration of DynPro interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 28 interview experiences
Difficulty level
Duration
based on 262 reviews
Rating in categories
3-8 Yrs
Not Disclosed
5-10 Yrs
Not Disclosed
5-10 Yrs
Not Disclosed
Talent Acquisition Executive
57
salaries
| ₹2 L/yr - ₹4 L/yr |
Information Technology Recruiter
54
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
Software Engineer
46
salaries
| ₹6 L/yr - ₹13 L/yr |
Software Developer
39
salaries
| ₹5.8 L/yr - ₹12 L/yr |
Senior Software Engineer
38
salaries
| ₹6.3 L/yr - ₹19 L/yr |
HCL Infosystems
Accel Frontline
Pitney Bowes
JMR Infotech