I applied online. I interviewed at MATRIX Resources
Interview
I received a call for a position that fit my skills. The recruiter set up the interview with the employer and I met with the hiring managers. Interview took about two hours. The next day I heard back from the recruiter that the company was interested in bringing me on.
Interview questions [1]
Question 1
Numerous questions about my skills and how long I have been doing software engineering work.
I applied through other source. The process took 1 week. I interviewed at MATRIX Resources (Israel, TX) in May 2022
Interview
I was in an interview for a job like this, they didn't even check my tests when they realized I couldn't do it full-time. They work crookedly, first they give you a test and then they find out if you are even relevant to the job.
If that's important to you, they have 3 stages in the test I took.
One part is logic questions.
Another part is planning questions, like recursion questions, for example.
And the other part was that they give you a certain section to study, like a certain syntax structure, and then try to figure out how to implement it in a certain order in the program.
It's very confusing.
I hope I helped.
Interview questions [1]
Question 1
Hi,
This is from an interview for a BI report developer position at Matrix.
1. What is denormalization, when and why would we use it?
2. List all the types of join and explain.
3. Explain: Star schema, snowflake, and the difference between OLTP and OLAP.
4. What is a Clustered Index and when would we use it?
5. Why wouldn't we want to implement foreign keys in fact.
6. What is a type 2 slow variable, list 2 types of SCD.
7. What is the difference between a unique key and a primary key.
SQL questions:
1. Name, subject, and grade table.
Output: Which students got 100 in both math and physics.
2. Display the second maximum in the table.
Programming questions:
1. When the number is a multiple of 3, print something, when the number is a multiple of 7, print something, and when it is a multiple of 3 and 7, print something else.
2. Display the 2 largest numbers in the array.