Best tips to refine your resume in 2023
👇👇
https://www.linkedin.com/posts/sql-analysts_best-tips-to-refine-your-resume-in-2023-activity-7116293653236527104-HrJJ?utm_source=share&utm_medium=member_android

Insights on the Current Job Market

It's no secret, folks. OFFCAMPUS hirings are dwindling this year, and it's causing some serious ripples. Last year, the scenario was quite different, but now, it's a whole new ball game.

🔍 Companies are leaning towards on-campus hires, leaving OFFCAMPUS opportunities limited. No Microsoft Engage this year, which is a bit of a letdown.

📉 Even on campus, companies are playing it cautious with headcounts. Last year, Amazon scooped up an average of 20-30 students from top-notch colleges. This year, the story's different.

📜 Pre-Placement Offers (PPOs) are scarcer. Big tech players aren't extending them to everyone, even with glowing feedback.

🗓 Joining dates for 2023 grads have been pushed, giving 2024 grads a run for their money. The market's teeming with talent, and companies are preferring the ones ready to hit the ground running.

📚 With the rise of edtech and heightened student expectations, competition is fierce. Some score multiple offers, while others face a dry spell. Inequality is on the rise.

💡 For the graduating class, here's my take: don't let the stress get to you. This wave is hitting everyone, even the mighty IITs and NITs. Expand your skill set. If you're a DSA whiz, dabble in development and master it.

⏳ You've got time. Use it wisely. Your placement is on the horizon, whether it's immediate or a bit down the road.

🚀 Focus on development. Target promising startups. Secure a position, and in a year or so, reassess the landscape. The market's bound to bounce back.

🛠 Freelance projects? Definitely worth considering. They not only offer a solid backup but also let you create something with your own stamp on it.

Remember, be proactive, diversify your skills, and most importantly, look after your well-being. Your health is your greatest asset. 💪🌟

Important topics of Object Oriented Programming System

1. Classes and Objects:
-> Basics of defining classes and creating objects.
-> Class members: attributes (properties) and methods (functions).

2. Inheritance:
-> Creating a new class by inheriting properties and methods from an existing class.
-> Superclasses (base classes) and subclasses (derived classes).

3. Polymorphism:
-> Ability to take multiple forms.
-> Method overriding and method overloading.

4. Encapsulation:
-> Hiding the internal details of a class and providing a controlled interface.
-> Access modifiers: public, private, protected.

5. Abstraction:
-> Simplifying complex reality by modeling classes based on real-world entities.
-> Abstract classes and interfaces.

6. Constructors and Destructors:
-> Special methods for initializing and cleaning up objects.
-> Constructor overloading.

7. Method Access and Modifiers:
-> Public, private, protected, and package-private access modifiers.
-> Static methods and variables.

A few advanced topics :-

Composition and Aggregation:
Combining objects to create more complex structures.
Has-a and Is-a relationships.

Object Relationships:
Association, aggregation, and composition.
One-to-one, one-to-many, and many-to-many relationships.

Interfaces:
Defining contracts that classes must adhere to.
Multiple interface implementation.

Polymorphic Behavior:
Achieving flexibility through polymorphism.
Method overriding and dynamic method binding.

Inheritance vs. Composition:
Comparing and choosing between inheritance and object composition.

Design Patterns:
Common solutions to recurring design problems.
Examples: Singleton, Factory, Observer, etc.

Exception Handling:
Handling errors and exceptions gracefully in OOP.
Try-catch blocks.

Object Serialization:
Converting objects into a format suitable for storage or transmission.
Reading and writing objects to/from files.

Garbage Collection:
Automatic memory management to reclaim unused memory.
Mark and sweep, reference counting, and generations.

UML (Unified Modeling Language):
A visual language for modeling software systems.
Class diagrams, sequence diagrams, and use cases.

Method Overriding vs. Method Overloading:
Understanding the differences between these two concepts.

Abstract Classes vs. Interfaces:
Comparing and contrasting abstract classes and interfaces in OOP.

Encapsulation Benefits:
Discussing the advantages of encapsulation, such as data protection and code organization.

P.S - These are just the name of topics which you should be aware of. You can get enough articles on every topic just on a Google search.

Common CyberSecurity Careers

https://t.me/EthicalHackingToday/495

Top 15 #AI websites for #Interview Preparations for #Jobseekers!

