Data modeling is often asked for data engineer, data warehouse architect, or software engineer positions.
Good data modeling is essential for a consistent, efficient, bug-free, and long-lived data environment.
Make sure you are super familiar with concepts such as Dimensional Modeling Star Schema, Snow-Flaked Schema.
It’s possible to solve any given data request in an almost limitless number of ways, but when data needs to be extensible and maintainable throughout the systems, a good data model is critical to success. When it comes to handling a business requirement with an ability to handle large data, a deeper understanding of normalized (Third Normal Form) and denormalized design.
50% Salary Increase!
Thank you so much @Leon !
Your advice and coaching are extremely helpful for preparations for the interviews. The timeline and pacing you helped plan worked out very well.
It kept me on the right track. The exercise on coding and data analytics you recommended greatly sharpened my skills to solve the problems during the technical rounds.
The practice to communicate project work to peers is another highlight to help me earn higher score. Again thank you so much for all your advice!
Dream Job Offer from Apple!
Just wanted to share, I accepted an offer from Apple as a Data Engineer and wanted to offer a huge thank you to both of you guys.
Even though I only shared a small time with you both I benefited a lot from your platform and your mock interviews.
Some of the questions you gave during our Data Modeling with you Mike were presented verbatim.
The mock interview helped me do it in the right way
I did a SQL Mock interview on Instamentor to gain a better understanding of how SQL interviews are conducted.
The questions and tips he provided were incredibly helpful in my preparation.
My actual interview went in a similar manner and having done the mock interview helped me do it in the right way.
Shoutout to Leon Wei from instamentor.com.
Please do reach out to him if you're looking for career advice, general consulting, or resume feedback. I found his services extremely valuable.
And while you're at it, please do check out SQLPad if you're looking to refresh your SQL concepts.
Shout out to Leon Wei from instamentor.com, recommending him if you are searching for great advises and mentorship for your #datasciences career.
Dream Data Scientist job offer!
I've tried several sites to practice SQL and sqlpad.io is my favorite because the questions are well-designed to focus on the most important concepts. Some of the other sites are all over the place.
With sqlpad.io, I can focus on questions by skill level or topic, and the number of questions available is a reasonable amount to study for interview prep.
In addition, I got mentoring sessions with Leon and I was impressed at how helpful it was. Leon was calm and knowledgeable, which helped my nerves over my up-coming interview.
He really takes mentoring seriously and it makes a big difference. After practicing my SQL, I got my data science dream job!
Meticulously prepared and very professional
I signed up on Leon's service and was pleasantly surprised when he helped me out personally on the website. In two mock interviews with him from instamentor.com, he was meticulously prepared and very professional.
Throughout the interview he provided fantastic feedback and frameworks on how to be better prepared for both technical and behavioural aspects of an interview.
He is also a very positive and friendly person and I enjoyed all my interactions with him.
Shoutout to Leon Wei from instamentor.com, recommending him if you are searching for great advices and mentorship for you #datascience career.
What made the session successful was the effortlessness in being honest around Leon.
I had my first mentoring call yesterday. The session was to be for 45 mins but lucky for me, Leon did not have a hard stop. We had a detailed discussion around my career history, career transition, stuff I’m good at and enjoy doing/good at but don’t enjoy/not good at and want to improve, not good at and not interested in improving...you get the drift). Read more
Leon listened patiently, highlighted areas I needed to work on, pointed out practical considerations, and made gentle suggestions on handling a couple of situations I had bombed (salary negotiation was one).
We covered a lot of ground and had concrete to-dos at the end of the call, but what made the session successful was the effortlessness in being honest around Leon. A mentor needs to identify what is holding the mentee back in their career, and their advice can only be as good as the inputs we give them. Leon made it easy to be authentic. I’ll keep you all posted on my journey!
I landed the job I wanted at a FAANG company
Joining INSTAMENTOR.COM was very easy, and I quickly found a mentor who is a good match. My mentor was amazing and friendly. He knew all the details and important things that I needed in my job search. I landed the job I wanted at a FAANG company, and we’re still in touch.
Instamentor is understanding and accommodating
Although my first mentor was great, I decided to pursue a different career track mid-way. They quickly found me a different mentor after I contacted them, without extra charge.
This platform and my mentor have made the job search so much easier
This platform and my mentor have made the job search so much easier for me. All the support and insights from my mentor made me feel so much readier for my interview. This made me walk in completely relaxed and natural in the interview room which got me the job!
Instamentor helped me connect with a mentor from my dream company
Instamentor helped me connect with a mentor from my dream company. I learned a lot about the culture of the company, the good and bad about working there. He also help me prepare my job interviews by providing mock interviews and resume feedbacks.
Instamentor hooked me up with a mentor who changed my career
I’m a business analyst and always want to become a data scientist. I’m really glad Instamentor hook me up with a mentor who successfully changed my career path. With my mentor’s guidance, I’m on track learning coding languages that are crucial as a data scientist. The most important thing is that I have gained courage and confidence on my career development.