Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Career Vs Your Attitude Do These Now

75% of the American workforce are actively looking for jobs at any given point in time, of which 69% of them are currently employed. 


Career vs Attitude

1. Networking 

Tapping into your Network, Creating, and Maximizing your Personal Brand and Researching Companies in your Field of Interest will help you in finding jobs that suit your interest. 


Trying to randomly find a job will get you nowhere. PREPARE, PLAN, and RESEARCH, and you will find a job that is meant for you. 


If you have attended a get-together of friends or a social gathering off-late, chances are that you would have come across at least half a dozen people, talking about their jobs; how they are unhappy with it and looking for a change, or how difficult it seems to get one in the first place.
Job Search.


Searching for a job has become one of the most time-occupying tasks in recent times. Almost as difficult as getting one, a job search means researching, identifying, and applying for jobs and going through the functions of interviews, discussions, negotiations, and such. It can, therefore, get very frustrating, daunting, and overwhelming for most of us. 


Srinimfjobs recommends a lot of jobs in new technologies. Job Seeker Survey has revealed that 75% of the American workforce comprises of active job seekers, up from 69% in 2011. This means that while jobs are increasing and becoming more versatile and varied, the number of people looking for a job has also increased manifold.


So how does one go about searching for a job, and finding the most relevant one based on personal capabilities? 


Below are a few important steps that can help give you a head-start in finding the job you have always wanted, whether just starting out, or jumping ship from your current one.

2. Tapping into your Network of Family, Friends and Past Employers

When looking out for a job, the first thing you should do is look around you and get in touch with the people you know. 


A network has tremendous potential because it has an outreach that is unlimited. People know other people, and reaching out to them, may just get you what you want since they have you to fill in the job vacancy they have heard about. 


If you haven’t been in touch with anyone off-late, do it now. Identify the most influential people in your group, and find ways to strengthen your relationship with them in the long run 

3. Attend events; whether for Career Advancement or for Personal Growth 

Meeting new people is all about the experience, as well as developing relationships that will prove beneficial in the short and long term. It is therefore important to attend every possible networking event, career fest, and get-togethers conducted by professional organizations to find the right job that fits your skill sets. You can IoT Jobs group to discuss the latest job opportunities.  


Make it a habit to talk and introduce yourself to at least one new person at every event. Follow this up by calling or interacting with them again, or subtly ask them for someone else’s referral. 
Create your Brand and Maximize its reach through Social Media. 


Social Media has been considered an unseen vehicle with a highly impactful reach. Make the best use of it, to advertise yourself to potential employers, and let them find you. The first step towards this is creating a BRAND that represents you. Your identity in the online space will make a strong positive impression on any recruiter, and also help him find out more about you as a candidate.


Almost 88% of all job seekers in the Jobvite survey have at least one social networking profile. And almost 23% of them have been asked for their social media information during an interview. This is a strong fact that underlines the impact of an online presence. 

4. Using Social tools 

Like LinkedIn, Facebook and Twitter will help you tailor your resume to fit in with the employers' requirements. You can even search your target areas of interest based on your preferences; industry, skill sets, and qualifications and reach out to people accordingly. 

5. Contact Head hunters/ HR Professionals 

It is a known fact, that while most jobs are either come referred by people or are got through social media contacts, the mid and senior-level professionals are almost always recruited through HR recommendations. 


These are the kind of jobs that are never advertised because they need the kind of expertise that can only be sourced specifically by such head professionals.


Short-listing companies in your field of interest Rather than randomly sending across your resume to companies for any job requirement what matters is targeting those that will be most suited to your interests.


Always take the time to research companies whose culture and mission match your work style and ethics. This will reap benefits in the long run and will ensure you are selected and remain with a company that you truly like working for.

To understand how to do this: 

Search online for Company listing and other resources based on the area of expertise The local Chamber of Commerce is a good way to find out relevant companies locally Professional career networking associations usually have a list of companies that can be contacted for your preferred requirement.


Finding a Job in today’s market isn’t an easy task. The amount of preparation that goes into it, the research involved and the effort taken to apply for a position that is most suited to your area of interest, will not just get you the job of your choice but also one that will keep you involved for years to come.  


If you have attended a get-together of friends or a social gathering off-late, chances are that you would have come across at least half a dozen people, talking about their jobs.

Summary
  • If your job matches your attitude, then you are good to continue.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers