How long will it take you to make a meaningful contribution to our team at Questrade?

"I am interested in making an impact on your organization right away and have already crafted a plan to make that happen. I am a very strong business development professional and I plan to take the territory and expand it to include additional rural areas. This should amount to a strong increase in revenue within the first 9 months of my on boarding."

If you were to be the successful candidate with Questrade, when do you expect to make a viable contribution to the organization? Talk to the interviewer about your plan to make a fast impact.

"My plan, if hired by Questrade, is to make an impact as soon as possible. I have researched this position and am very eager so I have created a 90 day impact plan that I would like to share with you."

In your current work, what are the important steps you take in the data validation process?

"As I embark on a data validation process in my current role, my first step is to roadmap a detailed plan to keep on task. I utilize benchmarks and the expectations of key stakeholders as my guide. Once underway, I validate the database and the data formatting to ensure that data is properly screened for its overall health. Then, by finishing with sampling, tests are performed to hopefully show that the data is useful within the system."

Depending on your training and your past roles prior to interviewing at Questrade, you may be familiar with one or two of the many trains of though regarding the steps of a data validation. Whatever formal process you are familiar with, be sure to check the boxes of discussing data screening and data verification as part of your process. Your interviewer will be looking to hear that you check those boxes as they are imperative in the software field.

"The most important steps in a data validation process are determining the data to sample, scouring the existing database and validating the final data format. My first step is to use my best judgment to determine if I will validate a sample or the entire data set. This determination is based on overall size of the set and the timeframe that I have to work on the project. Then, I take the time to screen data in the existing database to calculate the number of unique ID's and records to come into the system. Last, I have to verify that the source data matches the schema within the targe"

If hired here at Questrade to develop iOS and Android software, when would you use a fragment rather than an activity?

"As a best practice in my development of Android apps in the past, activities are really the complete screen that a user experiences as part of the app. Fragments are really small sub activities that take place within the activity. Because fragments within an app have their own life cycle and receive their own input events within the app, there are specific times where fragments make the most sense to use in development. In my experience, I always use fragments when the app is working with UI components that are going to be uses across multiple activities within the app. As well, fragments have also served very well when using swipe views within the app."

In the development of apps for both iOS and Android, using code to create an activity versus a fragment is a highly debated topic to this day. For this question, your interviewer is looking to hear that you understand what the differences between the two are and when you feel that using a fragment is the proper direction to go. Make sure to speak to the high level overview of what an activity does to an app versus fragments.

"In the past year, I honestly don't recall designing a new app that ran solely on an activity alone. The fragments are almost necessary today to bring life to an app. I use retained fragments to persist across activity restarts within the app and this helps make a user friendly experience for our end users."

One huge philosophy that we believe in at Questrade is professional development. How have you worked to develop yourself professionally throughout your career?

"I am a firm believer in being a life long learner in my work as a Data Analyst. As technology and times have changed over the course of time, I see it as very important to be learning and changing along with the times. Just over the past two years, the Data Fest and Data Summit national conferences and participation in these events on a yearly basis is super important to me to help me grow and develop."

In an ever-changing field like financial services, Questrade knows that professional growth and development is vital to them staying at the forefront of their industry. For this question, your interviewer is looking to ensure that your values surrounding professional development match the values of the company. Use this question as an opportunity for you to highlight the many ways that you grow and develop yourself to be the best that you can be in your career. Highlight any continuing education you have completed, any societies or groups that you belong to and any publications that you read on a regular basis that will prove to your interviewer that you aren't comfortable being stagnant in your career.

"In the financial field, I have to stay at the top of my game to compete with other advisors and keep clients happy and flourishing. To do this, I subscribe to and read many of the great publications that are out there. Some of my favorites include the Wall Street Journal, Money magazine and Forbes. I also subscribe to many others. As well, I am a member of NAIFA and I have attended the organization's Congressional Conference on a few occasions."

What software programs do you use in your current work and how adaptable would you say that you are in learning and using new programs?

"In my current role, I currently use a program called Zendesk that is an interactive customer support tool. When we started to use this tool a little over a year ago, I was very quick to learn and utilize all of the great functions of the program and have since become a trainer for new staff that join our team. As well, I'm very fluent in the entire Microsoft suite of products and would consider myself an expert on the Outlook, Excel and Word programs."

Overall, your interviewer is simply looking to hear that you have a good grasp on programs to use to make you more efficient in your work and to do this, talk open and honestly about the programs that you currently use and talk about in what context that you use them. If at all possible with this role, try to research what additional programs you may have to learn if given this opportunity to join Questrade and reassure your interviewer that your computer skills are fluent enough to pickup quickly if needed.

