tech Programmers Thread: King Python, C#, Javascript, Java

[Pikachoo]

4 hours ago, Price of Fame said:

Amazon has terrible work/life balance and loves to PIP people out (or even hire to fire to keep good employees) 

i don’t know anyone who’s come out of Amazon that wasn’t happy to leave 

they hire people just to fire them? wow.. and here I thought the recruiter reached out to me cause she liked my linkedin profile there's a job opening at Nvidia in my area. now that would be awesome..I'd love to get into embedded stuff.

[Price of Fame]

20 minutes ago, Pikachoo said:

they hire people just to fire them? wow.. and here I thought the recruiter reached out to me cause she liked my linkedin profile there's a job opening at Nvidia in my area. now that would be awesome..I'd love to get into embedded stuff.

I mean, that can be the case. not everyone is hire to fire

 

but basically amazon has to PIP out a certain amount of employees each year so a manager with a team that he is happy with could hire someone just to PIP them out within 6 months and keep their team.  PIP culture is predictably as toxic as it sounds on its own even without that possibility and it's a huge part of why Amazon has the worst rep of any Big Tech/FAANG company.

[Vrx.]

11 minutes ago, Pikachoo said:

I had actually bought 'Cracking The Coding Interview' by Gayle Laakmann McDowell, which is basically an interview prep for big tech companies. You're right, the book is mostly "remember these sorting algorithms and data structures"

 

any big tech companies that you've heard good things about? Microsoft? Apple? Google?

I mean I hate to say it, but ALL of big tech for the most part is dominated by these questions:

 

1. Shortest distance algorithms (Dijkstra's algorithm, Johnson's algorithm)

2. Sorting algorithms (Quicksort (divide/conquer), Heapsort, etc)

3. Search algorithms (A*, Min/Max, Fibonacci)

4. Selection algorithms (Using memory and search algorithms to find optimal solutions in linear time or less) **** ALWAYS TESTED

 

From my experience, Big tech almost exclusively tests selection algorithms. Why? Because they can aggregate all three of the previous algorithms into one question. For example (Google has used this problem):

 

Given a string of any size, find the number of times three or more consecutive letters occur.

 

Why this one? Think of the following input: xxxytxxxyyyyxxyyyzzzzzzzzzzzzzzzzzzzzzz

How would you go about this? What's the answer? As a human, you and I can see that it is 5, but how do you translate that to code? Memoization is imperative and how you break it up shows your knowledge of using these standardized methods, such as quicksort, and then apply the information tests your knowledge of all three items. That's basically why you need to know and be able to recite algorithms. They rarely ask you practical questions about prior experiences.

 

From what I hear, Microsoft is actually the best in terms of work/life balance, though their pay isn't as great as Apple/Amazon. Their benefits are also killer. In all honesty I'd steer clear of Silicon Valley unless you just want high pay and misery for an early retirement

[Vrx.]

36 minutes ago, Hot Volcano said:

What is the best way to retrieve emails and their content (body and attachments) and store them into a Oracle table in a database?

From where? Do you have access to your logs of emails sent? Or are you referring to something like Outlook?

[Pikachoo]

26 minutes ago, Vrx. said:

I mean I hate to say it, but ALL of big tech for the most part is dominated by these questions:

 

1. Shortest distance algorithms (Dijkstra's algorithm, Johnson's algorithm)

2. Sorting algorithms (Quicksort (divide/conquer), Heapsort, etc)

3. Search algorithms (A*, Min/Max, Fibonacci)

4. Selection algorithms (Using memory and search algorithms to find optimal solutions in linear time or less) **** ALWAYS TESTED

 

From my experience, Big tech almost exclusively tests selection algorithms. Why? Because they can aggregate all three of the previous algorithms into one question. For example (Google has used this problem):

 

Given a string of any size, find the number of times three or more consecutive letters occur.

 

Why this one? Think of the following input: xxxytxxxyyyyxxyyyzzzzzzzzzzzzzzzzzzzzzz

How would you go about this? What's the answer? As a human, you and I can see that it is 5, but how do you translate that to code? Memoization is imperative and how you break it up shows your knowledge of using these standardized methods, such as quicksort, and then apply the information tests your knowledge of all three items. That's basically why you need to know and be able to recite algorithms. They rarely ask you practical questions about prior experiences.

 

From what I hear, Microsoft is actually the best in terms of work/life balance, though their pay isn't as great as Apple/Amazon. Their benefits are also killer. In all honesty I'd steer clear of Silicon Valley unless you just want high pay and misery for an early retirement

well, I'm up in Canada, so our pay is even less than what Americans pay. US companies are basically the best way to earn a high salary here, unfortunately. (even Shopify, Canada's biggest tech company, pays less).

 

lemme read through this book, then. can't hurt! I know how these algorithms work on paper, but implementing them in code is a different story.

[Price of Fame]

