Gibraltar Technologies Data Analyst Interview Questions and Answers

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Add your answer

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Basic questions can be attempted easily

2 coding questions edge cases were hard to find

Q1. Resume based questions and project idea breifing
Add your answer
Q2. Have any questions for interviewer
Add your answer

Q1. Load data from hdfs using python
Ans. 
Use PyArrow library to load data from HDFS in Python
• Install PyArrow library using pip install pyarrow

• Use pyarrow.hdfs.connect to connect to HDFS

• Use pyarrow.parquet.read_table to read data from HDFS
Answered by AI
Add your answer
Q2. Query to find the top three salaried employees of each department
Ans. 
Query to find the top three salaried employees of each department
• Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary

• Partition the data by department and order by salary in descending order

• Filter the results to only include rows where the row number is less than or equal to 3
Answered by AI
Add your answer

It was simple but lengthy

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. About resume and technical
Add your answer

Q1. Tableau, SQL related question
Add your answer

Q1. Tell me about your self
Add your answer
Q2. If experienced, then Tell me about your previous job role and responsibilities of previous job role.
Add your answer
Q3. Tell me about your resume.
Ans. 
My resume showcases my experience in data analysis, including proficiency in SQL, Python, and data visualization tools.
• Proficient in SQL for data querying and manipulation

• Skilled in Python for data analysis and automation

• Experience with data visualization tools like Tableau and Power BI

• Strong analytical and problem-solving skills

• Previous projects include analyzing sales data to identify trends and patterns
Answered by AI
Add your answer
Q4. Tell me about your memorable Moment of life.
Ans. 
My memorable moment was when I graduated from college.
• Graduating from college after years of hard work

• Celebrating with family and friends

• Feeling a sense of accomplishment and pride
Answered by AI
Add your answer

Q1. Automation done
Add your answer