"I consider myself very agile when it comes to using and appreciating the vast amount of software that is available to Financial Advisors today. In my current role, I solely use RightCapital as a financial advising tool with my clients. I really love its ability to help in the budgeting and comprehensive planning processes with my clients. I'm also very familiar with the MoneyGuidePro tool and have used it successfully in the past. If hired for this role, you can consider me an open book when it comes to learning and effectively utilizing any programs needed."

The next cloud engineer that we hire here at Questrade needs to be able build a system that can handle a high amount of traffic. How would you test our system's ability to handle large amounts of traffic?

"Cloud computing has certainly revolutionized the storage of high amounts of data and a key piece that cloud based systems bring to the table are their elasticity for handling large amounts of traffic. I see my job as building a cloud based system to scale horizontally to be able to handle the most data and traffic possible. To test systems, I've used a few different tools that were all very accurate prior to go-live."

This question allows your interviewer to gain insight into your thought process and ability surrounding building a cloud network that has an architecture that can handle large amounts of traffic without failure. Some key points to focus on your answer are your ability to match capacity to system demand and use horizontal scaling in the design of the system.

"In my current position as a cloud engineer, I have utilized internet scale services like Amazon S3 and Elastic Load Balancing to ensure that our cloud systems could handle large volume that fluctuate seasonally. Because of the great functionality of the internet scale services, internal testing wasn't necessary as we knew we were in good hands through those services."

If you joined the team here at Questrade, how would you build relationships with those that you would be working closely with?

"From my first day on the job, I would take the time to break the ice with my colleagues by introducing myself and setting up an individual meeting with each person. In the past, I've done these meetings over lunch or in an office where I've had questions prepared for me to get to know the person both personally and professionally. I want to ask my colleagues what they expect from me and what I can expect from them. I've found that these conversations really help to open up doors for working with each other moving forward."

For this question, your interviewer will be looking to get the sense that you would be proactive about getting to know your colleagues and fitting into the culture of the organization. Use a personal approach to talk about ways that you have done this in the past and how you would do it if hired for this position. Talk about the importance of relationship building in your line of work and how it helps the overall good of the organization if you take the initiative to do this.

"Being the new person on the job can be a very high anxiety time for some people, but I love the opportunity to break the ice with my coworkers by making that first contact. I think it's important to get to know each other on a personal level because we spend so much of our lives together in the workplace and I am a caring person that wants to know how last night's soccer game went for the kids. Beyond that first ice breaking conversation, my work relationships are then bonded through my work ethic and helping others on my team to show that I am a true team player."

List the top 3 skills that you have acquired in your last role.

"In the past few years I was able to upgrade my education while still working full time. The biggest skill that I gained was my ability to multi-task as I worked the dual role of employee and student. I also have strong skills in a variety of Microsoft programs such as PowerPoint and Excel."

You have likely gained many valuable skills in your career. Share with the interviewer which skills you value the most. Be sure to include skills that will potentially benefit this potential new employer.

"There are many skills I gained in my most recent position as I had a great training program and my boss was a strong mentor. If I had to choose three top skills I would say that the biggest ones were effective multitasking, solid closing skills, and cold calling abilities."

Here at Questrade, we are expecting someone with strong leadership skills to take this role. How would you describe your management style?

"My overall management style is the belief in building a positive team atmosphere. I'm a firm believer that each person and role brings a specific skill set to the ocverall goals and purpose of a team and I promote a team based atmosphere by larifying everyone's role on the team, keeping every person's objectives clear, rewarding great performers on the team and holding people accountable for their actions. If hired for this role at Questrade, you can be assured that my promotion of a team based atmosphere would help achieve even higher goals than you have set right now."

Prior to your interview, try to take a long, hard look inside your skills and styles as a leader of others and prepare to present the best management style possible to your interviewer that fits the role that you are interviewing for with Questrade. Your answer should also involve solid research into the culture of Questrade and the details of the role you are interviewing for. Some important things to touch on are your ability to promote a team atmosphere and your ability to delegate responsibilities when necessary.

"I think that it is crucial for a leader of others to be flexible in their style rather than relying on just one of the canned management styles. I'd like to highlight my abilities to lead as being a manager that works to grow and develop my staff to help them achieve their career goals and a leader who is able to provide direction and authority when the time for it arises. By knowing my team well and promoting our goals, I have the ability to assign work to the right people and follow through with my team on meeting all objective necessary."

When would an investment in commodities make sense for a client that you were working with?

"In my experience, commodities have made the most sense to use as a hedge when I am concerned about a potential upcoming crisis. I've utilized the gold market at times and it was very effective during the recession back in 2008. Gold prices have always tended to rise when the markets fell and some very high profile clients I worked with at that time were very pleased with their results while others lost a substantial amount in the market."