1) Huru.ai
AI-powered interview prep with tailored questions.

2) Talkberry.ai
Language learning with simulated English job interviews.

3) Interviewigniter.com
AI roleplay simulations for post-interview evaluations.

4) AI Mock Interview - (Sqlpad.io)
Tailored interview practice with personalized feedback.

5) Rightjoin.co
Customized mock interviews based on resumes and job postings.

6) Interviewsby.ai
Custom mock interviews with real-time voice feedback.

7) Jobinterview-ai.com
Real-time AI-assisted English interview practice.

8) Interview Coach
AI-generated job-specific interview questions and guidance.

9) InterviewGPT.ai
AI-powered practice sessions and personalized feedback.

10) Interviewai.me
AI-generated personalized cover letters and interview questions.

11) Interviewprep-ai.com
Streamlined CV integration and customized interview practice.

12) Interview warmup (grow.google)
Practice platform for answering interview questions with transcription.

13) Metaview.ai
Interview Notes

14) Applyish.com
Apply Automatically

15) Hnresumetojobs.com
Resume to jobs

16) Matchthaoleai.com
Job search

Job trends for software developers in the next 5 years:

[1] Most startups are starting to realize that they need to control profits, not just revenues. Many unicorns who were on track to their IPO had to delay their IPOs due to lack of profitability.

For software developers: This means that startups may be less likely to offer high salaries to attract new talent. However, it also means that startups are becoming more focused on profitability, which is a good thing for the industry in the long term.

[2] All smart CEOs have started to focus on their personal brands. This is evident on LinkedIn as well. People like to buy from people, not from companies. Therefore, almost every 'Shark' now feature on their own advertisement. Why? Personal brand.

Take a cue and start cultivating your personal brand as well.

For software developers: Building a personal brand is a great way to attract new job opportunities and build a following. You can do this by writing blog posts, creating videos, or speaking at industry events.

[3] Gone are the days when you could depend on 1 job. Firms are not loyal to you. And, any smart employee can see through this. If you are not building backups already, you are doing yourself a disservice. And, the volatile job market is might one day hit you badly.

For software developers: Software developers are in high demand, so they have more flexibility to take on multiple jobs. This can be a great way to increase income and diversify your skills. For example, you could work as a full-time software engineer and also freelance as a software developer on the side.

[4] Rise of remote jobs:

To cut the long story short, if work could be done from home, why would you waste your time, effort, energy travelling? Not every job fits into 'work from home' culture, but many do.

For software developers: Software development is a job that can easily be done remotely, so many companies are now offering remote positions. This can be a great benefit for software developers who want more flexibility in their work-life balance.

[5] With the rise of financial & career education, most people would prefer decent money + family time (OVER) crazy money + no time.

And owning small businesses is one way of fulfilling this goal.

For software developers: Starting a small business can be a great way for software developers to have more control over their work and earn more money. Some examples of small businesses that software developers can start include developing and selling software products, providing software consulting services, or freelancing as a software developer.

6] As more and more businesses move online, the demand for software developers will continue to grow. Software developers are responsible for building and maintaining the digital infrastructure that businesses need to operate in the digital age.

P.S. I am not an expert and these are speculations

Resume Tips for Freshers 😄❤️

𝘿𝙎𝘼 𝙉𝙤𝙩𝙚𝙨 📗.pdf

top 100 Java interview questions .pdf

Date - 30/12/2023
Company Name - Course i5
Role: Data Scientist

Q.   How can outlier values be treated?

A.  An outlier is an observation in a dataset that differs significantly from the rest of the data. This signifies that an outlier is much larger or smaller than the rest of the data.
Given are some of the methods of treating the outliers: Trimming or removing the outlier, Quantile based flooring and capping, Mean/Median imputation.


Q.   What is root cause analysis?

A.  A root cause is a component that contributed to a nonconformance and should be eradicated permanently through process improvement. The root cause is the most fundamental problem—the most fundamental reason—that puts in motion the entire cause-and-effect chain that leads to the problem (s). Root cause analysis (RCA) is a word that refers to a variety of approaches, tools, and procedures used to identify the root causes of problems. Some RCA approaches are more directed toward uncovering actual root causes than others, while others are more general problem-solving procedures, and yet others just provide support for the root cause analysis core activity.


Q.  What is bias and variance in Data Science?

