i
Mphasis
Filter interviews by
Clear (1)
I was interviewed in Dec 2024.
Optimisation in PySpark involves improving performance and efficiency of Spark jobs.
Use partitioning to distribute data evenly across nodes
Avoid shuffling data between nodes as much as possible
Use broadcast variables for small lookup tables
Cache intermediate results to avoid recomputation
Optimize transformations and actions for better performance
Null handling in Spark involves handling missing or null values in data processing.
Use functions like coalesce, na.fill, na.drop to handle null values
Consider using when and otherwise functions for conditional null handling
Be cautious of potential null pointer exceptions when working with null values
Airflow operators are used to define the tasks to be executed in a workflow.
Operators are classes that define the logic to execute a task in Airflow.
There are various types of operators such as BashOperator, PythonOperator, and more.
Operators can be customized to suit specific task requirements.
Operators can be chained together to create complex workflows.
Example: BashOperator executes a bash command, PythonOperator ru
SQL coding for calculating average rolling, lead, and lag functions.
Use window functions like ROWS BETWEEN and ORDER BY for calculating rolling averages.
Use LEAD and LAG functions to access data from previous or next rows.
Example: SELECT col1, AVG(col2) OVER (ORDER BY col1 ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS rolling_avg FROM table_name;
Use Apache Sqoop to move 10 tables from MySQL to Google Cloud Storage.
Use Apache Sqoop to import data from MySQL to HDFS
Use Google Cloud Storage connector for Hadoop to move data from HDFS to GCS
Create a script to automate the process for all 10 tables
Precompilation unit is a compiled code that can be reused by multiple source files.
Precompilation unit is created by the compiler from the source code.
It contains the compiled code of header files and other dependencies.
It can be reused by multiple source files, reducing compilation time.
It is also known as precompiled header or PCH.
Example: stdafx.h in Visual Studio is a precompiled header file.
posted on 15 Feb 2016
The first 50 prime numbers are...
Start with 2, the first prime number
Check each odd number greater than 2
Use trial division to check if a number is prime
Stop when you have found 50 prime numbers
Sorting a file within a range
Use a sorting algorithm like quicksort or mergesort
Read the file and store the data in an array or list
Sort the array or list within the given range
Write the sorted data back to the file
I am a passionate software engineer with experience in developing web applications using various technologies.
Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular
Proficient in backend development with Node.js, Express, and MongoDB
Familiar with version control systems like Git and project management tools like Jira
posted on 27 Dec 2015
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge in algorithms and data structures
Passionate about learning new technologies and solving complex problems
I have worked on various projects including a web application for inventory management and a mobile app for fitness tracking.
Developed a web application using React for inventory management
Created a mobile app using Flutter for fitness tracking
Implemented RESTful APIs for communication between frontend and backend systems
My area of interest is artificial intelligence and machine learning.
I have experience in developing machine learning models for predictive analytics.
I am interested in natural language processing and computer vision applications.
I enjoy exploring deep learning algorithms and neural networks.
I have worked on projects involving recommendation systems and image recognition.
C++ is a high-level programming language with features like object-oriented programming, templates, and memory management.
C++ supports object-oriented programming concepts like encapsulation, inheritance, and polymorphism.
Templates allow generic programming and code reusability.
C++ provides low-level memory manipulation through pointers.
Standard Template Library (STL) provides a collection of classes and functions for ...
Big Data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big Data is characterized by the 3Vs - Volume, Velocity, and Variety.
It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.
Examples of Big Data include social media data, sensor data, and financial market data.
Program to reverse a string without using string function
Iterate through the string from end to start and append each character to a new string
Use a loop to swap the first and last characters, then move towards the middle until the entire string is reversed
Convert the string to a character array, then swap the first and last elements until the entire array is reversed
I was responsible for designing and implementing the project's database and backend functionality.
Designed the database schema and created the necessary tables
Implemented the backend functionality using Java and Spring framework
Collaborated with team members to integrate the frontend and backend components
Tested the application and fixed any bugs or issues that arose
Presented the project to the faculty and received pos
Keys in a database are unique identifiers used to establish relationships between tables and ensure data integrity.
Keys are used to uniquely identify records in a database table.
Primary keys are used to uniquely identify each record in a table.
Foreign keys establish relationships between tables.
Keys help enforce data integrity and maintain consistency in the database.
Examples of keys include primary keys, foreign keys,
Issues in cloud include security, downtime, vendor lock-in, and data privacy.
Security concerns such as data breaches and unauthorized access
Downtime and service interruptions affecting business operations
Vendor lock-in and limited flexibility in choosing cloud providers
Data privacy and compliance with regulations such as GDPR and HIPAA
Developed a web application for online shopping using React and Node.js
Implemented user authentication and authorization using JSON Web Tokens (JWT)
Used MongoDB as the database to store user and product information
Implemented a search feature using Elasticsearch to provide fast and accurate search results
Integrated Stripe payment gateway for secure online transactions
The flow diagram of my final year project showcases the step-by-step process of its execution.
The flow diagram illustrates the sequence of activities and their dependencies.
It helps in understanding the overall structure and logic of the project.
Each step in the diagram represents a specific task or action.
Arrows indicate the flow of control or data between different steps.
Decision points are represented by diamond-sha...
Normalisation reduces data redundancy and improves data integrity in a database.
Prevents data duplication and inconsistencies
Simplifies database maintenance and updates
Improves query performance
Enforces data integrity and consistency
Follows best practices for database design
Examples: breaking down a customer table into separate tables for orders, addresses, and payments
Examples: creating a separate table for product ca...
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge of algorithms and data structures
Familiar with agile development methodologies and version control systems like Git
I am a problem solver, team player, quick learner, detail-oriented, and have strong communication skills.
Problem solver - I enjoy tackling complex problems and finding innovative solutions.
Team player - I work well with others and value collaboration in achieving goals.
Quick learner - I am able to pick up new technologies and concepts quickly.
Detail-oriented - I pay attention to the smallest details to ensure high-qual...
Yes, I have a Bachelor's degree in Computer Engineering.
Bachelor's degree in Computer Engineering
Experience in software development
Knowledge of engineering principles applied to software design
My day was productive and challenging, with a lot of problem-solving and collaboration.
Completed a major coding project ahead of schedule
Participated in a brainstorming session with team members
Solved a tricky bug in the codebase
Attended a virtual meeting with stakeholders
No, I do not have any relatives in Pune. I have arranged for my accommodation in a rented apartment near the office.
No relatives in Pune
Accommodation arranged in a rented apartment near the office
Yes, My Passion Challenge test is a coding competition for software engineers.
My Passion Challenge test is a coding competition that evaluates the coding skills of software engineers.
It is designed to test problem-solving abilities, algorithmic thinking, and coding proficiency.
Participants are given a set of coding challenges to solve within a specified time limit.
The challenges can range from simple to complex, coveri...
Considering pursuing a Master's degree in Computer Science to deepen knowledge and advance career.
Considering pursuing a Master's degree in Computer Science
To deepen knowledge and advance career
Examples: MS in Computer Science at XYZ University, online courses in AI and Machine Learning
posted on 21 Mar 2015
I applied via Referral
Data structures are a way to organize and store data efficiently.
Data structures are used to store and manipulate data in a structured manner.
They provide different ways to access and perform operations on the data.
Examples include arrays, linked lists, stacks, queues, trees, and graphs.
Developed a web-based project management tool for tracking tasks and deadlines
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express for back-end
Utilized MongoDB for database management
Incorporated user authentication and authorization features
Integrated real-time notifications using Socket.io
My name is John Smith.
Full name is John Smith
Common name in English-speaking countries
Easy to remember and pronounce
The question is unrelated to the medical field and is not a puzzle or riddle.
The question is asking about the meaning of the interviewer's name.
You can ask the interviewer about the origin or cultural significance of their name.
You can also mention that names often have different meanings in different languages or cultures.
My strengths include problem-solving skills, attention to detail, and strong communication abilities.
Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.
Attention to detail - I am meticulous in my work and strive for accuracy in all tasks.
Strong communication abilities - I can effectively convey ideas and collaborate with team members.
based on 2 interviews
Interview experience
Software Engineer
6.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
5.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
4.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Module Lead
2.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Transaction Processing Officer
2.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Wipro
Accenture
TCS