Prior to your interview, it is important to prepare for very market specific questions like this one where your interviewer will be looking to get a sense that you have the knowledge about particular markets like commodities, annuities and private equities. When you answer a question like this, try to give your interviewer an answer that shows that you understand the basic details of the market, when it is useful and what its downsides are to prove that you know situations where it can be very beneficial to a potential client.

"Commodities are always an interesting consideration because of their spectacular performance at times. But, because they don't receive dividends and aren't a great hedge bet over time, there are only a few scenarios where I utilize them. Crude oil markets are a great example of a short term buy in commodities when a production increase or decrease is announced."

In your work as a Portfolio Administrator, what kind events cause you the most stress on the job?

"While overall market volatility does stress out a lot of Portfolio Administrators, I have a very good way of explaining this volatility to my clients to the point where it doesn't stress me out. For me, any stress that I feel is usually put on me by myself in having very high expectations for my work with clients. To help alleviate this stress, I've learned over time that the goals and expectations that I put on my work have to be realistic and attainable when they sometimes weren't early on in my career."

The high demands of a position as a Portfolio Manager or Administrator bring a lot of stress. Market volatility, greed, underperformance and tough clients can all contribute to a high level of stress in this field. For this question, your interviewer is looking to gain insight on how you handle these stress factors on the job by having you talk a bit about what types of things cause you stress. While you talk openly about what it is that causes you stress or discomfort, make sure that you also talk through how you handle that stress in a safe, healthy and good for business manner.

"In reality, our work as Portfolio Managers for our clients is almost like trying to do the impossible. We are relied upon to make sound decisions for clients based on insufficient information, all while trying to maintain confidence in our decisions. This in itself is a daily stressor on the job and one that I don't take lightly. To help myself with this daily stress, I've learned to accept mistakes as they happen, own up to them with clients and work hard to alleviate those mistakes to put my clients back in the best position possible."

How do you believe your coworkers would describe you?

"I believe that my coworkers, if asked, would describe me as a reliable person who is always ready to submit the best work possible. My work ethic has never been questioned, and I am very proud with the work that I have submitted in my career, so far."

The interviewer would like to know how you are seen by your colleagues. Select approximately three words that truly define who you are. Be sure to choose words that radiate positive thoughts!

"Here are some other great keywords you could use: - Encouraging - Caring - Knowledgeable - Reliable - Focused - Honest - Assertive - Tenacious - Motivated - Ambitions - Conscientious"

What SDLC models are you familiar in working with?

"During my training in software engineering and in my early career, the waterfall model was the standard. In this model, each phase of the development process happens in a set order and projects using this model are easily managed. But over time, as the development projects that I have led have become more complicated and intricate, I have implemented the spiral model. This model has allowed the ability of end users to give feedback early on and often during development and helps to build a more customized product to our customers."

As a software engineer, you are very familiar with the software development life cycle. For this question, your interviewer is looking to hear what models you have worked on in the past. While there isn't necessarily a right or wrong answer to this question, try to show your flexibility to working with different SDLC models by bringing up your past experiences. Then, show you have knowledge of different models like the waterfall model or agile model. It is also a good idea to use this question as an opportunity for you to learn more about Questrade by asking your interviewer which model they work off of.

"In my current position with XYZ Company, my department utilizes the agile model in development life cycle. Since our products are so tailored to the needs of our customers, we get a working product very early on in the process and then I work hand in hand with customers to fine tune the software moving forward. It is a very effective model that has built a great reputation for our software among customers. I also have familiarity working with the iterative model and it has similar advantages to the agile model. If I were hired here at Questrade, can you expand on what models you use here in your software development life cycle?"

Talk about your experience in mortgage loan closing. How would this experience be beneficial to our team here at Questrade?

"As you can see from my resume, my current role involves a lot of detail in the loan closing process for the customers that I work with. I assemble and prepare closing documents and coordinate the details of the closing process when all terms of the sale are met. In this role with Questrade, I think that my hands on approach that I currently take with my customers would suit your clients well because I take the time to work with them one-on-one and never hesitate to provide top notch customer service to any person that I'm working with."

As a Loan Consultant with Questrade, you will be tasked with guiding clients through the complete mortgage process. This will include seeking the best funds available, completing paperwork and seeing the loan through to closing for them. For this question, your interviewer can a good sense of your experience by taking a look at your resume, but they're looking to get more details on your mortgage closing experience by having you talk in detail. Be sure to discuss your specific experience and tie what you can to this specific role with Questrade.

