Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      CPKC

      Is this your company?

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: CPKC reviews | CPKC jobs | CPKC salaries | CPKC benefits
      CPKC interviewsCPKC Data Specialist interviewsCPKC interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Top companies for "Compensation and Benefits" near you

      avatar
      ALSTOM
      3.5★Compensation and benefits
      avatar
      Hitachi Rail
      3.5★Compensation and benefits
      avatar
      Siemens Mobility
      3.8★Compensation and benefits
      avatar
      SYSTRA
      3.5★Compensation and benefits

      Data Specialist Interview

      12 Sept 2016
      Anonymous interview candidate
      No offer
      Negative experience
      Difficult interview

      Application

      I applied through a recruiter. I interviewed at CPKC

      Interview

      I applied through an agent and had two rounds of interviews. Unlike the normal interview processes I had had before, I was interviewed firstly by the hiring managers and his supervisor and key partners. It went pretty well and I could feel a lot of sparks. Just a few hours later I was invited to another round of interview with the "peers", which ended up a tricky experience. There was a panel of four people from a variety of technical backgrounds, which was just normal. But to my surprise, they asked a very wide range of questions, from database schema design, DB performance tuning, Dimensional Modelling, Log-based database replication, Dashboards design, to data mining models. They even asked me to explain how to create a predictive model using the data provided in the meeting. I was actually glad to be able to address all the questions thanks to my solid background and experiences in BI and DM areas. Only after finished the interview I realised it's not a usual case for a "data specialist" role. Seriously, it's intense enough for a full stack data scientist/ data engineer. Isn't it? A week after I heard from the agent that I was not offered, which was a bit disappointing but not too bad. But guess what, the reason they claimed is "inability to communicate with the team". Seriously? The candidate could have a great conversation with the bosses but was unable to communicate with the staffs? A candidate who had been working as a professional in the area for 10+ years? PS, one of the "peer" who interviewed me was just promoted as the head of the dept. Nice job. Congrats and good luck.

      Interview questions [1]

      Question 1

      Wide range of questions. Here're a few examples: What's the difference between database replication and ETLs? WHat's the best way to plot multi-dimension data chart? What's the difference between snow-flake and star schemas? Explain how to predictive model for a given business question? And much more.
      Answer question
      4