# Nikhilesh Vashisht | Data Engineer | R2 | 3+ years
- Major time spend for scraping. Python programming.
- Used cronjobs on local system, then learned airflow.
- AWS Athena -> S3
- Knows the journey from basic to scale, solved issues
Positive
- Good with python coding.
Negative
- Very less/No exp. on PSQL/BQ/Redshift. Able to do basic queries.

# Question 1: Python
Json
mapping
pandas

let classData = {
    5: {
        10 : ["A", "B", "C"],
        11: ["D", "E", "F"]
    },
    6: {
        11 : ["A1", "B1", "C1"],
        12: ["D1", "E1", "F1"],
        13: ["G1"]
    }
}


[
    { class: 5, age: 10, name: "A"},
    { class: 5, age: 10, name: "B"},
    { class: 5, age: 10, name: "C"},
    { class: 5, age: 11, name: "D"},
]

lt = []
d = {}
for k,v in classData.items():
    # if d['class']  not in k:
    d['class'] = k
    for age,name in v.items():
        d['age'] = age
        for names in name:
            d['name'] = names
            lt.append(d)