"Having been in the mortgage business for over ten years, I have a vast amount of experience in seeking personalized mortgage options for clients and walking them through the entire loan process. I am familiar with the processing of necessary loan closing documents in several state and know all of the fine details that are required to ensure that there are no hiccups in the process for clients. This experience would allow me to hit the ground running in this role here at Questrade."

The day-to-day life at Questrade can be hectic and stressful at times. If hired for this role, how would you keep yourself motivated when working with stressed colleagues and pushy clients?

"Being a person that thrives in a fast paced work environment, I have the ability to handle stressed colleagues with a grain of salt. As you can see from my resume, I've spent the last five years in the manufacturing industry where my department worked under tight deadlines all of the time. If I noticed that a colleague was under stress, I offered my help if I was able to and down the road that was usually reciprocated back to me. This unselfish attitude and realizing that someone else's stress wasn't directed at me was the key to maintaining personal health and balance on the job."

The daily life at Questrade is naturally very fast paced and because of that, both the colleagues and the clients that you may be working with have potential to be stressed, needy and downright mean at times. For this question, your interviewer is looking to get a sense that you would be able to work in this type of environment. In your answer, talk about the fact that you are cognizant of what this job entails as far as personal interactions go and talk about times where you have worked successfully through situations like this in the past. As well, don't hesitate to talk about your own personality traits that help you thrive in these types of situations.

"In my current role in client services with a large hospitality group, some days can go off the rails and it feels like I'm working with enraged customers all day long. I have the attitude that their anger isn't directed towards me, but I'm the face of the company that they are currently working with and I need to do my job in helping solve their issue. While I do have great resources at my hand to help solve customer issues, I think that taking the time to get to know all of our management team and how they solve problems is key as well so I know who to put customers in touch with if needed."

If I were to hand you $100,000 to invest today, where would you put that money and why?

"If the money was given personally to me to invest for myself, I would go for a 50-50 split between stocks and bonds being that I'm 37 years old. This would provide a good mix of funds that could be placed into aggressive IT and healthcare type stocks with a lot of growth potential while keeping half safe in the bonds market."

As a simple tool to gauge how you will both satisfy clients and make a profit for Questrade, your interviewer is looking to hear how you would invest money right now if given the chance. While there is no right or wrong answer for this question, show them your knowledge of breaking up assets based on age if possible. As well, don't hesitate to call out your knowledge of specifically allocating funds into different sectors or individual businesses or industries. In the end, make sure to give a full explanation of why you are choosing what you are to sell it to your interviewer.

"Being that I am young and willing to wisely be aggressive with money invested for myself, I would look for gems in certain industries like social media and internet retail sales. Amazon is expected to see prosperous growth and so are places like Pinterest and Facebook. I'd be wise with these investments while being sure to pay close attention to futures forecasts as those could change quickly, meaning a shift in my direction as well."

If hired for this role with Questrade, how would you handle a large workload of clients working through a mortgage process?

"In my current role, I'm able to handle a very large workload with my ability to stay organized on the job. If you could take a tour of my office, you'd see that I maintain a neat and clean desk with a very organized file cabinet of my current workload. If I need to shift gears and move on to work with another client, I can easily access information on the fly and keep moving. I also utilize my Outlook calendar to set deadline reminders to stay on track of closing deadlines and paperwork requirements and the tasks function within the program helps me stay right on track with all of my clients I am working with at a given time."

At the heart of this question, your interviewer is looking to find out how you manage a busy workload by having you talk about your organization skills on the job. In your answer, talk about the skills you have and the tools that you use to stay organized and on-track while handling a large workload. Don't hesitate to talk about the software programs that you use and any other tactics that you use to ensure that all deadlines are met and no issues occur with clients because of too large of a workload. In the end, your interviewer wants to walk away from this question knowing that you'll be able to provide top notch service to the clients of Questrade.

"During my time working a large client load as a mortgage consultant, my success was due to my efficiency and organization on the job. If hired for this role with Questrade, my efficiency would be very high because of my experience with the entire mortgage loan closing process and my ability to handle certain challenges quickly with that experience. From there, my organizational skills within the loan process software I have experience with kick in to help me keep each client on track with their loan process."

In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?

"In the simplest of terms, a clustered index order records in a table the way that they are physically stored. There can only be one clustered index per table. Non-clustered indexes do not store data to match the physical order that it is stored. Rather, it can hold up to 249 indexes per table. Both types come with their own benefits over the other. In my experience, clustered indexes are suited best for programs that use primary key as an identity integer column. On the other hand, non-clustered make the most sense for programs that need JOIN and WHERE clauses within them."

