jhyland87

Hi Justin, 

I reviewed your resume and believe your background aligns well to a targeted position we’re hiring for. Would you be interested in discussing a Technical Account Manager opportunity within AWS?

AWS is growing at an amazing pace and we need industry professionals like yourself to guide our customers into the future of cloud computing. You will advise industry defining start-ups to Fortune 100 companies to be successful in the cloud; serving as the expert on the full line of AWS services; helping our customers design, deploy and support large scale applications. Companies like Shell, Samsung, NASA JPL, Nasdaq, Merck and Pinterest to name a few have come to rely on our Enterprise Support programs to help them run their AWS infrastructure. 

Our AWS Technical Account Manager (TAM) is on the forefront of our largest and most innovative customers. It requires a unique person with broad technical acumen, and are an integral component to our enterprise customers experience with AWS. Our TAM’s are custom

jhyland87

<div style="font-family: sans-serif;">
<? var data = valid(); ?>
<form id="form" name="form">
<? if(Object.prototype.toString.call(data) === '[object Array]') { ?>
<? for (var i = 0; i < data.length; i++) { ?>
<? for (var j = 0; j < data[i].length; j++) { ?>
<input type="checkbox" id="ch<?= '' + i + j ?>" name="ch<?= '' + i + j ?>" value="<?= data[i][j] ?>"><?= data[i][j] ?><br>
<? } ?>
<? } ?>
<? } else { ?>

jhyland87

Question 1:
We would like to report for each employee - 'percentage of employees who joined the same department after the employee', 'percentage of company that joined after the employee', manager's name “in the same SQL query”.
Write the SQL in 3 or more ways. You can assume the database is either of them - mySQL, Postgres or Oracle syntax


Question 2:
Table: movies_watched
----------------
userid | movieId
1      | A

jhyland87

Table Name: Employee

Employee_id First_name    Last_name   Salary    Joining_date            Department    Order
----------------------------------------------------------------------------------------------
1           Roy           Thomas      700000    01-FEB-13 12.00.00 AM   Banking       3
2           Michael       Clarke      800000    01-JAN-13 12.00.00 AM   Insurance     2
3           John          Abraham     1000000   01-JAN-13 12.00.00 AM   Banking       5
4           Tom           Jose        600000    01-FEB-13 12.00.00 AM   Insurance     4
5           TestName1     123         650000    01-JAN-13 12.00.00 AM   Services      1
6           Philip        Mathew      750000    01-JAN-13 12.00.00 AM   Services      8

jhyland87

----  / both DE and DA candidates must have basic python 
*Basic python:
different data structures, various operations on them
iterations, traversing through data structures
 
Data Engineer job id 7122
•    We are looking for a senior Data Integration Engineer that has relevant experience working in a highly scalable environment.
•    Strong experience with SQL, must be very good hands on with SQL skills. Would be able to write SQL queries and play with various SQL databases.
•    Must have experience with SQL, Hive/ Presto, big Data, Hadoop, and MySQL.
•    ETL tool is similar to Airflow from AirBnb so, familiar with it is useful.

jhyland87

Table Name: Employee

Employee_id First_name    Last_name   Salary    Joining_date            Department    Order
----------------------------------------------------------------------------------------------
1           Roy           Thomas      700000    01-FEB-13 12.00.00 AM   Banking       3
2           Michael       Clarke      800000    01-JAN-13 12.00.00 AM   Insurance     2
3           John          Abraham     1000000   01-JAN-13 12.00.00 AM   Banking       5
4           Tom           Jose        600000    01-FEB-13 12.00.00 AM   Insurance     4
5           TestName1     123         650000    01-JAN-13 12.00.00 AM   Services      1
6           Philip        Mathew      750000    01-JAN-13 12.00.00 AM   Services      8

jhyland87

mysql> select * from employees;
+-------------+------------+----------------+--------+------------+------------+------------------+
| employee_id | first_name | last_name      | salary | join_date  | department | status           |
+-------------+------------+----------------+--------+------------+------------+------------------+
|        1001 | Clark      | Kent           | 700000 | 2017-01-05 | Banking    | Employeed        |
|        1002 | Peter      | Parker         | 800000 | 2016-11-04 | Insurance  | Leave of Absence |
|        1003 | Adam       | Mann           |  65000 | 2017-01-12 | Banking    | Employeed        |
|        1004 | Sean       | Cassidy        |  85000 | 2017-04-06 | Insurance  | Leave of Absence |
|        1005 | Jason      | Blood          |  65000 | 2017-03-07 | NULL       | Employeed        |
|        1006 | Bruce      | Wayne          |  82000 | 2017-03-09 | Insurance  | Leave of Absence |

jhyland87

#!/usr/local/bin/bash4

function stderr {
  echo $@ 1>&2

  [[ -z $2 ]] && exit 1
}

function abspath {
  [[ -d $1 ]] && { cd "$1"; echo "$(pwd -P)"; } || 

jhyland87

#!/usr/local/bin/bash4
function stderr {
  echo $@ 1>&2
}

function abspath {
  [[ -d $1 ]] && { cd "$1"; echo "$(pwd -P)"; } || 
    { cd "$(dirname "$1")"; echo "$(pwd -P)/$(basename "$1")"; }
}

jhyland87

#! /usr/local/bin/awk -f
# Solution by Ed Morton (http://stackoverflow.com/a/43946907/5154806)
# Example: echo -e "personal.name.first=John\npersonal.name.last\t=Doe\npersonal.other.dob=\t05/07/87\npersonal.contact.phone\t=\t602123456\npersonal.contact.email\t = \tjohn.doe@idk\nemployment.jobs.1\t\t=    Company One\nemployment.jobs.2 \t =Company Two\nemployment.jobs.3\t= Company Three" | ./tst.awk

BEGIN { 
  FS="[\t ]*=[\t ]*" 
}
{
  split($1,d,/\./)
  data[d[1]][d[2]][d[3]] = $2