The blind 75 on leetcode is a good resource when you’re looking to start solving actual problems. They are grouped by type of problem/data structure 

 

technical interviews are broken and largely luck but if you can understand the questions on that list, you’ll stand a pretty good shot at getting into big tech 

Edited June 1, 2022 by Price of Fame

[Vrx.]

1 hour ago, Pikachoo said:

well, I'm up in Canada, so our pay is even less than what Americans pay. US companies are basically the best way to earn a high salary here, unfortunately. (even Shopify, Canada's biggest tech company, pays less).

 

lemme read through this book, then. can't hurt! I know how these algorithms work on paper, but implementing them in code is a different story.

Are you just trying to get into Big Tech?

[Pikachoo]

6 minutes ago, Vrx. said:

Are you just trying to get into Big Tech?

it'd be nice, but not if the work-life balance sucks like at Amazon

[Vrx.]

2 minutes ago, Pikachoo said:

it'd be nice, but not if the work-life balance sucks like at Amazon

That's kinda the tradeoff lol

No place is going to give you 250k for 40hrs a week as a dev honestly. It's a worker bee job 

[Pikachoo]

1 hour ago, Vrx. said:

That's kinda the tradeoff lol

No place is going to give you 250k for 40hrs a week as a dev honestly. It's a worker bee job 

maybe not 250k, but a nice 120k would be more than enough for me. There's Nokia, Cisco, IBM and Ericsson in my area. I heard bad things about IBM, but I might as well try to apply to the rest.

[Vrx.]

2 hours ago, Pikachoo said:

maybe not 250k, but a nice 120k would be more than enough for me. There's Nokia, Cisco, IBM and Ericsson in my area. I heard bad things about IBM, but I might as well try to apply to the rest.

Cisco is actually good! It is harder work on the embedded sphere but it’ll be worth it if you’re able to transition to security. 

[Hot Volcano]

On 6/1/2022 at 11:45 PM, Vrx. said:

From where? Do you have access to your logs of emails sent? Or are you referring to something like Outlook?

Yes, talking bout Outlook.

[Vrx.]

2 hours ago, Hot Volcano said:

Yes, talking bout Outlook.

Local or for all outlook users in the org? 

[Hot Volcano]

2 hours ago, Vrx. said:

Local or for all outlook users in the org? 

neither. It's for everyone outside the organization sending an email to a specific email address and then I have to retrieve the content of all of those emails.

[Vrx.]

38 minutes ago, Hot Volcano said:

neither. It's for everyone outside the organization sending an email to a specific email address and then I have to retrieve the content of all of those emails.

What is this for? Outlook actions or an actual program? 

[Hot Volcano]

7 minutes ago, Vrx. said:

What is this for? Outlook actions or an actual program? 

I want people to fill up a form on a website and attach a document and then when they click submit I get that form and the attachment to a specific mail inbox. I sorted that out but now I have to find a way to store the content of these emails from my Outlook inbox into a table in database so I can keep track of all the incoming emails.

 

 

 

 

Edited June 3, 2022 by Hot Volcano

[Vrx.]

2 hours ago, Hot Volcano said:

I want people to fill up a form on a website and attach a document and then when they click submit I get that form and the attachment to a specific mail inbox. I sorted that out but now I have to find a way to store the content of these emails from my Outlook inbox into a table in database so I can keep track of all the incoming emails.

 

 

 

 

Before your commit you can make an API call to store it in a DB or build a DB utility that’s storing to your database and inserting the emails in a chron job 

[Hot Volcano]

Hey guys.

 

Does anyone know if it's even possible to directly insert a docx file into a BLOB column using INSERT INTO statement?

 

I already have the files in a variable (using a different tool) so now I need to insert the content of that variable into the BLOB column.

 

Quote

INSERT INTO table_name (column1, column2, BLOB_COLUMN)
VALUES (value1, value2, to_blob('%VARIABLE_CONTAINING_DOCX_FILE%'));

Tried with 'to_blob' but it didn't work. It works with RAWTOHEX, but then it just inserts an empty file. Any suggestions?

 

I also saw a lot of examples using procedure, but because I used another tool to store the content into a variable, I don't  think I can use a procedure.

Edited June 25, 2022 by Hot Volcano

[Pikachoo]

could anyone possibly take a look at my resume and give me feedback?

 

I have 2 years experience. im ready to move on from an Investment Bank and into a real tech company @Bloo @Vrx. @The user with the irish avi- Adonis?

 

Resume PDF

 

Thank you!!!!

 

 

[Bloo]

11 minutes ago, Pikachoo said:

could anyone possibly take a look at my resume and give me feedback?

 

I have 2 years experience. im ready to move on from an Investment Bank and into a real tech company @Bloo @Vrx. @The user with the irish avi- Adonis?

 

Resume PDF

 

Thank you!!!!

 

 