Questrade uses indexes to improve query performances within their software and for this question, your interviewer is looking to hear that you have a basic understanding of both clustered and non-clustered indexes. Explain the differences between the two types of indexes and be sure you can either speak to relevant times that you've used each or when would be the appropriate application to use each.

"In my experience, clustered indexes are faster to read but very slow when it comes to update data within. Non-clustered indexes are just the opposite in that they are slower to read but much fast to insert new data into them. In my current role, I mostly use clustered indexes when large numbers of rows need to be retreived and when insert operations are important. Most other times, I will use non-clustered as the standard."

If you can, please provide your thoughts on the function of managed object context in developing iOS apps and software.

"In my current work, I work with both main queue and private queue manged object contexts. It is important that I avoid non user related data processing on the main queue of an app that I am developing. In times where this has happened in the past, the user interface becomes unresponsive and crashes. As well, I work to avoid instances passing between the main and private queues to avoid corruption of data within the app."

While the core data framework and the managed object context may seem pretty easy to comprehend and simple from a first look, a deeper look into managed object context shows that it can be misused to the point where obscure bugs can enter the system. Give your interviewer your own personal insight into the purpose of managed object context and how it works behind the scenes to help an app properly run.

"Knowing that a managed object context's job is to manage a number of records within an app, my job is to successfully manage each object within the app and assign it to a correlating context within the app. I have to consider the persistent store coordinator and code the app to fetch requests from the correct one."

Think back over your career up to today and tell me about the most difficult day on the job you encountered. What made the day difficult and how did you handle that situation?

"It's funny that you ask this question because I can honestly say that my worst day on the job happened just a few short weeks ago. Upon arriving to work in the morning, I quickly learned that our entire network was down and we wouldn't be able to work within our CRM or other programs that day. Many of my coworkers were visibly upset and questioning how we would be able to do our jobs that day. Rather than joining the crowd and freaking out about the situation, I huddled our group together to talk about solutions to the workday after we found out that the network likely wouldn't be fully up and running until late afternoon. While some colleagues carelessly went home for the day, I helped brainstorm how we could keep our phone lines open and my boss was very grateful for my efforts that day. Looking back, what made this the most difficult for me was seeing how others responded so negatively over an issue that we had no control over."

We've all had our share of difficult days on the job and how we handle those days in particular can really make or break where our careers go in that position or with that company. Think of a particular day ahead of your interview that really outlines your ability to handle adversity and proves that you were able to handle it with grace rather than turning your uniform in and heading home for the day. Another important piece of your answer should be discussing what lessons you learned from that particular day moving forward that you still carry with you to this day.

"Early in my career, I had a day where my entire office came down with the flu and I was left alone with the receptionist for the day. Being trained and working Financial Advisor, my colleagues also handled market analysis, retirement plans and insurance plans. At first, the receptionist and I went about our business. After being flooded with calls and in-person visits into our office, we connected again to talk about a plan moving forward. We discussed what types of calls she could handle and which ones I would handle and she triaged from there. I made contacted with my personal clients I had scheduled that day to reschedule and we worked well from there. If I couldn't answer a question for a client of one my colleagues, I ensured they knew that my colleague would follow up as soon as possible. Looking back, I learned that on days where you have to break routine like we did then that it was important to make a plan as early in the day as possible."

If hired to this role here at Questrade, what do you see as one initial hurdle you will have to overcome in your first weeks on the job?

"Having put a lot of thought into this even before submitting my resume for this position, I realize that my greatest hurdle would be making the leap as an Auditor into the financial focused industry. My five years of experience out of college have been focused on management and technical consulting services, but I feel that I've built a very good knowledge base and experience for this role here at Questrade. If given the opportunity to join your team, my initial focus would be to get enthralled in auditing in the financial industry and I'd do this by being attached at the hip to my colleagues and taking the time to talk one on one with a lot of other staff to help better understand what they'll expect of me in this role."

At the heart of this question, your interviewer is asking you to take an honest look inside of yourself to discuss what you feel is the biggest learning curve you will have if offered this position. This will give your interviewer a sense of how to handle your onboarding process if hired for the position and give them a sense that you have the ability to see what your biggest need would be. Similar to the what is your greatest weakness question, the key to answering this question is humbly pointing out a flaw that you may see and making a plan for how you will overcome that flaw.

"Understanding that my role here at Questrade would have me working with the entire advisory staff, the first hurdle would be getting to know everyone on that team and showcasing the skills that I could bring to their work. If hired for the job, I would hope to be invited to team meetings where I could introduce myself and my role with the team and I'd invite an open conversation with the entire team."

If you were having an interaction with a client here at Questrade and you weren't able to answer their question or solve their problem on your own, how would you handle that situation?

