Opower Associate Operations Engineer interview questions

I submitted my resume on a whim because the company looked cool and I fit the job description, but I wasn't really looking for a new job. A couple weeks later I was contacted to set up an initial phone screening which would last about 15 mins. It was short and to the point and they basically just wanted to go over my resume and explain the position in more detail. I was also told they were accelerating the hiring process so that everything would move quickly. It definitely did! After the initial screening I was given a technical HW assignment to complete. I had two days to design a simplistic SQL database and formulate some interesting SELECT queries, analyze a multiple step process I complete every day and optimize it, and also answer some typical "how would you handle this situation" type questions. About a week after I submitted my HW I was set up with an hour long phone interview with the hiring manager. We discussed my background, skillset, the position, and he also asked me some questions to guage my problem solving process. The usual stuff. It went well and a few days later they contacted me to set up a marathon day of interviews. They told me to expect whiteboarding, technical brain teasers, and a free lunch! The interview were with seven different people: 3 management type (background, problem solving, etc.), 2 technical (unix command line, SQL, Google search proficiency), and 2 casual getting to know you over lunch. I stumbled a bit on the SQL and Unix scripting because I don't use it regularly and couldn't remember the syntax, but they kept reassuring me it was more about gauging the logic behind what I was doing and would even help me with the syntax a bit and gave me access to google. In the end it was a great day of interviews and I had a quick tour of the office as well. I was a little worried at first that they didn't ask me any questions about what I was really there to do (programming Ruby and Java), but I guess they were confindent that I knew these things based on my resume. Overall it was a in-depth, but rewarding interview process. It challenged me to relearn a few things I hadn't used in a while and prove my skills, and even gave me a chance to meet pretty much every member of the team I would be working with. The recruiting team was extremely proactive and kept me informed at every step.