I would expand on the programming languages. If you just have a static list of languages, then they have reason to assume your strength/comfort with those languages are equivalent. This is never the case. I like tiering my languages in terms of proficient, comfortable, familiar or some other kind of system just so reviewers know my area of expertise.

 

I would add a few more technical details under your experience. For instance, you mention you worked with a pub/sub framework in Spring. Was this framework Kafka? Was it MQTT? If it's either of those things,  state it. If you had to help design a proprietary, in-house solution, say that.

 

Generally, it's pretty good. But these are just some immediate thoughts.

 

As for Adonis, he's abandoned ATRL.

[Pikachoo]

4 hours ago, Bloo said:

I would expand on the programming languages. If you just have a static list of languages, then they have reason to assume your strength/comfort with those languages are equivalent. This is never the case. I like tiering my languages in terms of proficient, comfortable, familiar or some other kind of system just so reviewers know my area of expertise.

 

I would add a few more technical details under your experience. For instance, you mention you worked with a pub/sub framework in Spring. Was this framework Kafka? Was it MQTT? If it's either of those things,  state it. If you had to help design a proprietary, in-house solution, say that.

 

Generally, it's pretty good. But these are just some immediate thoughts.

 

As for Adonis, he's abandoned ATRL.

ah true. I generally listed the languages in most used at work to least.

 

it's a proprietary pub sub. But it does use IBM MQ. But I didn't help design it. I just implemented it into my service.

 

But thank you for the feedback! I got anxious and submitted this resume to Cisco yesterday, and I haven't heard anything so I'm stressing out

[Vrx.]

@Pikachoo What were the requirements that you’re applying for? I’d definitely expand on your languages and also what you did on a day to day basis. A human isn’t going to read any of what you have prior to it passing a screening software which looks for keywords in your resume that will match created tags for a job description. For example, I see CRUD on it, but no true mention of things like REST API, IoT or slight expansion on the subscription services used, some libraries or expansion of what you used for the GUI, etc. 

 

It’s a bit funny but you have a basic template for most resumes which is typically role, then a description below it, and a bullet point list of buzz words that pass screening with a general description of how it was used. I’d recommend you try this approach and tailor the buzz words to whatever job you’re applying since HR doesn’t understand multiple terms for the same thing typically. Want to know if it works? Try it and apply to a job you aren’t interested in ?

[Pikachoo]

1 hour ago, Vrx. said:

@Pikachoo What were the requirements that you’re applying for? I’d definitely expand on your languages and also what you did on a day to day basis. A human isn’t going to read any of what you have prior to it passing a screening software which looks for keywords in your resume that will match created tags for a job description. For example, I see CRUD on it, but no true mention of things like REST API, IoT or slight expansion on the subscription services used, some libraries or expansion of what you used for the GUI, etc. 

 

It’s a bit funny but you have a basic template for most resumes which is typically role, then a description below it, and a bullet point list of buzz words that pass screening with a general description of how it was used. I’d recommend you try this approach and tailor the buzz words to whatever job you’re applying since HR doesn’t understand multiple terms for the same thing typically. Want to know if it works? Try it and apply to a job you aren’t interested in ?

i mean, we used Spring as our framework, log4j and a few google libraries, and then specific stuff like IBM MQ's,  but most java developers use these libraries anyway. most of it is proprietary. and I didn't make the guis.

 

so basically, tailor each resume to match buzzwords in the job description? I can do that.

Edited October 14, 2022 by Pikachoo

[Pikachoo]

well, I got rejected from my job application to Cisco Guess my resume wasn't strong enough. I thought 2 years experience I could get away with applying for a 4+ years experience with CS degree posting

[Vrx.]

3 hours ago, Pikachoo said:

i mean, we used Spring as our framework, log4j and a few google libraries, and then specific stuff like IBM MQ's,  but most java developers use these libraries anyway. most of it is proprietary. and I didn't make the guis.

 

so basically, tailor each resume to match buzzwords in the job description? I can do that.

Yes, you'll need to do so because otherwise you will get auto-rejected 

The thing is that once you add things like Spring Boot, you automatically are grouped and considered for different jobs. Putting Java gives no insight into what you actually do with it. Java can be server side application and code on AWS to handle lambdas, it can mean lower level intranet browser processing, your own customized socket/server client and chatbot, data processing and machine learning, etc.

 

Just putting Java gives no insight into what kind of Java you are using and what kind of development you are doing. Like imagine someone put C++. Did you do in-line C as well as transistor processing? Did you create an SFTP client into connecting to an autonomous vehicle? There's a ton of things that you need to specify to ensure that a recruiter knows what you were generally doing and how it could potentially fit into their client.

 

For example, I have like 7 years of python experience. However, it varies from big data processing, cython, pandas, sockets, AWS Lambdas, automated Terraform CI/CD command overrides, a custom console, etc. These are all different applications that are entirely different things and appeal to different clients depending on what they're looking for. Nobody will know what you can contribute unless you give some level of interest