"In my current role in Customer Service with Metropolis' largest automotive dealership, I frequently get asked questions that our sales, finance and service staff have to give the final stamp of approval on in answering customers questions. In these situations, I have a great amount of knowledge where I can prepare the customer for speaking with the right person while also ensuring them that the sales, finance or service staff will provide the final answer. Then, I work quickly to get them to the right person."

As the forward facing client services representative with Questrade, you may be asked serious financial or market related questions that either don't know or aren't qualified to answer. In those situations, you will be expected to explain to the customer how that question will be answered and then deliver a timeline on when it can be answered. In the end, the customer wants to know the clear path to ease their mind and it will be your job to do just that.

"In a situation where I didn't know an answer, I would ensure the client that we have the right staff in place that would be able to help them quickly and efficiently. I would communicate to the customer what the next step would be and if that would be me putting them directly in contact with someone or me taking their contact information and having someone get back to them. In the end, setting the right course and timeline would be important for every customer when I faced this situation."

The clients of a financial firm like Questrade can display an arrange of emotions when they work with our Client Services team. How would you handle a situation where a client was very angry?

"As you can see from my resume, I've spent the last three years in customer service relations for a large insurance company. As you can imagine, a large majority of my customer interactions were with upset customers. I've been called names that I can't repeat here in this interview and my key to working through these situations was to remain calm and not take things personally. Like the financial world, the insurance business is a very life altering experience and a loss or damage to an item is very stressful. I tried to put myself in the customers shoes, see things from their perspective and do my best to ease their situation. In this role with Questrade, these same skills would be vital for me to find solutions or the right person to talk to if needed."

Whether due to a large amount of money lost on the market or a client feels they were ill-advised by an Advisor, your job as a Client Services Representative will at some point or another deal with a very angry client. For this answer, your interviewer will be looking to hear that you do what is necessary to stay calm and stay focused on finding a resolution. If possible, use a specific example of a time you had to do exactly this and explain how effective communication was critical in making the situation right for the client.

"First and foremost, an active listening approach is the first step to lowering the tension from an angry customer. A couple of months ago, we had a very angry customer come onsite to complain about a defective product that cut his hand pretty badly. The customer came onsite to complain even before receiving emergency care, which was apparent that he needed. First, I let him release his anger and it was not a pretty sight. Then I calmly repeated back what he had said and then explained what our policy allowed me to do at that time. Looking back, my sincere approach and calm demeanor helped calm him down and later that day, my manager had a formal complaint sent to the manufacturer and we were assured that they'd be in contact with the customer."

We pride ourselves on our interdepartmental teamwork here at Questrade. If hired for this role, what kind of team player could we expect you to be?

"My colleagues that I work closely with would tell you that I'm knowledgeable in my area of expertise to contribute to the much larger team and do so without hesitation. As well, I'm able to communicate effectively, take direction and run with when needed and always willing to help out other areas if I have free time. I understand that I would be working very closely with the Advising staff here at Questrade and know that they would have high expectations out of my work."

In the financial world, teamwork at an organization is the key to success and life at Questrade is no different. As you talk about your abilities and experiences in being a great team player, try to highlight certain themes like building trust, gaining respect and being a subject matter expert as part of a larger team. Don't hesitate to show flexibility in your ability to both lead others and be lead by others and use examples of times that you've done both. To seal your answer for this question, talk about your desire to work as part of a team and do your research on this position to find out what types of colleagues you will be working with.

"I prefer to work in an environment that promotes teamwork and collegiality. If I were fortunate enough to join the team here, I want you to know that I love being in a leadership type role on a team where I can delegate work and help train others to better the organization. As well, I also thrive in a role where I am the minion and taking direction from others. I'd say that my key skills in working as a team are my ability to friendly, honest and trustworthy with my team."

Our clients here at Questrade expect top-tier service and products and we will expect you to do just that in this role. Have you ever went the extra mile for a client when it wasn't expected? Why did you do so?

"A couple of years ago when I was working customer service in retail, a customer was looking for what happened to be a discontinued item of clothing for her sick mother. The easy route would have been to simply look it up, tell her it was discontinued and have her be on her way. What I did was take down the customers contact information and let her know that I could contact our person that handled archived products. If we could track it down, I would be in touch. With a simple phone call, my colleague was able to track the item down from the supplier and have it coordinated to ship directly. We put the customer in direct contact with the supplier and she was as happy as could be. Looking back on that situation, I felt that it was the right thing to do given the situation that the customer was in and knowing she was a loyal customer of ours."

Questrade looks to set themselves apart from their competition by delivering the best service possible in the industry. You, as a customer service professional, are likely used to doing this so in your example, be sure to think about a time where your going above and beyond the call of duty really impacted the overall customer experience. No matter what example you use, be sure to explain why you felt it was important to take that action and what outcomes you are aware that it produced.

