Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
We want to connect the people who have knowledge to the people who need it, to bring together people with different perspectives so they can understand each other better, and to empower everyone to share their knowledge.
What attracted you to our company?
This is your opportunity to show you’ve done your research. Before the interview, read up on everything you can about the company: their values, mission, latest results and news releases, who their executive staff are, their origin story, as well as their products and/or services. Then, identify whaRead more
This is your opportunity to show you’ve done your research.
Before the interview, read up on everything you can about the company: their values, mission, latest results and news releases, who their executive staff are, their origin story, as well as their products and/or services.
Then, identify what stands out about the company’s mission and values, and how that resonates with you and your career path. If you’re a fan of their products or services, bring that up too.
See lessIf You Were an Animal, Which One Would You Want to Be?
Don't be alarmed if you're asked weird interview questions. Interviewers use this type of psychological question to see if you can think quickly. If you answer "a bunny," you will make a soft, passive impression. If you answer "a lion," you will be seen as aggressive. What type of personality wouldRead more
Don’t be alarmed if you’re asked weird interview questions. Interviewers use this type of psychological question to see if you can think quickly. If you answer “a bunny,” you will make a soft, passive impression. If you answer “a lion,” you will be seen as aggressive. What type of personality would it take to get the job done? What impression do you want to make?
See lessWhat Salary Are You Seeking?
When you're asked, "What salary are you seeking?" it is to your advantage if the employer tells you the range first. Prepare by knowing the going rate in your area, and your bottom line or walk-away point. One possible answer would be: "I am sure when the time comes, we can agree on a reasonable amoRead more
When you’re asked, “What salary are you seeking?” it is to your advantage if the employer tells you the range first. Prepare by knowing the going rate in your area, and your bottom line or walk-away point. One possible answer would be: “I am sure when the time comes, we can agree on a reasonable amount. In what range do you typically pay someone with my background?”
See lessWhat Are Three Positive Things Your Last Boss Would Say About You?
It's time to pull out your old performance appraisals and boss's quotes to answer the question, "What are three positive things your last boss would say about you?". This is a great way to brag about yourself through someone else's words: "My boss has told me that I am the best designer he has everRead more
It’s time to pull out your old performance appraisals and boss’s quotes to answer the question, “What are three positive things your last boss would say about you?”. This is a great way to brag about yourself through someone else’s words: “My boss has told me that I am the best designer he has ever had. He knows he can rely on me, and he likes my sense of humour.”
See lessWhat Can You Do for Us That Other Candidates Can't?
Emphasize what makes you unique when asked, "What can you do for us that other candidates can't?" This will take an assessment of your experiences, skills and traits. Summarize: "I have a unique combination of strong technical skills, and the ability to build strong customer relationships. This alloRead more
Emphasize what makes you unique when asked, “What can you do for us that other candidates can’t?” This will take an assessment of your experiences, skills and traits. Summarize: “I have a unique combination of strong technical skills, and the ability to build strong customer relationships. This allows me to use my knowledge and make information more user-friendly.”
See lessWhen Were You Most Satisfied in Your Job?
The interviewer who asks, "When were you most satisfied in your job?" wants to know what motivates you. If you can relate an example of a job or project when you were excited, the interviewer will get an idea of your preferences. "I was delighted in my last job because I worked directly with the cusRead more
The interviewer who asks, “When were you most satisfied in your job?” wants to know what motivates you. If you can relate an example of a job or project when you were excited, the interviewer will get an idea of your preferences. “I was delighted in my last job because I worked directly with the customers and their problems; that is an important part of the job.”
See lessWhy Did You Leave (or Why Are You Leaving) Your Job?
One of the most critical job interview tips: Don't badmouth a former employer. So if an interviewer asks, "Why did you leave (or why are you leaving) your job?" and you're unemployed, state your reason for leaving in a positive context: "I managed to survive two rounds of corporate downsizing, but tRead more
One of the most critical job interview tips: Don’t badmouth a former employer. So if an interviewer asks, “Why did you leave (or why are you leaving) your job?” and you’re unemployed, state your reason for leaving in a positive context: “I managed to survive two rounds of corporate downsizing, but the third round was a 20% reduction in the workforce, which included me.”
See lessWhat Are Your Goals?
When you're asked, "What are your goals?" sometimes it's best to talk about short-term and intermediate goals rather than locking yourself into the distant future. For example, "My immediate goal is to get a job in a growth-oriented company. My long-term goal will depend on where the company goes. IRead more
When you’re asked, “What are your goals?” sometimes it’s best to talk about short-term and intermediate goals rather than locking yourself into the distant future. For example, “My immediate goal is to get a job in a growth-oriented company. My long-term goal will depend on where the company goes. I hope to eventually grow into a position of responsibility.”
See lessWhy Do You Want to Work Here?
Many interview questions and answers seek to evaluate whether or not a job is a good fit for a candidate. By asking you, "Why do you want to work here?" the interviewer is listening for an answer that indicates you've given this some thought and are not sending out resumes just because there is an oRead more
Many interview questions and answers seek to evaluate whether or not a job is a good fit for a candidate. By asking you, “Why do you want to work here?” the interviewer is listening for an answer that indicates you’ve given this some thought and are not sending out resumes just because there is an opening. For example, “I’ve selected key companies whose mission statements are in line with my values, where I know I could be excited about what the company does, and this company is very high on my list of desirable choices.”
See lessWhat Are Your Weaknesses?
"What are your weaknesses" is one of the most popular questions interviewers ask. It is also the most dreaded question of all. Handle it by minimizing your weakness and emphasizing your strengths. Stay away from personal qualities and concentrate on professional traits: "I am always working on improRead more
“What are your weaknesses” is one of the most popular questions interviewers ask. It is also the most dreaded question of all. Handle it by minimizing your weakness and emphasizing your strengths. Stay away from personal qualities and concentrate on professional traits: “I am always working on improving my communication skills to be a more effective presenter. I recently joined Toastmasters, which I find very helpful.”
See lessWhere Did You Hear About This Position?
While this seems like a very simple question, your answer may come with extra benefits. The employer wants to know how you found out about them, and it’s a great way to: Show that you know someone in the company if you got a referral (which means somebody who knows the company well thought you’d beRead more
While this seems like a very simple question, your answer may come with extra benefits. The employer wants to know how you found out about them, and it’s a great way to:
Think along the lines of:
How would you describe yourself?
When interviewers ask about me, I describe myself as a vigilant and proactive Security Officer who strives to ensure safe, secure, and orderly environments. I am always seeking out the latest security equipment and techniques to improve my ability to patrol buildings effectively. Additionally, I amRead more
When interviewers ask about me, I describe myself as a vigilant and proactive Security Officer who strives to ensure safe, secure, and orderly environments. I am always seeking out the latest security equipment and techniques to improve my ability to patrol buildings effectively. Additionally, I am diligent in documenting all incidents and consistently make suggestions to management about security improvements and changes based on my observations. I can provide quantifiable results to demonstrate how I have used my best attributes to drive success in the past.
See lessWhat is a surrogate key?
A surrogate key is a field in a table that has been created solely for the purpose of being the primary key. It has no other purpose than internal storage and reference number. For example, a customer may have an account number that is unique to them, but a customer_id field might be created on theRead more
A surrogate key is a field in a table that has been created solely for the purpose of being the primary key. It has no other purpose than internal storage and reference number.
For example, a customer may have an account number that is unique to them, but a customer_id field might be created on the table and used as the primary key, in case business rules change and mean that the account number is no longer unique.
See lessWhat is a composite key?
A composite key is a primary key that is made up of two or more fields. Often, primary keys are single fields, but in some cases, a row is identified by multiple fields. This is what a composite key is.
A composite key is a primary key that is made up of two or more fields. Often, primary keys are single fields, but in some cases, a row is identified by multiple fields. This is what a composite key is.
See lessWhat is a foreign key?
A foreign key is a field in a table that refers to a primary key in another table. It is used to link the record in the first table to the record in the second table.
A foreign key is a field in a table that refers to a primary key in another table. It is used to link the record in the first table to the record in the second table.
See lessWhat is a primary key?
A primary key is a column or set of columns that uniquely identifies a row in a table. It’s created on a table and ensures that the values in that column or columns must be unique and not NULL. This is often done using some kind of numeric ID field but doesn’t have to be.
A primary key is a column or set of columns that uniquely identifies a row in a table. It’s created on a table and ensures that the values in that column or columns must be unique and not NULL.
This is often done using some kind of numeric ID field but doesn’t have to be.
See lessWhat is a view? When would you use one?
A view is a database object that allows you to run a saved query to view a set of data. You create a view by specifying a SELECT query to be used as the view, and then the view can be queried just like a table. There are several reasons to use a view, such as to improve to security, create a layer oRead more
A view is a database object that allows you to run a saved query to view a set of data. You create a view by specifying a SELECT query to be used as the view, and then the view can be queried just like a table.
There are several reasons to use a view, such as to improve to security, create a layer of abstraction between the underlying tables and applications, and to simplify queries.
See lessWhat is the purpose of the IN keyword?
The IN keyword allows you to check if a value matches one of a range of values. It’s often used with subqueries that return more than one row.
The IN keyword allows you to check if a value matches one of a range of values. It’s often used with subqueries that return more than one row.
See lessWhat is the purpose of the BETWEEN keyword?
The BETWEEN keyword allows you to check that a value falls in between two other values in the WHERE clause. It’s the same as checking if a value is greater than or equal to one value, and less than or equal to another value.
The BETWEEN keyword allows you to check that a value falls in between two other values in the WHERE clause.
It’s the same as checking if a value is greater than or equal to one value, and less than or equal to another value.
See lessWhat are the different DML commands in SQL? Give a description of their purpose.
Different DML commands in SQL: SELECT: retrieve or view data from the database INSERT: add new records to a table UPDATE: change existing records in a table DELETE: removes data from a table MERGE: performs an UPSERT operation, also known as insert or update. CALL: runs a PL/SQL procedure or Java prRead more
Different DML commands in SQL:
- SELECT: retrieve or view data from the database
- INSERT: add new records to a table
- UPDATE: change existing records in a table
- DELETE: removes data from a table
- MERGE: performs an UPSERT operation, also known as insert or update.
- CALL: runs a PL/SQL procedure or Java program
- EXPLAIN PLAN: explains the way the data is loaded
- LOCK TABLE: helps control concurrency
See lessWhat are the different DDL commands in SQL? Give a description of their purpose.
Different DDL commands in SQL: CREATE: creates objects in the database ALTER: makes changes to objects in the database DROP: removes objects from the database TRUNCATE: deletes all data from a table COMMENT: adds comments to the data dictionary RENAME: renames an object in the database
Different DDL commands in SQL:
- CREATE: creates objects in the database
- ALTER: makes changes to objects in the database
- DROP: removes objects from the database
- TRUNCATE: deletes all data from a table
- COMMENT: adds comments to the data dictionary
- RENAME: renames an object in the database
See lessWhat is the difference between SQL and T-SQL?
SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result. T-SQL stands for Transact-SQL and is a language and set of extensions for SQL Server that allows for further programming logic to be used with SQL.
SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result.
T-SQL stands for Transact-SQL and is a language and set of extensions for SQL Server that allows for further programming logic to be used with SQL.
See lessWhat is the difference between SQL and PL/SQL?
SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result. PL/SQL stands for Procedural Language/Structured Query Language. It’s Oracle’s procedural language and is built on top of SQL. It allows for more programming logic to be used along with SQL.
SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result.
PL/SQL stands for Procedural Language/Structured Query Language. It’s Oracle’s procedural language and is built on top of SQL. It allows for more programming logic to be used along with SQL.
See lessWhat is the difference between SQL, Oracle, MySQL, and SQL Server?
SQL is the name of the language used to query databases and follows a standard. Oracle, MySQL, and SQL servers are different implementations or versions of a database management system, which implement the SQL standard and build on it in different ways. Oracle database is targeted at large companiesRead more
SQL is the name of the language used to query databases and follows a standard. Oracle, MySQL, and SQL servers are different implementations or versions of a database management system, which implement the SQL standard and build on it in different ways.
See lessOracle database is targeted at large companies, SQL Server is owned by Microsoft, and MySQL is owned by Oracle but targeted toward smaller companies and systems.
What Skills Does a Data Engineer Need?
Here are some common skills and expertise you’ll need in a data engineering role: Knowledge of database tools Coding Critical thinking Experience with data analysis Knowledge of data transformation, buffering, ingestion, and mining tools AI and machine learning experience Data warehousing and ETL toRead more
Here are some common skills and expertise you’ll need in a data engineering role:
- Knowledge of database tools
- Coding
- Critical thinking
- Experience with data analysis
- Knowledge of data transformation, buffering, ingestion, and mining tools
- AI and machine learning experience
- Data warehousing and ETL tools
- Real-time processing frameworks
See lessMention some of Hadoop’s key attributes.
Hadoop is a free, open-source framework whose code can be modified to suit different needs. It supports faster-distributed data processing with MapReduce. Hadoop is quite forgiving and, by default, permits the user to build three clones of each block at several nodes. Therefore, even if one of the nRead more
- Hadoop is a free, open-source framework whose code can be modified to suit different needs.
- It supports faster-distributed data processing with MapReduce.
- Hadoop is quite forgiving and, by default, permits the user to build three clones of each block at several nodes. Therefore, even if one of the nodes fails, we may still recover the data from another node.
- Scalable and hardware-neutral.
- Due to Hadoop’s cluster-based data storage, all other operations were unaffected. Thus, it is trustworthy. The failure of the machines has no impact on the data that has been stored.
See lessDescribe the fundamental idea underlying the Apache Hadoop Framework.
It is based on the MapReduce algorithm, to be precise. The Map and Reduce procedures of this technique are used to process a large data set. Reduce summaries of the data while Map filters and sorts the data. The main ideas behind this paradigm are scalability and fault tolerance. By effectively utilRead more
It is based on the MapReduce algorithm, to be precise. The Map and Reduce procedures of this technique are used to process a large data set. Reduce summaries of the data while Map filters and sorts the data. The main ideas behind this paradigm are scalability and fault tolerance. By effectively utilizing MapReduce and Multi-threading, we may successfully implement these functionalities in Apache Hadoop.
See lessHow does orchestration work?
IT firms must manage a lot of servers and apps, but doing it manually isn’t scalable. The more complicated an IT system is, the harder it is to keep track of all the moving elements. The demand to integrate several automated jobs and their configurations across groups of systems or machines is growiRead more
IT firms must manage a lot of servers and apps, but doing it manually isn’t scalable. The more complicated an IT system is, the harder it is to keep track of all the moving elements. The demand to integrate several automated jobs and their configurations across groups of systems or machines is growing, coupled with the necessity to combine such automated operations and settings. This circumstance benefits from the usage of orchestration.
A computer system, application, and service orchestration is the automated configuration, administration, and coordination of these components. Orchestration makes it easier for IT to manage challenging operations and processes. Numerous technologies for container orchestration, including Kubernetes and OpenShift, are available.
See lessHow does schema evolution work?
Schemas have advanced to the point where the same set of data can be stored in numerous files with different but compatible schemas. You can automatically identify and combine those files’ schema by using Spark's Parquet data source. A typical approach to dealing with schema evolution without automaRead more
Schemas have advanced to the point where the same set of data can be stored in numerous files with different but compatible schemas. You can automatically identify and combine those files’ schema by using Spark’s Parquet data source.
A typical approach to dealing with schema evolution without automatic schema merging is to reload historical data, which is time-consuming.
See lessAs a data engineer, how would you go about creating a new analytical product?
Understanding the overall product outline will help you fully grasp a project’s requirements and scope. The second stage would be to research each measure’s specifics and causes. Consider as many potential problems as you can to build a more resilient system with an appropriate level of granularity.
Understanding the overall product outline will help you fully grasp a project’s requirements and scope. The second stage would be to research each measure’s specifics and causes.
Consider as many potential problems as you can to build a more resilient system with an appropriate level of granularity.
See less