Cyient Junior Data Analyst Interview Questions and Answers

Q1. What is duel axis
Ans. 
Dual axis is a feature in data visualization where two different scales are used on the same chart to represent two different data sets.
• Dual axis allows for comparing two different measures on the same chart

• Each measure is assigned to its own axis, allowing for easy comparison

• Commonly used in tools like Tableau for creating more complex visualizations
Answered by AI
Add your answer
Q2. What is scatter plot
Ans. 
A scatter plot is a type of data visualization that displays the relationship between two numerical variables through dots on a graph.
• Scatter plots are used to identify patterns and relationships between variables.

• Each dot on the plot represents a single data point with the x-axis representing one variable and the y-axis representing the other variable.

• The pattern of the dots can indicate the strength and direction of ...read more
Answered by AI
Add your answer

Q1. What is blending
Ans. 
Blending is the process of combining multiple data sources or datasets to create a unified view.
• Blending involves merging data from different sources to gain insights or make decisions.

• It helps in creating a comprehensive dataset by combining relevant information from various sources.

• Blending can be done using tools like Tableau, Power BI, or Python libraries like Pandas.

• For example, blending sales data from CRM with c...read more
Answered by AI
Add your answer
Q2. What is joining
Add your answer

Q1. Expected salary
Add your answer

Q1. About Excel,Power BI, Tableau,SQL
Add your answer

About Data Analyst Position

About the services and products provided by the company

Q1. Tell me about your current project? Have you used any AWS services?
Add your answer
Q2. Can you explain about EMR andEC2 instance?
Ans. 
EMR is a managed Hadoop framework for processing large amounts of data, while EC2 is a scalable virtual server in AWS.
• EMR stands for Elastic MapReduce and is a managed Hadoop framework for processing large amounts of data.

• EC2 stands for Elastic Compute Cloud and is a scalable virtual server in Amazon Web Services (AWS).

• EMR allows for easy provisioning and scaling of Hadoop clusters, while EC2 provides resizable compute...read more
Answered by AI
Add your answer
Q3. What type of schemas did you use for your project. (Star schema, Snowflake Schema)
Ans. 
I have experience working with both Star and Snowflake schemas in my projects.
• Star schema is a denormalized schema where one central fact table is connected to multiple dimension tables.

• Snowflake schema is a normalized schema where dimension tables are further normalized into sub-dimension tables.

• Used Star schema for simpler, smaller datasets where performance is a priority.

• Used Snowflake schema for complex, larger dat...read more
Answered by AI
Add your answer
Q4. Have you used python, pyspark in your projects?
Ans. 
Yes, I have used Python and PySpark in my projects for data engineering tasks.
• I have used Python for data manipulation, analysis, and visualization.

• I have used PySpark for big data processing and distributed computing.

• I have experience in writing PySpark jobs to process large datasets efficiently.
Answered by AI
Add your answer
Q5. Do you have any experience with serverless schema?
Ans. 
Yes, I have experience with serverless schema.
• I have worked with AWS Lambda to build serverless applications.

• I have experience using serverless frameworks like Serverless Framework or AWS SAM.

• I have designed and implemented serverless architectures using services like AWS API Gateway and AWS DynamoDB.
Answered by AI
Add your answer

Q1. 1. Command for find the 30 days old file in linux
Ans. 
Use the find command with the -mtime option to find files that are 30 days old in Linux.
• Use the find command with the -mtime option to specify the number of days.

• For example, to find files that are exactly 30 days old: find /path/to/directory -mtime 30

• To find files that are older than 30 days: find /path/to/directory -mtime +30

• To find files that are newer than 30 days: find /path/to/directory -mtime -30
Answered by AI
View 3 more answers
Q2. Questions on data modelling of CDR data
Add your answer
Q3. Command to copy the data from AWS s3 to redshift
Ans. 
Use the COPY command in Redshift to load data from AWS S3.
• Use the COPY command in Redshift to load data from S3 bucket.

• Specify the IAM role with necessary permissions in the COPY command.

• Provide the S3 file path and Redshift table name in the COPY command.

• Ensure the Redshift cluster has the necessary permissions to access S3.
Answered by AI
Add your answer

Q1. 1. Write SQL code.for ranking based on salary 2. Pyspark code to remove duplicates 3. Power bi question to add filter
Add your answer

Q1. What is with clause in SQL ?
Ans. 
WITH clause in SQL is used to create temporary named result sets that can be referenced within the main query.
• WITH clause is used to improve the readability and maintainability of complex SQL queries.

• It allows creating subqueries or common table expressions (CTEs) that can be referenced multiple times.

• The result sets created using WITH clause can be used for recursive queries, data transformation, or simplifying comple...read more
Answered by AI
Add your answer

Q1. ETL tool, triggers, integration runtime
Add your answer

Q1. Goals , salary , experience
Add your answer