"My current role in hospitality often has me working with very high profile customers that come to our hotel. Last year, a touring manager for a musician contacted me regarding and upcoming stay for the musician. I proactively asked for their dining and entertainment preferences and with that list, I was able to work with our catering staff to ensure we had preferred items on the menus for the nights that he stayed and that we had a customized video game package in the musician's room for the his extended stay. Prior to him leaving, his manager reached out to thank me for the great service!"

What programming languages would you consider yourself fluent in?

"From the start of college, where software engineering grew into a passion for me, I've become very fluent in Java, JavaScript and C++. My current role has me working primarily with C++, but I pride myself on my ability and passion to learn new programming languages and would be able to do so if hired for this role with Questrade."

While this question gives your interviewer insight into the diversity of your programming language experience, they most importantly want to know that you are adaptable and able to learn on the fly if needed. Talk about the different languages that you consider yourself fluent in and, if possible, do as much research into Questrade as you can prior to your interview and try to speak to the specific languages that they work with.

"During my training to be an engineer and then in my current role since graduating, a majority of my experience falls within Python. My current role delves deeply into artificial intelligence and Python is awesome with this advanced technology. As I understand it from talking to another engineer here at Questrade, a requirement would be for me to learn Scala. Though I haven't worked directly with Scala, I believe my experience and willingness to learn would have me up and running in no time if hired for this role."

If hired for this role at Questrade, how would you help make sound investment decisions for our clients?

"In my current role, we have a great team that considers many factors in our investment decisions for our clients. Our engineers have developed mathematical models that gauge the markets and their propensity to shift over time. We have a team of market experts that rely on the new and current times to predict future fluctuations. As the Portfolio Managers, we weigh information from all of these teams to make decisions moving forward and this allows for the greatest confidence in our overall decisions."

While certainly an open ended question for you to run with, your interviewer is really looking to get a sense that you are resourceful in your decision making processes and that you don't rely too heavy on quantitative or qualitative information to make decisions. In your answer, talk about the sound use of data while also relying on your experience and judgement to help in your decision making processes. As well, if you are open and experienced in a team based approach among fellow colleagues, talk about that as well.

"While all of our decisions for our clients are based on assumptions, my experience has taught me to weigh in many different factors when making investment decisions. Looking at historical data to predict futures carries some weight and can be accurate at times, but having firsthand knowledge of different businesses and industries like I do helps put that historical data into perspective when trying to predict the future. If hired for this position at Questrade, I'll have that ability to make the best decisions possible for your clients."

At Questrade, we pride ourselves on providing the best overall customer experience. Talk about your customer service experience and explain why it will help our clients here.

"Over the past five years in my current role in customer service, my number one mantra has been to create the most personalized experience possibl for each person. I have done this by taking the time to get to know the customer, find out what their needs are and creating an experience unique to them. Where my time in automotive sales has really prepared for this role with Questrade is in this approach. If hired for this role, I know that I will be relied upon to use open and honest communication skills, time management skills and to take a empathetic and personalized approach with each client and I can definitely be relied upon to do that."

In the financial services industry, overall client experience is a major predictor of business growth and the team at Questrade takes the overall client experience seriously. For this question, your interviewer will be looking for you to expand upon your customer service experience past what they can see from your resume. To seal the deal for your interview, try to talk about times that you have went above and beyond the call of duty to provide the best service possible for a customer.

"In my years in a front facing customer service role, I've prided myself on being the face of the franchise. More often than not, my interactions with customers can be the difference between a repeat customer and a person who never comes back again. To ensure repeat customers, I make sure that I am knowledgeable about our products and services, I'm proactive with their needs and I'm always accountable for any mistakes that are made on my organization's side of things. If given the opportunity to join the team here at Questrade, I will work hard to be highly educated in your services and be proactive and accountable in every interaction that I have."

Questrade Interview Questions

Go Back

