🚨JOB OPENING UPDATES🚨
Company- GoTo Group
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3762088074
Company- IRRI Education
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3762081948
Company- GoodSpace
Role- Data Analyst
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3757646702
Company- Deuglo Infosystem Private Limited
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3762084577
Company- Pratiti Technologies
Role- Data Scientist
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3762098257
Company- AKS ProTalent
Role- Data Analyst
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3757651098
Company- QUISCON BIOTECH
Role- Data Scientist
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3762084148
Company- SHIVA HR SERVICES
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3762097160
Company- AKS ProTalent
Role- Data Engineer
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3757647765
Company- Wednesday Solutions
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3762104002
———————————————————-
CloudyML Special Diwali Sale Is Ending Tonight @11:59PM. Visit Our Website Now & Start Your Data Science Journey
👉🏻 https://www.cloudyml.com/courses
Company- GoTo Group
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3762088074
Company- IRRI Education
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3762081948
Company- GoodSpace
Role- Data Analyst
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3757646702
Company- Deuglo Infosystem Private Limited
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3762084577
Company- Pratiti Technologies
Role- Data Scientist
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3762098257
Company- AKS ProTalent
Role- Data Analyst
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3757651098
Company- QUISCON BIOTECH
Role- Data Scientist
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3762084148
Company- SHIVA HR SERVICES
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3762097160
Company- AKS ProTalent
Role- Data Engineer
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3757647765
Company- Wednesday Solutions
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3762104002
———————————————————-
CloudyML Special Diwali Sale Is Ending Tonight @11:59PM. Visit Our Website Now & Start Your Data Science Journey
👉🏻 https://www.cloudyml.com/courses
🔥1
Media is too big
VIEW IN TELEGRAM
5 Problems, 1 Solution!
Join Our Data Science & Analytics Placement Guarantee Program
Visit Website - https://ds.cloudyml.com/
Join Our Data Science & Analytics Placement Guarantee Program
Visit Website - https://ds.cloudyml.com/
❤1
Date: 15-11-2023
Company name: Swiggy
Role: Data Analyst
Topic: Python, SQL, excel, Tableau
1. How many report formats are available in Excel?
There are three report formats available in Excel; they are:
1. Compact Form
2. Outline Form
3. Tabular Form
2. What are sets in Tableau?
Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view.
3. What is the difference between DROP and TRUNCATE commands?
DROP command removes a table and it cannot be rolled back from the database whereas TRUNCATE command removes all the rows from the table.
4. What is slicing in Python?
Ans: Slicing is used to access parts of sequences like lists, tuples, and strings. The syntax of slicing is-[start:end:step]. The step can be omitted as well. When we write [start:end] this returns all the elements of the sequence from the start (inclusive) till the end-1 element. If the start or end element is negative i, it means the ith element from the end.
5. What is the map() and filter() function in Python?
The map() function is a higher-order function. This function accepts another function and a sequence of ‘iterables’ as parameters and provides output after applying the function to each iterable in the sequence. The filter() function is used to generate an output list of values that return true when the function is called.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
Company name: Swiggy
Role: Data Analyst
Topic: Python, SQL, excel, Tableau
1. How many report formats are available in Excel?
There are three report formats available in Excel; they are:
1. Compact Form
2. Outline Form
3. Tabular Form
2. What are sets in Tableau?
Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view.
3. What is the difference between DROP and TRUNCATE commands?
DROP command removes a table and it cannot be rolled back from the database whereas TRUNCATE command removes all the rows from the table.
4. What is slicing in Python?
Ans: Slicing is used to access parts of sequences like lists, tuples, and strings. The syntax of slicing is-[start:end:step]. The step can be omitted as well. When we write [start:end] this returns all the elements of the sequence from the start (inclusive) till the end-1 element. If the start or end element is negative i, it means the ith element from the end.
5. What is the map() and filter() function in Python?
The map() function is a higher-order function. This function accepts another function and a sequence of ‘iterables’ as parameters and provides output after applying the function to each iterable in the sequence. The filter() function is used to generate an output list of values that return true when the function is called.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
❤3🤩1🆒1
🚨Companies are #Hiring for Interns & Full-Time Freshers (Data Scientist and Data Analyst Roles are available).
Check Out My LinkedIn Post Now
👉🏻 https://www.linkedin.com/posts/akashraj001_hiring-datascience-jobopenings-activity-7130491594671079424-ojuV?utm_source=share&utm_medium=member_desktop
Check Out My LinkedIn Post Now
👉🏻 https://www.linkedin.com/posts/akashraj001_hiring-datascience-jobopenings-activity-7130491594671079424-ojuV?utm_source=share&utm_medium=member_desktop
🤩5
Date: 17-11-2023
Company name: Hitachi
Role: SQL Developer
Topic: subsets, Pattern, Relationship, Stored Procedure
1. What are the different subsets of SQL?
Data Definition Language (DDL) – It allows you to perform various operations on the database such as CREATE, ALTER, and DELETE objects.
Data Manipulation Language(DML) – It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.
Data Control Language(DCL) – It allows you to control access to the database. Example – Grant, Revoke access permissions.
2. List the different types of relationships in SQL.
There are different types of relations in the database:
One-to-One – This is a connection between two tables in which each record in one table corresponds to the maximum of one record in the other.
One-to-Many and Many-to-One – This is the most frequent connection, in which a record in one table is linked to several records in another.
Many-to-Many – This is used when defining a relationship that requires several instances on each sides.
Self-Referencing Relationships – When a table has to declare a connection with itself, this is the method to employ.
3. What is a Stored Procedure?
A stored procedure is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database data dictionary. The sole disadvantage of stored procedure is that it can be executed nowhere except in the database and occupies more memory in the database server.
4. What is Pattern Matching in SQL?
SQL pattern matching provides for pattern search in data if you have no clue as to what that word should be. This kind of SQL query uses wildcards to match a string pattern, rather than writing the exact word. The LIKE operator is used in conjunction with SQL Wildcards to fetch the required information.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
Company name: Hitachi
Role: SQL Developer
Topic: subsets, Pattern, Relationship, Stored Procedure
1. What are the different subsets of SQL?
Data Definition Language (DDL) – It allows you to perform various operations on the database such as CREATE, ALTER, and DELETE objects.
Data Manipulation Language(DML) – It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.
Data Control Language(DCL) – It allows you to control access to the database. Example – Grant, Revoke access permissions.
2. List the different types of relationships in SQL.
There are different types of relations in the database:
One-to-One – This is a connection between two tables in which each record in one table corresponds to the maximum of one record in the other.
One-to-Many and Many-to-One – This is the most frequent connection, in which a record in one table is linked to several records in another.
Many-to-Many – This is used when defining a relationship that requires several instances on each sides.
Self-Referencing Relationships – When a table has to declare a connection with itself, this is the method to employ.
3. What is a Stored Procedure?
A stored procedure is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database data dictionary. The sole disadvantage of stored procedure is that it can be executed nowhere except in the database and occupies more memory in the database server.
4. What is Pattern Matching in SQL?
SQL pattern matching provides for pattern search in data if you have no clue as to what that word should be. This kind of SQL query uses wildcards to match a string pattern, rather than writing the exact word. The LIKE operator is used in conjunction with SQL Wildcards to fetch the required information.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
❤2
🚨JOB OPENING UPDATE🚨
Company- AKS ProTalent
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3762640028
Company- Genpact
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3622421599
Company- Forward Eye Technologies
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3762634801
Company- Truelancer.com
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3769110076
Company- Russell Investments
Role- Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3761484566
Company- Prudential plc
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3750262628
Company- AMS
Role- Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767413062
Company- Virtusa
Role- Data Analyst
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3766423041
Company- RealPage, Inc.
Role- Data Analyst
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3650427360
Company- Pinnacle
Role- Data Analyst
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3768665803
ALL THE BEST💙
Company- AKS ProTalent
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3762640028
Company- Genpact
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3622421599
Company- Forward Eye Technologies
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3762634801
Company- Truelancer.com
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3769110076
Company- Russell Investments
Role- Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3761484566
Company- Prudential plc
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3750262628
Company- AMS
Role- Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767413062
Company- Virtusa
Role- Data Analyst
Experience- 1year
Apply now- https://www.linkedin.com/jobs/view/3766423041
Company- RealPage, Inc.
Role- Data Analyst
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3650427360
Company- Pinnacle
Role- Data Analyst
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3768665803
ALL THE BEST💙
🆒11
Date: 20-11-2023
Company: Tiger Analytics
Role - Data Scientist
Topics - Predictive Modeling, Clustering, Time Series Forecasting, ML Deployment, Ensemble Learning
1. How would you handle imbalanced datasets when building a predictive model, and what techniques would you use to ensure model performance?
Answer: When dealing with imbalanced datasets, techniques like oversampling the minority class, undersampling the majority class, or using advanced methods like SMOTE can be employed. Additionally, adjusting class weights in the model or using ensemble techniques like RandomForest can address imbalanced data challenges.
2. Explain the K-means clustering algorithm and its applications. How would you determine the optimal number of clusters?
Answer: The K-means clustering algorithm partitions data into 'K' clusters based on similarity. The optimal 'K' can be determined using methods like the Elbow Method or Silhouette Score. Applications include customer segmentation, anomaly detection, and image compression.
3.Describe a scenario where you successfully applied time series forecasting to solve a business problem. What methods did you use?
Answer: In time series forecasting, one would start with data exploration, identify seasonality and trends, and use techniques like ARIMA, Exponential Smoothing, or LSTM for modeling. Evaluation metrics like MAE, RMSE, or MAPE help assess forecasting accuracy.
4. Discuss the challenges and considerations involved in deploying machine learning models to a production environment.
Answer: Model deployment involves converting a trained model into a format suitable for production, using frameworks like Flask or Docker. Deployment considerations include scalability, monitoring, and version control. Tools like Kubernetes can aid in managing deployed models.
5. Explain the concept of ensemble learning, and how might ensemble methods improve the robustness of a predictive model?
Answer: Ensemble learning combines multiple models to enhance predictive performance. Examples include Random Forests and Gradient Boosting. Ensemble methods reduce overfitting, increase model robustness, and capture diverse patterns in the data.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
Company: Tiger Analytics
Role - Data Scientist
Topics - Predictive Modeling, Clustering, Time Series Forecasting, ML Deployment, Ensemble Learning
1. How would you handle imbalanced datasets when building a predictive model, and what techniques would you use to ensure model performance?
Answer: When dealing with imbalanced datasets, techniques like oversampling the minority class, undersampling the majority class, or using advanced methods like SMOTE can be employed. Additionally, adjusting class weights in the model or using ensemble techniques like RandomForest can address imbalanced data challenges.
2. Explain the K-means clustering algorithm and its applications. How would you determine the optimal number of clusters?
Answer: The K-means clustering algorithm partitions data into 'K' clusters based on similarity. The optimal 'K' can be determined using methods like the Elbow Method or Silhouette Score. Applications include customer segmentation, anomaly detection, and image compression.
3.Describe a scenario where you successfully applied time series forecasting to solve a business problem. What methods did you use?
Answer: In time series forecasting, one would start with data exploration, identify seasonality and trends, and use techniques like ARIMA, Exponential Smoothing, or LSTM for modeling. Evaluation metrics like MAE, RMSE, or MAPE help assess forecasting accuracy.
4. Discuss the challenges and considerations involved in deploying machine learning models to a production environment.
Answer: Model deployment involves converting a trained model into a format suitable for production, using frameworks like Flask or Docker. Deployment considerations include scalability, monitoring, and version control. Tools like Kubernetes can aid in managing deployed models.
5. Explain the concept of ensemble learning, and how might ensemble methods improve the robustness of a predictive model?
Answer: Ensemble learning combines multiple models to enhance predictive performance. Examples include Random Forests and Gradient Boosting. Ensemble methods reduce overfitting, increase model robustness, and capture diverse patterns in the data.
————————————————————
Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price & get 100% Placement🤩
Visit 👉🏻 https://www.cloudyml.com/
Stay Safe & Happy Learning💙
❤2👏2
🚨JOB OPENING UPDATE🚨
Company- The Economist
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3742862518
Company- IDFC FIRST Bank
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3768142089
Company- TwiLearn
Role- Data Science Intern
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3765412914
Company- SLK
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3770298130
Company- NielsenIQ
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3766730504
Company- Maistering B.V.
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3765414279
Company- Onehouse
Role- Data Engineer
Experience- 2+years
Apply now- https://www.linkedin.com/jobs/view/3658575044
Company- ARDEM Incorporated
Role- Data Analyst
Experience- 6 months
Apply now- https://www.linkedin.com/jobs/view/3765417909
Company- Pinnacle
Role- Data Analyst
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3768665803
Company- Addepar
Role- Data Analyst
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3733982339
ALL THE BEST💙
Company- The Economist
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3742862518
Company- IDFC FIRST Bank
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3768142089
Company- TwiLearn
Role- Data Science Intern
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3765412914
Company- SLK
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3770298130
Company- NielsenIQ
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3766730504
Company- Maistering B.V.
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3765414279
Company- Onehouse
Role- Data Engineer
Experience- 2+years
Apply now- https://www.linkedin.com/jobs/view/3658575044
Company- ARDEM Incorporated
Role- Data Analyst
Experience- 6 months
Apply now- https://www.linkedin.com/jobs/view/3765417909
Company- Pinnacle
Role- Data Analyst
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3768665803
Company- Addepar
Role- Data Analyst
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3733982339
ALL THE BEST💙
❤6🤩1
Date: 21-11-2023
Company: Amazon
Role - Business Analyst
Topics - SQL, Pandas, MS Excel
1. Write a SQL query to fetch the department name (Dept_Name) which has the second-highest average salary from the Employee table.
Answer:
SELECT Dept_Name
FROM Department
WHERE Dept_id = (
SELECT Dept_id
FROM (
SELECT Dept_id, AVG(Salary) AS avg_salary
FROM Employee
GROUP BY Dept_id
ORDER BY avg_salary DESC
LIMIT 2
) AS subquery
ORDER BY avg_salary ASC
LIMIT 1
);
2. Explain the usage of the `groupby` function in pandas with a practical example.
Answer: Example: Grouping data by 'Category' and calculating the mean of 'Value'
grouped_data = df.groupby('Category')['Value'].mean()
3. Write a Python code using pandas to achieve the same result as the first SQL question (fetching the department name with the second-highest average salary).
Answer: Assuming df_employee is the DataFrame for the Employee table
second_highest_dept = df_employee.groupby('Dept_id')['Salary'].mean().nlargest(2).index[-1]
dept_name_result = df_department.loc[df_department['Dept_id'] == second_highest_dept, 'Dept_Name'].values[0]
4. Write a formula to calculate the sum of values based on multiple criteria using SUMIFS.
Answer: =SUMIFS(SumRange, CriteriaRange1, Criteria1, CriteriaRange2, Criteria2)
Company: Amazon
Role - Business Analyst
Topics - SQL, Pandas, MS Excel
1. Write a SQL query to fetch the department name (Dept_Name) which has the second-highest average salary from the Employee table.
Answer:
SELECT Dept_Name
FROM Department
WHERE Dept_id = (
SELECT Dept_id
FROM (
SELECT Dept_id, AVG(Salary) AS avg_salary
FROM Employee
GROUP BY Dept_id
ORDER BY avg_salary DESC
LIMIT 2
) AS subquery
ORDER BY avg_salary ASC
LIMIT 1
);
2. Explain the usage of the `groupby` function in pandas with a practical example.
Answer: Example: Grouping data by 'Category' and calculating the mean of 'Value'
grouped_data = df.groupby('Category')['Value'].mean()
3. Write a Python code using pandas to achieve the same result as the first SQL question (fetching the department name with the second-highest average salary).
Answer: Assuming df_employee is the DataFrame for the Employee table
second_highest_dept = df_employee.groupby('Dept_id')['Salary'].mean().nlargest(2).index[-1]
dept_name_result = df_department.loc[df_department['Dept_id'] == second_highest_dept, 'Dept_Name'].values[0]
4. Write a formula to calculate the sum of values based on multiple criteria using SUMIFS.
Answer: =SUMIFS(SumRange, CriteriaRange1, Criteria1, CriteriaRange2, Criteria2)
🆒21👏8❤6
No Need To Pay Lakhs Of Rupees, Make Your Career In Data Science @ Most Affordable Price.
Apply Now👉🏻 https://ds.cloudyml.com/
Apply Now👉🏻 https://ds.cloudyml.com/
🚨JOB OPENING UPDATE🚨
Company- Meesho
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764318068
Company- AKS ProTalent
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3764379087
Company- Jabil
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3771369861
Company- People Tech Group Inc
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764379678
Company- ExxonMobil
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3480089643
Company- Crossover
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3766613032
Company- AstraZeneca
Role- Data Analyst
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3735044361
Company- Genpact
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3771016145
Company- BCG X
Role- Data Analyst
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764306524
Company- Allianz Services
Role- Sr. Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3771541963
ALL THE BEST💙
Company- Meesho
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764318068
Company- AKS ProTalent
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3764379087
Company- Jabil
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3771369861
Company- People Tech Group Inc
Role- Data Scientist
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764379678
Company- ExxonMobil
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3480089643
Company- Crossover
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3766613032
Company- AstraZeneca
Role- Data Analyst
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3735044361
Company- Genpact
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3771016145
Company- BCG X
Role- Data Analyst
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3764306524
Company- Allianz Services
Role- Sr. Data Engineer
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3771541963
ALL THE BEST💙
❤2🤩1
Date: 23-11-2023
Company: Google
Role - Data Scientist
Topics - Machine Learning, Algorithms, Statistics, Data Analysis
1. Explain the concept of transfer learning in the context of deep learning models. How can it be beneficial in practical applications?
Ans- Transfer learning involves leveraging pre-trained models on large datasets and adapting them to new, related tasks with smaller datasets. In deep learning, this is achieved by reusing the knowledge gained during the training of one model on a different, but related, task. This is particularly beneficial when the new task has limited labeled data.
Practical applications include image recognition, where a model pre-trained on a dataset like ImageNet can be fine-tuned for a specific domain. Transfer learning accelerates model convergence, requires less labeled data, and helps overcome the challenges of training deep neural networks from scratch.
2. Given a large dataset, how would you efficiently sample a representative subset for model training? Discuss the trade-offs involved.
Answer- To efficiently sample a representative subset, one can use techniques like random sampling or stratified sampling. For random sampling, simple random sampling or systematic sampling methods can be employed. For stratified sampling, data is divided into strata, and samples are randomly selected from each stratum.
Trade-offs involve the choice between biased and unbiased sampling. Random sampling may not capture rare events, while stratified sampling might introduce complexity but ensures representation. The size of the sample is also crucial; a too-small sample may not be representative, while a too-large sample may incur unnecessary computational costs.
3. How would you approach analyzing A/B test results to determine the effectiveness of a new feature on a platform like Google Search?
Answer: A/B testing involves comparing the performance of two versions (A and B) to determine the impact of a change. To analyze A/B test results:
- Define Metrics: Clearly define key metrics (e.g., click-through rate, user engagement) before the test.
- Random Assignment: Ensure random assignment of users to control (A) and experimental (B) groups.
- Statistical Significance: Use statistical tests (e.g., t-test) to determine if differences between groups are statistically significant.
- Practical Significance: Consider the practical significance of results to assess real-world impact.
- Segmentation: Analyze results across different user segments for nuanced insights.
4. You have access to search query logs. How would you identify and address potential biases in the search results?
Answer: To identify and address biases in search results:
- Analyze Demographics: Examine user demographics to identify biases related to age, gender, or location.
- Query Intent: Understand user query intent and ensure diverse queries are well-represented.
- Evaluate Results: Assess the diversity of results to avoid favoring specific perspectives.
- User Feedback: Gather feedback from users to identify biased or inappropriate results.
- Continuous Monitoring: Implement continuous monitoring and iterate on algorithms to minimize biases.
Company: Google
Role - Data Scientist
Topics - Machine Learning, Algorithms, Statistics, Data Analysis
1. Explain the concept of transfer learning in the context of deep learning models. How can it be beneficial in practical applications?
Ans- Transfer learning involves leveraging pre-trained models on large datasets and adapting them to new, related tasks with smaller datasets. In deep learning, this is achieved by reusing the knowledge gained during the training of one model on a different, but related, task. This is particularly beneficial when the new task has limited labeled data.
Practical applications include image recognition, where a model pre-trained on a dataset like ImageNet can be fine-tuned for a specific domain. Transfer learning accelerates model convergence, requires less labeled data, and helps overcome the challenges of training deep neural networks from scratch.
2. Given a large dataset, how would you efficiently sample a representative subset for model training? Discuss the trade-offs involved.
Answer- To efficiently sample a representative subset, one can use techniques like random sampling or stratified sampling. For random sampling, simple random sampling or systematic sampling methods can be employed. For stratified sampling, data is divided into strata, and samples are randomly selected from each stratum.
Trade-offs involve the choice between biased and unbiased sampling. Random sampling may not capture rare events, while stratified sampling might introduce complexity but ensures representation. The size of the sample is also crucial; a too-small sample may not be representative, while a too-large sample may incur unnecessary computational costs.
3. How would you approach analyzing A/B test results to determine the effectiveness of a new feature on a platform like Google Search?
Answer: A/B testing involves comparing the performance of two versions (A and B) to determine the impact of a change. To analyze A/B test results:
- Define Metrics: Clearly define key metrics (e.g., click-through rate, user engagement) before the test.
- Random Assignment: Ensure random assignment of users to control (A) and experimental (B) groups.
- Statistical Significance: Use statistical tests (e.g., t-test) to determine if differences between groups are statistically significant.
- Practical Significance: Consider the practical significance of results to assess real-world impact.
- Segmentation: Analyze results across different user segments for nuanced insights.
4. You have access to search query logs. How would you identify and address potential biases in the search results?
Answer: To identify and address biases in search results:
- Analyze Demographics: Examine user demographics to identify biases related to age, gender, or location.
- Query Intent: Understand user query intent and ensure diverse queries are well-represented.
- Evaluate Results: Assess the diversity of results to avoid favoring specific perspectives.
- User Feedback: Gather feedback from users to identify biased or inappropriate results.
- Continuous Monitoring: Implement continuous monitoring and iterate on algorithms to minimize biases.
❤6👏1
🚨JOB OPENING UPDATE🚨
Company- Virtusa
Role- Data Engineer
Experience- 1-2 years
Apply now- https://www.linkedin.com/jobs/view/3771990483
Company- Angel One
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3767398067
Company- Crossover
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3766356640
Company- LTIMindtree
Role- Data Engineer
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3764386930
Company- Trane Technologies
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3748176877
Company- Infosys
Role- Data Engineer
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3755979167
Company- bp
Role- Sr. Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3771889370
Company- Jade Global
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3748104320
Company- Honeywell
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767373265
Company- Pinnacle
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3768665803
ALL THE BEST💙
Company- Virtusa
Role- Data Engineer
Experience- 1-2 years
Apply now- https://www.linkedin.com/jobs/view/3771990483
Company- Angel One
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3767398067
Company- Crossover
Role- Data Scientist
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3766356640
Company- LTIMindtree
Role- Data Engineer
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3764386930
Company- Trane Technologies
Role- Data Scientist
Experience- 3 years
Apply now- https://www.linkedin.com/jobs/view/3748176877
Company- Infosys
Role- Data Engineer
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3755979167
Company- bp
Role- Sr. Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3771889370
Company- Jade Global
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3748104320
Company- Honeywell
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767373265
Company- Pinnacle
Role- Data Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3768665803
ALL THE BEST💙
🤩9❤3
Date: 26-11-2023
Company: Microsoft
Role - Data Scientist
Topics - SQL, Machine Learning, NLP, Neural Networks
1. Write a SQL query to find the top three products with the highest revenue in the last quarter from a sales database.
Answer: A SQL query to find the top three products with the highest revenue in the last quarter:
-
2. Explain the concept of ensemble learning and provide examples of scenarios where ensemble methods could be beneficial.
Answer: Ensemble learning involves combining multiple models to improve overall performance. Examples include Random Forests, Gradient Boosting, and AdaBoost. Ensemble methods are beneficial when dealing with noisy data, reducing overfitting, and enhancing model robustness by capturing diverse patterns in the data.
3. How would you build a language translation system using Microsoft's Cognitive Services or other NLP tools?
Answer: To build a language translation system, I would use Azure Cognitive Services' Translator API. By sending text to the API, it provides translated content. Preprocess text, send requests to the API, and handle responses. Azure Cognitive Services also supports neural machine translation for improved accuracy.
4. Explain the concept of transfer learning in the context of deep neural networks. How can transfer learning be applied to tasks like image classification?
Answer: Transfer learning involves using a pre-trained model on a related task to improve performance on a new task. For image classification, a pre-trained Convolutional Neural Network (CNN) can be fine-tuned on a specific dataset, saving training time and leveraging learned features.
Company: Microsoft
Role - Data Scientist
Topics - SQL, Machine Learning, NLP, Neural Networks
1. Write a SQL query to find the top three products with the highest revenue in the last quarter from a sales database.
Answer: A SQL query to find the top three products with the highest revenue in the last quarter:
SELECT TOP 3 ProductID, SUM(Revenue) AS TotalRevenue
FROM Sales
WHERE OrderDate >= DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) - 1, 0)
GROUP BY ProductID
ORDER BY TotalRevenue DESC;
-
2. Explain the concept of ensemble learning and provide examples of scenarios where ensemble methods could be beneficial.
Answer: Ensemble learning involves combining multiple models to improve overall performance. Examples include Random Forests, Gradient Boosting, and AdaBoost. Ensemble methods are beneficial when dealing with noisy data, reducing overfitting, and enhancing model robustness by capturing diverse patterns in the data.
3. How would you build a language translation system using Microsoft's Cognitive Services or other NLP tools?
Answer: To build a language translation system, I would use Azure Cognitive Services' Translator API. By sending text to the API, it provides translated content. Preprocess text, send requests to the API, and handle responses. Azure Cognitive Services also supports neural machine translation for improved accuracy.
4. Explain the concept of transfer learning in the context of deep neural networks. How can transfer learning be applied to tasks like image classification?
Answer: Transfer learning involves using a pre-trained model on a related task to improve performance on a new task. For image classification, a pre-trained Convolutional Neural Network (CNN) can be fine-tuned on a specific dataset, saving training time and leveraging learned features.
❤5🆒5
🚨Companies Are #Hiring For #Interns and Full-Time #Freshers and Experienced Candidates for Data Analyst Role. APPLY NOW⬇️
Company: Cadila Zydus Healthcare Ltd
Role: Data Analyst
Exp: 0-1 Years
Apply Now: https://www.linkedin.com/jobs/view/3768554238
Company: Turing
Role: Data Analyst
Exp: Freshers
Apply Now: https://www.linkedin.com/jobs/view/3742067842
Company: Tiger Analytics
Role: Senior Analyst-Data Science
Exp: 2+ Years
Apply Now: https://www.linkedin.com/jobs/view/3746382122
Company: Maruti Suzuki India Limited
Role: Data Analyst - R&D
Exp: 1+Years
Apply Now: https://www.linkedin.com/jobs/view/3674500546
Company: HCDS Technologies
Role: Data Analysis
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3772760041
Company: MiStay - India's Largest Hourly Hotels
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761411694
Company: Vivriti Capital
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761567330
Company: Trexquant Investment LP
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3677952236
Company: KLA
Role: AI/ML Intern
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3751492721
Company: UM IT Services & Consulting
Role: Data Analytical
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3768916829
ALL THE BEST💙
Company: Cadila Zydus Healthcare Ltd
Role: Data Analyst
Exp: 0-1 Years
Apply Now: https://www.linkedin.com/jobs/view/3768554238
Company: Turing
Role: Data Analyst
Exp: Freshers
Apply Now: https://www.linkedin.com/jobs/view/3742067842
Company: Tiger Analytics
Role: Senior Analyst-Data Science
Exp: 2+ Years
Apply Now: https://www.linkedin.com/jobs/view/3746382122
Company: Maruti Suzuki India Limited
Role: Data Analyst - R&D
Exp: 1+Years
Apply Now: https://www.linkedin.com/jobs/view/3674500546
Company: HCDS Technologies
Role: Data Analysis
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3772760041
Company: MiStay - India's Largest Hourly Hotels
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761411694
Company: Vivriti Capital
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3761567330
Company: Trexquant Investment LP
Role: Data Analyst
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3677952236
Company: KLA
Role: AI/ML Intern
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3751492721
Company: UM IT Services & Consulting
Role: Data Analytical
Exp: Internship
Apply Now: https://www.linkedin.com/jobs/view/3768916829
ALL THE BEST💙
🤩8❤3
Date: 27-11-2023
Company: Twitter
Role - Data Scientist
Topics - Natural Language Processing, Recommendation Systems, Python, Graph Analysis
1: How would you preprocess and tokenize text data from tweets for sentiment analysis? Discuss potential challenges and solutions.
- Answer: Preprocessing and tokenizing text data for sentiment analysis involves tasks like lowercasing, removing stop words, and stemming or lemmatization. Handling challenges like handling emojis, slang, and noisy text is crucial. Tools like NLTK or spaCy can assist in these tasks.
2: Explain the collaborative filtering approach in building recommendation systems. How might Twitter use this to enhance user experience?
- Answer: Collaborative filtering recommends items based on user preferences and similarities. Techniques include user-based or item-based collaborative filtering and matrix factorization. Twitter could leverage user interactions to recommend tweets, users, or topics.
3: Write a Python or Scala function to count the frequency of hashtags in a given collection of tweets.
- Answer (Python):
4: How does graph analysis contribute to understanding user interactions and content propagation on Twitter? Provide a specific use case.
- Answer: Graph analysis on Twitter involves examining user interactions. For instance, identifying influential users or detecting communities based on retweet or mention networks. Algorithms like PageRank or Louvain Modularity can aid in these analyses.
Company: Twitter
Role - Data Scientist
Topics - Natural Language Processing, Recommendation Systems, Python, Graph Analysis
1: How would you preprocess and tokenize text data from tweets for sentiment analysis? Discuss potential challenges and solutions.
- Answer: Preprocessing and tokenizing text data for sentiment analysis involves tasks like lowercasing, removing stop words, and stemming or lemmatization. Handling challenges like handling emojis, slang, and noisy text is crucial. Tools like NLTK or spaCy can assist in these tasks.
2: Explain the collaborative filtering approach in building recommendation systems. How might Twitter use this to enhance user experience?
- Answer: Collaborative filtering recommends items based on user preferences and similarities. Techniques include user-based or item-based collaborative filtering and matrix factorization. Twitter could leverage user interactions to recommend tweets, users, or topics.
3: Write a Python or Scala function to count the frequency of hashtags in a given collection of tweets.
- Answer (Python):
def count_hashtags(tweet_collection):
hashtags_count = {}
for tweet in tweet_collection:
hashtags = [word for word in tweet.split() if word.startswith('#')]
for hashtag in hashtags:
hashtags_count[hashtag] = hashtags_count.get(hashtag, 0) + 1
return hashtags_count
4: How does graph analysis contribute to understanding user interactions and content propagation on Twitter? Provide a specific use case.
- Answer: Graph analysis on Twitter involves examining user interactions. For instance, identifying influential users or detecting communities based on retweet or mention networks. Algorithms like PageRank or Louvain Modularity can aid in these analyses.
🔥16
Learn Complete SQL for Data Analytics In 3 Hours From Our YouTube Channel. Link below
Watch Now - https://youtu.be/Y5JfSb36Or0?si=zYVHi6EX_J2dtr8V
Stay Safe & Happy Learning💙
Watch Now - https://youtu.be/Y5JfSb36Or0?si=zYVHi6EX_J2dtr8V
Stay Safe & Happy Learning💙
❤21🤩1🆒1
🚨LATEST JOB OPENING UPDATE🚨
Company- UST
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3773671819
Company- METRO Global Solution Center IN
Role- Data Engineer
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3766943058
Company- Yoga Bar
Role- Business Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3741684367
Company- L&T Technology Services
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767553599
Company- Codemonk
Role- Business Analyst Intern
Experience- Fresher
Apply Now - https://www.linkedin.com/jobs/view/3767876342
Company- ITC Infotech
Role- Data Engineer
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3773778604
Company- Lendingkart
Role- Data Analyst
Experience- 1-3 years
Apply now- https://www.linkedin.com/jobs/view/3767560023
Company- Razorpay
Role- Data Analyst
Experience- 1+ Years
Apply now- https://www.linkedin.com/jobs/view/3772441614
Company- PGP Glass Pvt. Ltd.
Role- Data Engineer
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3774476036
Company- OLX Autos
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3751251624
Company- Microsoft
Role- Data Engineer
Experience- 2+ year
Apply now- https://jobs.careers.microsoft.com/us/en/job/1659193/Data-Engineer-2?
Company- dunnhumby
Role- Data Science Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3769226004
Company- Railroad19
Role- Data Engineer
Experience- 3+ years
Apply now- https://www.linkedin.com/jobs/view/3767513683
ALL THE BEST💙
Company- UST
Role- Data Scientist
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3773671819
Company- METRO Global Solution Center IN
Role- Data Engineer
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3766943058
Company- Yoga Bar
Role- Business Analyst
Experience- Fresher
Apply now- https://www.linkedin.com/jobs/view/3741684367
Company- L&T Technology Services
Role- Data Scientist
Experience- 1 year
Apply now- https://www.linkedin.com/jobs/view/3767553599
Company- Codemonk
Role- Business Analyst Intern
Experience- Fresher
Apply Now - https://www.linkedin.com/jobs/view/3767876342
Company- ITC Infotech
Role- Data Engineer
Experience- 1+ years
Apply now- https://www.linkedin.com/jobs/view/3773778604
Company- Lendingkart
Role- Data Analyst
Experience- 1-3 years
Apply now- https://www.linkedin.com/jobs/view/3767560023
Company- Razorpay
Role- Data Analyst
Experience- 1+ Years
Apply now- https://www.linkedin.com/jobs/view/3772441614
Company- PGP Glass Pvt. Ltd.
Role- Data Engineer
Experience- 2+ years
Apply now- https://www.linkedin.com/jobs/view/3774476036
Company- OLX Autos
Role- Data Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3751251624
Company- Microsoft
Role- Data Engineer
Experience- 2+ year
Apply now- https://jobs.careers.microsoft.com/us/en/job/1659193/Data-Engineer-2?
Company- dunnhumby
Role- Data Science Engineer
Experience- 2 years
Apply now- https://www.linkedin.com/jobs/view/3769226004
Company- Railroad19
Role- Data Engineer
Experience- 3+ years
Apply now- https://www.linkedin.com/jobs/view/3767513683
ALL THE BEST💙
❤4🤩1🙏1
Wanna Learn #PowerBi For Data Analysis In #Hindi ?
Now you have a complete video on our YouTube Channel🤩
Watch Now👉🏻 https://www.youtube.com/watch?v=fGsl2kMzNPg
Do share this video and subscribe to our YouTube Channel
Stay Safe & Happy Learning💙
Now you have a complete video on our YouTube Channel🤩
Watch Now👉🏻 https://www.youtube.com/watch?v=fGsl2kMzNPg
Do share this video and subscribe to our YouTube Channel
Stay Safe & Happy Learning💙
❤8🙏3🤩2