A.  The model's simplifying assumptions simplify the target function, making it easier to estimate. Bias is the difference between the Predicted Value and the Expected Value in its most basic form. Variance refers to how much the target function's estimate will fluctuate as a result of varied training data. In contrast to bias, variance occurs when the model takes into account the data's fluctuations, or noise.


Q.  What is a confusion matrix?

A.   A confusion matrix is a method of summarising a classification algorithm's performance. Calculating a confusion matrix can help you understand what your classification model is getting right and where it is going wrong. This gives us the following: "True positive" for event values that were successfully predicted. "False positive" for event values that were mistakenly predicted. For successfully anticipated no-event values, "true negative" is used. "False negative" for no-event values that were mistakenly predicted.

————————————————————-

Date: 02-01-2024
Company name: Oracle
Role: Data Analyst
Topic: outlier, dax, filter, recursive stored procedure

1. What are the ways to detect outliers?

Outliers are detected using two methods:

Box Plot Method: According to this method, the value is considered an outlier if it exceeds or falls below 1.5*IQR (interquartile range), that is, if it lies above the top quartile (Q3) or below the bottom quartile (Q1).

Standard Deviation Method: According to this method, an outlier is defined as a value that is greater or lower than the mean ± (3*standard deviation).


2. What is a Recursive Stored Procedure?

A stored procedure that calls itself until a boundary condition is reached, is called a recursive stored procedure. This recursive function helps the programmers to deploy the same set of code several times as and when required.


3. What is the shortcut to add a filter to a table in EXCEL?

The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.

4. What is DAX in Power BI?

DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.

Date: 03-01-2024
Company : Accenture
Role : Data Scientist
Topic : Silhouette coeff, Trend&Seasonality, Bag of words, Self join

1. What do you understand by the term silhouette coefficient?
The silhouette coefficient is a measure of how well clustered together a data point is with respect to the other points in its cluster. It is a measure of how similar a point is to the points in its own cluster, and how dissimilar it is to the points in other clusters. The silhouette coefficient ranges from -1 to 1, with 1 being the best possible score and -1 being the worst possible score.

2. What is the difference between trend and seasonality in time series?
Trends and seasonality are two characteristics of time series metrics that break many models. Trends are continuous increases or decreases in a metric’s value. Seasonality, on the other hand, reflects periodic (cyclical) patterns that occur in a system, usually rising above a baseline and then decreasing again.

3. What is Bag of Words in NLP?
Bag of Words is a commonly used model that depends on word frequencies or occurrences to train a classifier. This model creates an occurrence matrix for documents or sentences irrespective of its grammatical structure or word order.

4. What is a Self-Join?

A self-join is a type of join that can be used to connect two tables. As a result, it is a unary relationship. Each row of the table is attached to itself and all other rows of the same table in a self-join. As a result, a self-join is mostly used to combine and compare rows from the same database table.

5.Explain the Law of Large Numbers.

The ‘Law of Large Numbers’ states that if an experiment is repeated independently a large number of times, the average of the individual results is close to the expected value. It also states that the sample variance and standard deviation also converge towards the expected value.

Cold Email Template ✅

Java_Built_in_Methods_Cheatsheet_1702836925.pdf

Interview QnAs
Company - Bosch
Date- 09/01/2024
Role: Data Scientist

1. What is a logistic function? What is the range of values of a logistic function?

f(z) = 1/(1+e -z )
The values of a logistic function will range from 0 to 1. The values of Z will vary from -infinity to +infinity.


2. What is the difference between R square and adjusted R square?

R square and adjusted R square values are used for model validation in case of linear regression. R square indicates the variation of all the independent variables on the dependent variable. i.e. it considers all the independent variable to explain the variation. In the case of Adjusted R squared, it considers only significant variables(P values less than 0.05) to indicate the percentage of variation in the model.

Thus Adjusted R2 is always lesser then R2.


3. What is stratify in Train_test_split?

Stratification means that the train_test_split method returns training and test subsets that have the same proportions of class labels as the input dataset. So if my input data has 60% 0's and 40% 1's as my class label, then my train and test dataset will also have the similar proportions.


4. What is Backpropagation in Artificial Neuron Network?

Backpropagation is the method of fine-tuning the weights of a neural network based on the error rate obtained in the previous epoch (i.e., iteration). Proper tuning of the weights allows you to reduce error rates and make the model reliable by increasing its generalization.