1. How long will it take you to make a meaningful contribution to our team at Questrade?
2. In your current work, what are the important steps you take in the data validation process?
3. If hired here at Questrade to develop iOS and Android software, when would you use a fragment rather than an activity?
4. One huge philosophy that we believe in at Questrade is professional development. How have you worked to develop yourself professionally throughout your career?
5. What software programs do you use in your current work and how adaptable would you say that you are in learning and using new programs?
6. The next cloud engineer that we hire here at Questrade needs to be able build a system that can handle a high amount of traffic. How would you test our system's ability to handle large amounts of traffic?
7. If you joined the team here at Questrade, how would you build relationships with those that you would be working closely with?
8. List the top 3 skills that you have acquired in your last role.
9. Here at Questrade, we are expecting someone with strong leadership skills to take this role. How would you describe your management style?
10. When would an investment in commodities make sense for a client that you were working with?
11. In your work as a Portfolio Administrator, what kind events cause you the most stress on the job?
12. How do you believe your coworkers would describe you?
13. What SDLC models are you familiar in working with?
14. Talk about your experience in mortgage loan closing. How would this experience be beneficial to our team here at Questrade?
15. The day-to-day life at Questrade can be hectic and stressful at times. If hired for this role, how would you keep yourself motivated when working with stressed colleagues and pushy clients?
16. If I were to hand you $100,000 to invest today, where would you put that money and why?
17. If hired for this role with Questrade, how would you handle a large workload of clients working through a mortgage process?
18. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?
19. If you can, please provide your thoughts on the function of managed object context in developing iOS apps and software.
20. Think back over your career up to today and tell me about the most difficult day on the job you encountered. What made the day difficult and how did you handle that situation?
21. If hired to this role here at Questrade, what do you see as one initial hurdle you will have to overcome in your first weeks on the job?
22. If you were having an interaction with a client here at Questrade and you weren't able to answer their question or solve their problem on your own, how would you handle that situation?
23. The clients of a financial firm like Questrade can display an arrange of emotions when they work with our Client Services team. How would you handle a situation where a client was very angry?
24. We pride ourselves on our interdepartmental teamwork here at Questrade. If hired for this role, what kind of team player could we expect you to be?
25. Our clients here at Questrade expect top-tier service and products and we will expect you to do just that in this role. Have you ever went the extra mile for a client when it wasn't expected? Why did you do so?
26. What programming languages would you consider yourself fluent in?
27. If hired for this role at Questrade, how would you help make sound investment decisions for our clients?
28. At Questrade, we pride ourselves on providing the best overall customer experience. Talk about your customer service experience and explain why it will help our clients here.

Questrade Interview Questions

1. How long will it take you to make a meaningful contribution to our team at Questrade?

2. In your current work, what are the important steps you take in the data validation process?

3. If hired here at Questrade to develop iOS and Android software, when would you use a fragment rather than an activity?

4. One huge philosophy that we believe in at Questrade is professional development. How have you worked to develop yourself professionally throughout your career?

5. What software programs do you use in your current work and how adaptable would you say that you are in learning and using new programs?

6. The next cloud engineer that we hire here at Questrade needs to be able build a system that can handle a high amount of traffic. How would you test our system's ability to handle large amounts of traffic?

7. If you joined the team here at Questrade, how would you build relationships with those that you would be working closely with?

8. List the top 3 skills that you have acquired in your last role.

9. Here at Questrade, we are expecting someone with strong leadership skills to take this role. How would you describe your management style?

10. When would an investment in commodities make sense for a client that you were working with?

11. In your work as a Portfolio Administrator, what kind events cause you the most stress on the job?

12. How do you believe your coworkers would describe you?

13. What SDLC models are you familiar in working with?

14. Talk about your experience in mortgage loan closing. How would this experience be beneficial to our team here at Questrade?

15. The day-to-day life at Questrade can be hectic and stressful at times. If hired for this role, how would you keep yourself motivated when working with stressed colleagues and pushy clients?

16. If I were to hand you $100,000 to invest today, where would you put that money and why?

17. If hired for this role with Questrade, how would you handle a large workload of clients working through a mortgage process?

18. In SQL, how do you explain the differences between clustered and non-clustered indexes? Can you name a time that you used each?

19. If you can, please provide your thoughts on the function of managed object context in developing iOS apps and software.

20. Think back over your career up to today and tell me about the most difficult day on the job you encountered. What made the day difficult and how did you handle that situation?

21. If hired to this role here at Questrade, what do you see as one initial hurdle you will have to overcome in your first weeks on the job?

22. If you were having an interaction with a client here at Questrade and you weren't able to answer their question or solve their problem on your own, how would you handle that situation?

23. The clients of a financial firm like Questrade can display an arrange of emotions when they work with our Client Services team. How would you handle a situation where a client was very angry?

24. We pride ourselves on our interdepartmental teamwork here at Questrade. If hired for this role, what kind of team player could we expect you to be?

25. Our clients here at Questrade expect top-tier service and products and we will expect you to do just that in this role. Have you ever went the extra mile for a client when it wasn't expected? Why did you do so?

26. What programming languages would you consider yourself fluent in?

27. If hired for this role at Questrade, how would you help make sound investment decisions for our clients?

28. At Questrade, we pride ourselves on providing the best overall customer experience. Talk about your customer service experience and explain why it will help our clients here.